• Home
  • Training
    • Upcoming Seminars
    • Financial Modeling, Risk Analysis and Advanced Excel seminars
    • Data Analytics & Business Intelligence
    • HR, Finance
  • Services
    • Certifications
      • Financial Modeling Institute 
      • The FAST Modeling Standard
        • FAST Level 1 Certification
    • Data Analytics & Business Intelligence solutions
    • Financial Model Development
    • Financial Model Review and Auditing
  • Blog
  • About
    • Training Camps
    • Accredited Training Provider
    • Financial Modeling & Business Analytics Meetups
    • FAQ
  • Contact Us

Upcoming Seminars

    • Home
    • Training
      • Upcoming Seminars
      • Financial Modeling, Risk Analysis and Advanced Excel seminars
      • Data Analytics & Business Intelligence
      • HR, Finance
    • Services
      • Certifications
        • Financial Modeling Institute 
        • The FAST Modeling Standard
          • FAST Level 1 Certification
      • Data Analytics & Business Intelligence solutions
      • Financial Model Development
      • Financial Model Review and Auditing
    • Blog
    • About
      • Training Camps
      • Accredited Training Provider
      • Financial Modeling & Business Analytics Meetups
      • FAQ
    • Contact Us
Financial Arena
Financial Arena
  • Home
  • Training
    • Upcoming Seminars
    • Financial Modeling, Risk Analysis and Advanced Excel seminars
    • Data Analytics & Business Intelligence
    • HR, Finance
  • Services
    • Certifications
      • Financial Modeling Institute 
      • The FAST Modeling Standard
        • FAST Level 1 Certification
    • Data Analytics & Business Intelligence solutions
    • Financial Model Development
    • Financial Model Review and Auditing
  • Blog
  • About
    • Training Camps
    • Accredited Training Provider
    • Financial Modeling & Business Analytics Meetups
    • FAQ
  • Contact Us
ONLINE TRAINING

Data Analysis

Financial Arena > Blog > Data Analysis

Upgrade Your Data Analysis Game with Power Query

  • 08/16/2023
  • Data Analysis
Attention all analysts and business professionals!🙌  Are you looking to take your reporting to the next level, but tired of manual data manipulation in Excel? Then, it’s time to...
Read More

Still using VLOOKUP? The easiest way to compare & combine data is by using Power Query! 

  • 08/14/2023
  • Data Analysis
VLOOKUP and other lookup functions are frequently used to combine data in a new table. This could drastically enlarge the Excel sheet and slow it down.   GOOD NEWS! VLOOKUP...
Read More

Power BI / Power Query Essentials – Import a folder with multiple csv files

  • 08/14/2023
  • Data Analysis
What happen when we want to import multiple files?  For example many csv files that contain data on the sales of different months of a company?  The answer is:...
Read More

Latest Posts

  • Some useful tips from for those sitting for the upcoming #AFM certification exam.
  •  Do spreadsheets need reviewing? 
  • Best Practice Tips to Advance your Financial Modeling Skills!
  • Avoiding Common Pitfalls in Financial Modeling: Best Practices and Solutions
  • Mastering Team Meetings: 5 Tips for Success

Categories

  • Business Tips
  • Data Analysis
  • Financial Modeling

Tags

Big Data Excel Lookup functions Power BI Power Query Vlookup
Financial Arena
Our mission is to promote industry best practices and help our clients upgrade their financial modeling, budgeting, data analytics and reporting skills.

Discover More

Contact Info

  • 207 Regent Street, 3rd floor, London, W1B 3HH
  • Valaoritou 7, Chalandri 152 33, Greece
  • +44 20 70 97 5280
  • customercare@financialarena.co.uk

Company

About Financial Arena
Privacy Policy
Terms & Conditions

©Copyright 2023 Financial Arena LTD. Company Number 10474694, England.

Powered By infoGRID# P.C.C.