Excel 2016 Data and List Management
Lesson 2 – 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 60
OFFICEPRO, Inc.
Made with FlippingBook - professional solution for displaying marketing and sales documents online