Excel 2016 Tips and Tricks

Lesson – Creating/Revising PivotTables

Excel 2016

5. Click the

button.

6. Hide/Show the desired Slicer box.

7. If desired, edit the number of Columns to display.



S TEP - BY -S TEP

Edit a Slicer.

If necessary, open the PIVOT2.xlsx file and go to the PIVOT2 worksheet. The Slicers Product and Sales are displayed.

Steps

Practice Data

1. Select the Product Slicer.

Click

The Month slicer is selected.

2. Click the Slicer Tools Options tab. The Analyze ribbon is displayed. 3. Click in the Slicer Caption field in the Slicer group. The insertion point displays. 4. Change the Slicer caption by clicking in the Slicer Caption field in the Slicer group. The caption field is ready for editing. 5. Select a Quick Style in the Slicer Styles Group . The box is formatted to match the selected style 6. Click to Open the Selection Pane in the Arrange Group . The Selection and Visibility Pane is displayed on the right.

Click Slicer Tools Options tab Click in the Slicer Caption field after Product

Type: Sports Products

Select: Slicer Style Dark 1 (first row, first line in Dark)

Click

7. Click the hide icon for the Slicer Purchaser.

Click

The Purchaser slicer is removed from the worksheet.

Page 126

OFFICEPRO, Inc.