Pro lesson · 4 exercises · first one free
Summaries without formulas: pivot tables
What a pivot table does, when to use one, and how to check its totals with a formula.
Functions you'll practice
How the lesson works
4 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly, with hints when you're stuck.
The lesson starts with
A pivot table groups rows by one or more fields (such as Region) and totals a number field (such as Units) for each group. You drag fields into place rather than writing formulas.Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 4, 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.