top of page

Microsoft Excel articles et conseils

Excel Icon.png
Back Button

© 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!

Slicers 1.png

WITH SLICERS:

Here is the same report, using interactive City and Category Slicers, displayed on the right, which clearly display the applied filters.

Slicers 2.png

Use multiple Slicers with charts to create easy-to-use interactive dashboards:

Slicers 3.png
bottom of page