Excel 2016 Tips and Tricks

Excel 2016

Lesson 4 – Creating/Revising PivotTables

Steps

Practice Data

5. Select OK .

Click

The Show Report Filter Pages dialog box closes, and a report filter field report is created for each item in the report filter field.

View each of the report filter field reports.

Display the Sheet1 worksheet. Double-click the detail item in cell C7; a new worksheet is inserted to display the data item details in a table. Then, display the Sheet1 worksheet again and double-click the SportsCity Grand Total in cell M20; again, a new worksheet is inserted to display the data item details in a table.

F ORMATTING A P IVOT T ABLE R EPORT  D ISCUSSION

You can use the Layout and the PivotTable Styles features to give a PivotTable report a more professional look. PivotTable Styles provides many formats, which include cell shading, font style and color, and borders.

There are three PivotTable report Layout formats. The default style of Compact indents inner fields, allowing you to see more information at glance. The two alternatives are Outline and Tabular .

You can also manually change the format of text and numbers using normal Excel formatting commands.

OFFICEPRO, Inc.

Page 119