1. Identify the steps needed to create a PivotTable.
2. Use Row Labels to filter the data.
3. Use the Field Settings to Count Values.
4. Pivot the Table!
5. Format the PivotTable and Pivot Table Reports
This lesson demonstrates the
Pivot Table Tools Design Ribbons.
1.
PivotTable Tools ->Analyze-> Show->
Field List, page 90
2.
PivotTable Tools ->Analyze->
Show> Field Headers, page 93
3.
PivotTable Tools ->Analyze->
Active Field-> Field Settings, page 96
4.
PivotTable Tools ->Design-> Layout->
Subtotals, page 104
5.
PivotTable Tools ->Design->
Layout->Blank Rows, page 105
6.
PivotTable Tools ->Design-> Layout->
Grand Totals, page 106
7.
PivotTable Tools ->Design->
Layout->Report Layout, page 110
8.
PivotTable Tools ->Design-> PivotTable Styles->Style,
page 111
9.
PivotTable Tools ->Design-> PivotTable Style Options,
page 112 |
|
|
|
