Free demo · Microsoft Excel · Lesson 8 · Advanced · PivotTables
A PivotTable in a minute: summarise a list without formulas
A PivotTable turns a long list into a short summary. Choose a field for the rows and a field for the values, and Excel does the adding and the counting.
- 1Click any cell in the list, then Insert › PivotTable
- 2Keep New Worksheet, click OK: an empty PivotTable and the PivotTable Fields pane
- 3Tick Course: it goes to Rows, one row per course
- 4Tick Fee: it goes to Values and is added up
- 5Drag Child into Values: names are counted
- ✓88 rows summarised, no formulas. List changed? PivotTable Analyze › Refresh