March 2007
Intermediate to advanced
704 pages
21h 31m
English
For easy reference, once you have the concepts down, follow these steps to create and manage the basics of PivotTable and PivotChart reports.
Create your data in columns, with a single row of headings and a value in every cell of the range. For best results, format your data range as an Excel table.
Click in the table and then, on the Insert tab, click PivotTable.
Just click OK in the Create PivotTable dialog box to accept the defaults and create your PivotTable on a new sheet, with the selected table as your source data.
On the new sheet, click to select the fields in the PivotTable Field List pane that you want to include in your PivotTable.
After your fields are added to the PivotTable Row Labels and ...
Read now
Unlock full access