Excel 2016 Tips and Tricks

Excel 2016

Lesson – Creating/Revising PivotTables



Procedures

1. Select the Analyze tab

.

2. From the Show group, click Field List . The PivotTable Fields pane appears. 3. In the PivotTable Fields pane Search field, type field name you want to find. The field list sorts automatically based as you type.



Step-by-Step Search for a PivotTable field.

Open the Pivot2.xls file and display the Pivot1 worksheet.

Steps

Practice Data

1. Click the Analyze tab .

Click

The Analyze ribbon appears.

2. In the Show group, click Field List . The PivotTable Fields pane appears. 3. In the Search field, type the field name. The field list sorts automatically as you type.

Click

Type Profit in the Search field.

S ELECTING A R EPORT F ILTER F IELD I TEM  D ISCUSSION

Report filters allow you to display a subset of data in a PivotTable report by displaying only the data for a specific item or item(s); you can drag any field to the Filters box in the PivotTable Field pane. The Filters field (located above the PivotTable) then displays a list of values for the selected field.

When you select an item from the Filters list, only the data relating to that single item appears in the PivotTable report. For example, if items in the Region page field include Northeast , Northwest , Southeast , etc., and you select the Northeast item, only the data for the Northeast region appears in the PivotTable report.

OFFICEPRO, Inc.

Page 105