Excel like a finance pro.
Pivot tables · Filtering
Slicers
Clickable buttons that filter one or more pivots at once and show what is filtered.
When to use it
Slicers are clickable buttons that filter one or more pivots and show at a glance what is filtered. They are the standard control for dashboards.
The shape of it
- How
PivotTable Analyze, Insert Slicer, pick the field. Connect it to other pivots via Report Connections.
Worked examples
Add a slicer
PivotTable Analyze, Insert Slicer, check Region, OK → A panel of region buttons that filters the pivot
Click, Ctrl + click for several.
Connect pivots
Right-click the slicer, Report Connections, check other pivots → One slicer drives several pivots
Dashboard control.
Hide empty items
Slicer, Slicer Settings, Hide items with no data → Buttons for empty items disappear
Tidy.
Worth knowing
- Pivots must share a cache (same source) to share a slicer.
- Slicer styles and column counts are on the Slicer tab.
- Slicers work on Tables too.
Where it goes wrong
- Slicers on large fields with thousands of items are slow and unusable.
- A slicer connected to a pivot that was deleted keeps a dead connection.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.