Module 03 · Clean it in Power Query

Tour the Power Query Editor

Get to know the window where the combined data gets cleaned, then give the query a short name.

Step by step7 minLesson 10 of 37 Members

In Module 2 the 12 files were combined, but the data hasn’t been cleaned yet. All cleaning happens in the Power Query Editor: every click you make is recorded as a step and re-run automatically on every refresh, so you only do the work once. In this lesson you open the editor, get to know its 8 key areas and rename the query to Expense.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

4 steps with a numbered picture
All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
A new Excel & dashboard template every day, with resell rights
Take paid client projects on the Project Board

Become a member & unlock all Already a member? Sign in

One payment for 12 months, no automatic renewal. Back to the free lessons