Free demo · Google Sheets · Lesson 9 · Advanced · Pivot tables
A pivot table: answers from a long list
A pivot table turns a long list into a small table of answers. No formulas: you only choose what goes in the rows and what to add up.
- 1A clean list: headings in row 1, one record per row
- 2Click in the list › Insert › Pivot table
- 3Create: a new sheet with the Pivot table editor
- 4Rows › Add › Course: one row per course
- 5Values › Add › Fee: SUM of Fee, with a Grand Total
- 6Filters › Add › Paid › only Yes
- ✓Edit the list: the pivot table updates by itself