Excel 2016 Tips and Tricks

Excel 2016

Lesson – Creating/Revising PivotTables

Steps

Practice Data

1. Select the PivotTable Tools contextual Design tab. The Design tab is displayed. 2. Select the More button in the PivotTable Styles group.

Click Design

Click PivotTable Styles

The PivotTable Styles gallery opens.

3. Select the desired style.

Scroll as necessary and click Pivot Style Light 19

The PivotTable Styles gallery closes and the style is applied to the PivotTable report.

C REATING S LICERS  D ISCUSSION

Use Slicers to further filter the data in PivotTables. After creating a PivotTable, the PivotTable contextual tools displays the Slicers button on the Analyze tab. When you click the Slicers icon it will give you a list of all the PivotTable fields available. Use a check mark to indicate which fields to use for Slicers. In addition to quick filtering, Slicers also indicate the current filtering state by showing the labels which are active and greying out the non-filtered fields. This makes it easy to understand what exactly is shown in a filtered PivotTable report.

Slicer boxes appear with buttons you can click to filter the PivotTable data. You can modify these boxes with Slicer styles, resizing to fit labels, and adjusting how the slicer labels are displayed in columns

OFFICEPRO, Inc.

Page 121