Master Excel Power Query
Beginner to Advanced

Things participants accomplish after the course:

  • Import, transform and clean large data from different sources (Excel, csv, Json, etc.)
  • Combine data from multiple Excel workbooks into a single File (or Pivot Table)
  • Consolidate data from all files in a folder (and make reports as you need)
  • Understand and write your own Custom Power Query M functions to do tasks you can’t easily do with the interface
  • Use Excel’s Data Model and Power Pivot to Create Relationships between your data
  • Create an interactive Excel Dashboard with Power Query, Data Model, Pivot Tables and slicers

What you'll learn

  • Master Power Query in Excel
  • Create Modern Excel Dashboards with Power Query and Excel’s Data Model
  • Reduce Hours of Work to One Click (Simply press Refresh)
  • Automate the process of Importing, Cleaning, and Combining data
  • Learn Power Query M language and create your own M Functions
  • Load data into Excel from Multiple Sources such as csv, JSON, excel, etc
  • Learn how to Avoid future errors by creating Robust Solutions

People continue doing things the old “manual” way, Or the “complex” way with difficult formulas.

Power Query is like an Instant Miracle Cure to your difficult compliance and audit problems:

  • You can quickly combine and consolidate large data from different sources like Excel, Json, text files, CSV (Plus many more).
  • You can convert downloads from your ERP system into information you can use.
  • Replace complex Excel formulas with a click of a button.
  • Turn complex data transformations that took forever to do (such as unpivoting data), to just a few clicks.

And these are just a few examples of what it can do!

On top, will explain how can your actions can be recorded so whenever you get new data, all you have to do is click Refresh!

Plus learning Excel Power Query will be more fun and effortless than you think.

You’ll get the tools to make a big difference at your workplace.

The course will be split in 2 parts: Essentials and Advanced.

  • Just from the Power Query Essentials you’ll be able to solve many problems and make a meaningful impact in your work
  • In the Excel AdvancedPower Query section you’ll tackle more complex scenarios. The real world comes with messy data. You might need to write custom M functions to transform the data to the way you need. In this section you will also learn how Power Query M thinks and works.

( Will also try to cover live problem solution in the session)