Excel 2016 Tips and Tricks

Lesson 4 – Creating/Revising PivotTables

Excel 2016

Steps

Practice Data

5. Select the desired field name from the field section in the PivotTable Field List pane and drag to the Column Labels box in the layout section. The selected field name is highlighted and the mouse pointer changes to a move handle. The field name label appears as you drag to the desired location in the layout section. The selected field name is displayed in the Column Labels box in the layout section, and column labels are displayed, along with a Grand Total column and row, in the PivotTable report worksheet. 7. Select the desired field name from the field section in the PivotTable Field List pane and drag to the Values box in the layout section. The selected field name is highlighted and the mouse pointer changes to a move handle. The field name label appears as you drag to the desired location in the layout section. The selected field name is displayed in the Values box in the layout section. The field’s data values, along with Grand Total values, are displayed in the PivotTable report worksheet. 6. Release the mouse button. 8. Release the mouse button.

Drag the Month field to the Column Labels box

Release the mouse button

Drag the Sales field to the Values box

Release the mouse button

S EARCH FOR P IVOT T ABLE R EPORT F IELD  Discussion

Excel 2016 give you the ability to search the PivotTable Field list to make it easier to find a specific field for table with a lot if columns. The search field was added to the top of the PivotTable Fields pane. Search most helpful when you have a long list of fields

Page 104

OFFICEPRO, Inc.