Inside Microsoft Excel

Manipulate PivotTable data with slicers

Inside Microsoft Excel

by Kara Hiltz

PivotTables with too much information can overwhelm users. Slicers allow you to filter PivotTable data while seeing exactly what data is showing and also updating multiple PivotTables. Report filters may suit your needs just fine, but slicers can help you turn your Pivot data into a comprehensive Excel dashboard that’s perfect for analyzing data, as shown in Figure A.

We’ll show you how to add slicers to your existing PivotTable and compare slicers[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)