Microsoft Office Tutorials and References
In Depth Information
Build a PivotTable from an Excel Table
Chapter 6: Analyzing Data with PivotTables
Excel creates a blank
PivotTable.
Excel displays the
PivotTable Field List.
6 Click and drag a field and
drop it inside the Row
Labels area.
6
Excel adds the field’s
unique values to the
PivotTable’s row area.
7 Click and drag a numeric
field and drop it inside
the Values area.
Excel sums the numeric
values based on the row
values.
8 If desired, click and drag
fields and drop them in
the Column Labels area
and the Report Filter area.
8
7
Each time you drop a
field in an area, Excel
updates the PivotTable to
include the new data.
Did You Know?
In the PivotTable Field List, if you click
to select a check box for a text or
date field, Excel adds the field to the
Row Labels area; if you click to select
a check box for a numeric field, Excel
adds the field to the Values area. You
can also right-click a field and then
click the area you want to use.
More Options!
Excel usually displays the numbers in the data
area of the PivotTable without a numeric
format. To fix this, click any cell within the
value field range, click the Options tab, click
Active Field, and then click Field Settings. In the
Value Field Settings dialog box, click Number
Format and then use the Format Cells dialog
box to choose the format you want to use.
 
Search JabSto ::




Custom Search