Slicers — Making Pivot Tables Easier

You have perfected your data analysis with a pivot table and you are about to share with other users. Slicers make Pivot Tables easier for other users to filter data in the table.

Slicers are a pop-up dialog box which allow the user to click on button to quickly filter the data.

To insert:

1. Click in your Pivot Table.
2. From the Pivot Table Tools > Analyze toolbar, Click Insert Slicer.
3. Select the fields to provide a filter.

4. To filter select the value on the slicer dialog box.

To select multiple values, click on the Multi-Select icon then click on the desired values. To clear the filter, select the Clear Filter icon with the red x to display all values.