Excel 2016 Tips and Tricks

Excel 2016

Lesson 4 – Creating/Revising PivotTables

Steps

Practice Data

8. Change the number of columns

Change the Columns to :

displayed by clicking the spin box next to Columns in the Buttons Group. The column field is changed to 2.

Practice the concept : Add the Purchaser slicer to the worksheet. Select a Slicer style for Year and Region . Hide all Slicers.

Close the Selection and Visibility pane.

U SING M ULTI -S ELECT S LICERS  D ISCUSSION

One of the new PivotTable features in Excel 2016 is the ability to select multiple slicers to filter your PivotTable. Previously, you could select multiple slicers by pressing the control key and selecting them or you could open a drop-down list to filter the table.  P ROCEDURES 1. In Excel, click the Analyze tab.

2. In the Filter group, click Insert Slicer .

3. From the Insert Slicers dialog box, select the slicers you want to open.

4. Click OK .

5. In the slicer dialog box, click Multi-Select

.

6. Click the filter Analyze you want in each slicer dialog box.



S TEP - BY -S TEP

Add Multiple Slicers.

Steps

Practice Data

1. At the top of the Sports Product slicer, click the Multi-Select button. The button turns yellow indicating Multi-Select is active.

Click the Multi-Select button on the Sports Product slicer

OFFICEPRO, Inc.

Page 127