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

Use Slicers to Filter the Data Before You Begin: Click on the PivotChart. The PivotChart Tools should be available.   1. Try it: Insert Slicers Go to PivotChart Tools ->Analyze-> Filter. Click on Insert Slicer.     What Do You See? You will be prompted to select the Fields you want to include. Select the following fields: Category Product   Please click OK. Keep going... PivotChart Tools ->Analyze ->Filter-> Insert Slicer