Microsoft Office Tutorials and References
In Depth Information
On the first step of the wizard, choose the location of your data and then select
The second step of the wizard prompts you to select the source data for the PivotTable.
You can either enter a range in the Range box or press the button at the end of the box
to collapse the dialog box, allowing you to select a range in any of the currently open
workbooks. You can press the Browse button if you want to open a new workbook.
In the last step of the wizard, you choose the location where the wizard will place the
PivotTable. You can select a location on the current worksheet, or the wizard will cre
ate a new worksheet for you. Pressing the Layout button displays a dialog box that
allows you drag and drop the various fields for the PivotTable’s initial configuration.