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[…]