Glide Training Logo

Excel How-To Guide: PivotTable Slicers

  

Written by Jane Hames

PivotTables are one of Excel’s most powerful tools, designed to make data analysis quick & easy. This How-To Guide is aimed at those who already use PivotTables and want to learn some new techniques.

In a PivotTable you can apply filters to your data using the report filter and by filtering within the row or column fields. When using multiple items in a report filter it is not obvious which criteria you have specified and likewise with the row and column filters. So what can you do?

The answer is to use Slicers in Excel 2010 and this is how to do it:

  1. Ensure that you are not working in compatibility mode. (If you are, convert your workbook first.)
  2. Refresh the PivotTable by clicking on the Refresh button on the PivotTable tools, Options tab.
  3. refresh button

  4. Click on the Insert Slicer button and select Insert Slicer.
  5. insert slicer button
    insert slicers dialog

  6. Tick the fields you want to use to filter with, and a Slicer box will be displayed with items in the fields.
  7. list of authors

  8. Specify your criteria by clicking on the item, or hold the Ctrl key and click to select more than one. The PivotTable will change to show only the data meeting your criteria.
  9. To clear a Slicer filter, click on the clear filter button in the top right of the slicer box.
  10. To remove a slicer box, click on the edge of the box and press Delete on the keyboard.


previous post: Software Secrets – Microsoft Project

next post: Excel How-To Guide: Sorting (without messing up your data!)

Why choose Glide?

Our Unique Approach

Our Unique Approach

We work on a bespoke, requirements-led basis rather than offer a set range of courses. We will work with you to identify your specific requirements and objectives before any training is delivered. That way you can be sure that training will always deliver exactly what you're looking to achieve.

View details »

Our Low Prices

Our Low Prices

We deliver all our on-site training at our customers' premises. Not only does that avoid any travel inconvenience for your team, but also it means we don't have the overheads required to maintain a dedicated training centre - and in turn we are able to pass these savings on to you.

View details »

Our Expertise

Our Expertise

Our trainers have designed and delivered IT training for a wide range of organisations and people including accountants, lawyers, data analysts, sales consultants and buyers. Clients benefit from our our ability to find creative solutions to their problems based on many years of experience.

View details »

Balderton Logo
Kreston Reeves Logo
National Institute of Health Research
England Rugby
Caravan and Motorhome Club Logo
Bird and Blend Logo
Ropetackle Logo
RBLI Logo
Farnborough Airport Logo
Kroll Logo
The Apprenticeship College Logo
Shoreham Port Logo
Adur and Worthing Councils Logo
Balderton Logo
Kreston Reeves Logo
National Institute of Health Research
England Rugby
Caravan and Motorhome Club Logo
Bird and Blend Logo
Ropetackle Logo
RBLI Logo
Farnborough Airport Logo
Kroll Logo
The Apprenticeship College Logo
Shoreham Port Logo
Adur and Worthing Councils Logo