PivotTables
IntermediateBeginner
10 questions, about 17 minutes
Summarise thousands of rows without typing a single formula.
What we'll do
- Choosing rows and values
- Sum, count and average
- When a PivotTable beats formulas
What you'll use
- A pivot table
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself