Power QueryExercises

Power Query guides for Excel and Power BI

35 practical guides for specific jobs: merge or append, unpivot, locale conversion, combining monthly files, fixing errors and preparing for analyst tests. Every M example on these pages is run by the simulator, and task guides link straight to the exercise that practises the skill.

Looking for something specific? Search lessons, resources and references, or follow the lessons in order.

Guides

Comparisons

Troubleshooting

Recipes

Cheat sheets

Checklists

Interviews and practical tests