Pivot Tables

What Pivot Tables Do

A PivotTable summarizes thousands of rows in seconds: totals by category, counts per region, averages by product. You drag fields into areas and Excel aggregates instantly.

Building One

1. Select your data (headers included) → Insert → PivotTable.
2. Put a field in Rows (e.g. City) and a numeric field in Values (e.g. Amount - defaults to Sum).
3. Add Columns (e.g. Status) and Filters (e.g. Year) as needed.

The PivotTable Areas

• Filters - whole-pivot filters above the table.
• Columns - spread values across the top.
• Rows - group values down the side.
• Values - the numbers to compute (Sum, Count, Average, Min, Max via Value Field Settings).

Refreshing and Grouping

• Right-click → Refresh (or Data → Refresh All) after editing source data.
• Group dates: right-click a date field → Group → Months/Quarters.
• Group numbers into ranges (e.g. age buckets) the same way.

PivotCharts and Slicers

With a PivotTable selected, Insert → PivotChart draws a chart that filters with the table. Add Slicers for clickable filters that look like buttons - the best UX for dashboards.

Best Data Habits for Pivots

• One header row, no merged title cells, no blank rows/columns.
• Consistent casing and no stray spaces in category names.
• Clean data = clean pivots. Messy data = wrong sums.

Key Points

• Pivots summarize without formulas - drag, drop, done.
• Values area defaults to Sum; switch to Count for yes/no questions.
• Slicers + PivotCharts turn a pivot into an interactive dashboard.