 |
Determine the type and location of the data
you want to analyze. Example: Excel list in the current worksheet |
|
Determine what type of report you want to create. Example: PivotTable Report |
|
Display the Data menu. |
|
Select the PivotTable and PivotChart Report…
command. In a few moments, the PivotTable and PivotChart wizard will display. |
|
Click the option describing the
location of your data. |
|
Click the option describing the
report type. |
|
Click the  button. Depending on what you’ve selected, various screens will display to help you select the data for analysis. After
you’ve selected the data, the wizard will display Step 3. |
|
If necessary, click the Layout
button or the Options button in order to format your report. |
|
Click the  button. |