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

Analyze: Slicers Slicers are a new way to filter the data in PivotTables and PivotCharts. The previous pages walked you through the steps of building a complex PivotChart with multiple filters. It is effective, but rather clumsy to work with.   The next couple of pages begin with a new PivotChart and demonstrates how you can use the Slicers.   1. Try it: Create a new PivotChart Go to the Original Data spreadsheet. Select All. Go to Insert-> Charts->PivotChart. Click on PivotChart.   You will be asked to confirm the location of the data and whether you would like to place the new PivotChart in a New Worksheet. Click OK. Keep going... Insert-> Charts->PivotChart->PivotChart