Skip to content

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.