Excel 2016 Tips and Tricks

Excel 2016

Lesson – Creating/Revising PivotTables

Steps

Practice Data

3. Select the top half of the Insert Slicers button in the Tables group. The Insert Slicer dialog box appears.

Click

4. Select the desired fields to be filtered. The desired fields have check boxes selected. 5. Close the Insert Slicers dialog box. The two Slicers are displayed on the worksheet.

Select: Product, Region and Year

Click

Practice the concept : Add another Slicer to the worksheet. Select the Purchaser field.

F ILTERING WITH S LICERS  D ISCUSSION

The benefit of using a Slicer is to see the selections applied to a field that is being filtered. For instance, in our example Region in the Report Filter (top left corner of every PivotTable) has multiple Analyze. If you wanted to filter on multiple Analyze, it simply says “multiple items” but you need to click the filter arrow to see which regions are being filtered. With Slicers, you can see in the boxes which regions are being filtered.

Data that is not selected for filtering is displayed in white. Some buttons in the Slicer box will appear greyed out. This happens when the particular data is not applicable. For instance, if you are tracking Sales by Month for a particular purchaser, they may not have made purchases for six months. The Slicer box will grey out the months where there is no data.

When you click the Clear Filter icon all the buttons are visible in full-color.

OFFICEPRO, Inc.

Page 123