Once you have a PivotTable, these features make it interactive and insightful.
A dashboard with slicer buttons filtering a pivot summary
Drop a date field into Rows and Excel can group it automatically:
Right-click a date → Group → Months / Quarters / Years
| Year | Quarter | Sales |
| 2026 | Q1 | 45200 |
| | Q2 | 51800 |
Numbers can be grouped into bins too (e.g. ages 0–9, 10–19…).
A slicer is a clickable filter panel. Far friendlier than dropdown filters.
PivotTable Analyze → Insert Slicer → tick "Region"
[ Region ]
[ North ] [ South ] [ East ] [ West ] ← click to filter the pivot
One slicer can control multiple PivotTables/charts at once: right-click the slicer → Report Connections → tick each pivot. This is the secret to interactive dashboards (next chapter).
PivotTable Analyze → Insert Timeline → pick a date field
A slider lets users filter by month/quarter/year visually.
Need a metric that's not in the source — like Profit = Sales − Cost? Add it inside the pivot:
PivotTable Analyze → Fields, Items & Sets → Calculated Field
Name: Profit
Formula: = Sales - Cost
The new field behaves like any other value field and respects all filters.
Double-click any value in a PivotTable and Excel creates a new sheet listing the exact source rows behind that number — instant audit trail.