Excel 2016 Tips and Tricks

Lesson – Creating/Revising PivotTables

Excel 2016

Slicers filtering in a PivotTable



P ROCEDURES

1. Click in a PivotTable. 2. Click the Analyze tab.

3. Click the icon . 4. Select the fields to be used as Slicers. 5. Click .



S TEP - BY -S TEP Filter a PivotTable using Slicers.

If necessary, open the PIVOT2.xlsx file and go to the PIVOT2 worksheet.

Steps

Practice Data

1. Select any cell in the table.

Click anywhere in the table

The PivotTable contextual tabs are displayed.

2. Click the Analyze tab.

Click Analyze

The Analyze ribbon is displayed.

Page 122

OFFICEPRO, Inc.