Pivot Table Slicers
© 2013 DJH Training & Application Solutions Inc.
Slicers are a fantastic feature introduced in Excel 2010. They allow easy and clear filtering of pivot table reports and charts, as illustrated below.
LET'S LOOK AT FILTERING WITHOUT SLICERS:
When using regular Pivot Table filters, it isn't clear what is included when filtering multiple items, as demonstrated in the example below. Which cities? Who knows?
Most people only use the 'tip of the iceberg' when it comes to pivot table capabilities - they can do so much more with a little tweaking. Are you using them to your advantage? If not, and you'd like to learn more, contact us!
Here is the same report, using interactive City and Category Slicers, displayed on the right, which clearly display the applied filters.
Use multiple Slicers with charts to create easy-to-use interactive dashboards: