Excel 2016 Tips and Tricks

Excel 2016

Lesson 4 – Creating/Revising PivotTables

NOTE When a PivotTable report contains multiple data fields, you can change the summary function for a field by selecting any cell in the row of the data field you want to change.



P ROCEDURES 1. Right-click any cell in a PivotTable report to display a shortcut menu. 2. Select the Value Field Settings command. 3. Select the desired summary function from the Summarize value field by list box. 4. Select .  S TEP - BY -S TEP Change the summary function for a data field.

If necessary, display the Sheet1 worksheet.

Steps

Practice Data

1. Right-click any cell in a PivotTable report to display a shortcut menu. The PivotTable shortcut menu opens.

Right-click cell B5

2. Select the Value Field Settings command.

Click Value Field Settings

The Value Field Settings dialog box opens.

3. Select the desired summary function from the Summarize value field by list box. The summary function is selected.

Click Count

4. Select OK .

Click

The Value Field Settings dialog box closes, and the PivotTable report is summarized accordingly.

Practice the Concept: Reset the summary function for the Sales field to Sum .

OFFICEPRO, Inc.

Page 109