PivotTables · Easy
When would you use a PivotTable, and what are its main parts?
Short answer
Use a PivotTable to summarise large tables quickly — totals, counts and averages by category — without writing formulas. Its parts are Rows, Columns, Values and Filters. Slicers add interactive filtering, and grouping lets you roll dates up to months or quarters.
Detailed answer
- Convert your data to a Table first so the pivot picks up new rows.
- Use Value Field Settings to switch between Sum, Count, Average and to show values as % of total.
- Refresh after source data changes — pivots don't update automatically.
- Calculated fields work for simple ratios, but be careful: they compute on sums, not row by row.