Introduced in Excel 2010, Slicers are a powerful new way to filter pivot table data. This short video shows how they work, and there are written steps too.
Video: Slicers in Excel 2010
In this video you can see the steps for adding a slicer to a pivot table in Excel 2010, and then using slicers to filter the data. The written instructions are below the video.
How to Add a Slicer
It’s easy to add a Slicer:
- Select a cell in the pivot table
- On the Ribbon’s Insert tab, click Slicer.
- In the list of pivot table fields, add check marks for the slicer(s) you want to create
- Move and resize the slicers, if necessary, so they fit on the empty areas of the worksheet
- Click on an item in a Slicer, to filter the pivot table. Other Slicers will show related items at the top.
