Excel 2016 Tips and Tricks

Lesson – Creating/Revising PivotTables

Excel 2016

Using Slicers to filter the Northeast Region



P ROCEDURES

1. Select the Slicer Box to be filtered.

2. Click the fields to be filtered.

3. To remove filters, click the Clear Filter button.



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

Steps

Practice Data

1. In the Region Slicer select a field.

Click

The Slicer list shows the selected field in color other months are in white

2. In the Product Slicer select a field. The Slicer list shows the selected field in color other regions are in white. 3. Use the Clear Filter button to show all Products and Sales. All the buttons are displayed in color in the Slicer boxes.

Click

Click

Practice the concept : Select another Product button and Year button to see how the PivotTable behaves.

Page 124

OFFICEPRO, Inc.