Slicers
Slicers make filtering data in PivotTables even easier. Slicers are basically just filters, but they’re easier and faster to use, allowing you to instantly pivot your data. If you frequently filter your PivotTables, you may want to consider using slicers instead of filters.
To add a slicer:
Select any cell in the PivotTable.
From the Analyze tab, click the Insert Slicer command.
Screenshot of Excel 2013
A dialog box will appear. Select the desired field. In our example, we’ll select Salesperson, then click OK.
Screenshot of Excel 2013
The slicer will appear next to the PivotTable. Each selected item will be highlighted in blue. In the example below, the slicer contains a list of all salespeople, and six of them are currently selected.
Screenshot of Excel 2013