Pro lesson · 5 exercises · first one free
Power Query and Power Pivot: what they are for
About this lesson
Know when to import and clean data with Power Query, and when to model several tables with Power Pivot.
Statistics, charts and tables · 5 short exercises in a live spreadsheet: answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Finding where Power Query lives
- Choosing Power Query over manual cleaning
- Knowing that the source data stays untouched
- Choosing Power Pivot for several related tables
- Spotting the limit of a plain worksheet
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 5, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.