Excel 2016 Tips and Tricks

Lesson – Creating/Revising PivotTables

Excel 2016

Display the Sales worksheet. Change the number in cell D10 from 1089 to 2000 . Then, display the Sheet1 worksheet again. Notice that the number 1089 still appears in the Gloves field for March .

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 A3

2. Select the Refresh command. The PivotTable report updates.

Click Refresh

Display the data for all the sales representatives by selecting (All) for the SalesRep report filter field.

C HANGING THE S UMMARY F UNCTION  D ISCUSSION

By default, an Excel PivotTable report sums fields that contain numeric data and counts fields that contain text. The PivotTable report can provide summary information using other mathematical calculations as well. A PivotTable report can average data, provide the minimum and maximum values, or yield the standard deviation or variance. A PivotTable report can also contain multiple summaries for the same field.

The Value Field Settings dialog box

Page 108

OFFICEPRO, Inc.