A spreadsheet that works
with PivotTables in Excel. This lesson shows how to present data
visually, format data as a PivotTable and display the Totals.
Brown Bag Lunch Sales Team.xlsx
Complete the Practice Activity on page 117.
Review the Test questions on page 118.
This lesson demonstrates the Pivot
Table
Tools Design and Options Ribbons.
1.
PivotTable Tools ->Options-> Show->
Field List,
page 90
2.
PivotTable Tools ->Options-> Show>
Field Headers, page
93
3.
PivotTable Tools ->Options-> 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
From the Insert Ribbon
Insert->Tables->Pivot Table, page
87 |
|
|
|
