Pivot Table Exercises & Practice
A pivot table summarizes a long list of rows into a compact table of totals, counts, or averages, grouped by whatever field you choose. Under the hood, every number a pivot table shows is the same thing a SUMIF, COUNTIF, or AVERAGEIF formula would compute — a pivot table just builds the grouping and the formula for you automatically.
Worked example
Pivot equivalent: =SUMIF(Region, "East", Sales)The "East" row total in a pivot table grouped by Region, summing Sales
Understanding the SUMIF/COUNTIF/AVERAGEIF underneath makes it much easier to debug a pivot table that looks wrong.
Why practice the formulas before the pivot UI
The pivot table dialog (drag Region to Rows, Sales to Values) is quick once you understand what it's computing — but it's easy to drag the wrong field or pick Count when you meant Sum without noticing.
If you can already predict the number a SUMIF/COUNTIF/AVERAGEIF would give for a group, you'll immediately spot when a pivot table is misconfigured.
The three summary functions pivot tables use most
Sum — totals a numeric field per group (equivalent to SUMIF).
Count — counts rows per group, including text (equivalent to COUNTIF).
Average — the mean of a numeric field per group (equivalent to AVERAGEIF).
Practice this for real
Try the "What a Pivot Table Computes" exercises
Type the formula into a real spreadsheet and get instant feedback.