graphic2
graphic1
pic

Exam 77-427 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.2 Create and Manage PivotTables: Filter a Slicer

Hello, Slicers!

2. What Do You See? At the top of the Slicers is a Header. Next to the name on the Header is a Filter.

 

Below the Header you should see a list of Items. You can use the Items to filter your data. To the right of the Item list, on the scroll bar, is the Clear Filter button.

What Else Do You See? There are two Slicers: One for the Category and one for Product.

The Slicers may be placed on top of the PivotChart. You can move the Slicers if you wish.

Keep going, keeeeeeeep going...

PivotChart Tools ->Analyze ->Filter ->Insert Slicer