Module 04
Excel — Cleaning & Power Query
The unglamorous half of every data job, and the part that Power Query turns from three hours a month into one click.
4 topics ~20 h estimated learning time
Comes after01. Excel — First Steps
Unlocks06. Excel — Automation
Sign in to keep your progress.
Ready to start
- 4.1 Getting data in from anywhere
Core · 4 h
- 4.2 Power Query: cleaning without retyping
Core · 6 h
- 4.3 Reshaping and combining with Power Query
Advanced · 5 h
- 4.4 The data model and a first taste of DAX
Advanced · 5 h