Power QueryExercises

Learn Power Query for Excel and Power BI

80 free lessons in 20 modules, about 13 hours of reading in all. Each lesson explains one skill with examples that run in our simulator, then links to graded exercises so you practise it straight away. No account is needed to read.

Start at module 1 if you're new to Power Query; the M language lessons (let, records, lists, custom functions) come later and build on the editor skills. Prefer a guided order? Follow the foundations path.

Every lesson ends with Where to find this in Excel: the ribbon path in Excel's Power Query editor, checked against Microsoft's documentation, or a note that the step is written in M.

Module 1: How Power Query thinks

Module 2: Importing and inspecting data

Module 3: Data types, locale and nulls

Module 4: Working with columns

Module 5: Filtering and sorting rows

Module 6: Text transformations

Module 7: Numbers, dates and conditional columns

Module 8: Profiling, errors and validation

Module 9: Duplicates and keys

Module 10: Fill down and report layouts

Module 11: Appending tables

Module 12: Merging (joining) tables

Module 13: Group by and aggregation

Module 14: Pivot and unpivot

Module 15: Combining files and parameters

Module 16: M language basics

Module 17: Functions, each and scope

Module 18: Nested data and JSON

Module 19: Refresh robustness and performance concepts

Module 20: Projects, debugging and interviews