CODE FOR FACEBOOK SHARE BUTTON
Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

Excel Pivot Table Slicers

By Deborah J. Sparks

Slicers are a fantastic feature introduced in Excel 2010. They allow easy and clear filtering of pivot table reports and charts, as illustrated below.

WITHOUT SLICERS:

In previous versions of Excel, 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?

WITH SLICERS:

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:

Note: Excel 2013 also includes Slicers for tables.



More Newsletter Articles

© 2013 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 20 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.