Microsoft Office Tutorials and References
In Depth Information
2
On the first step of the wizard, choose the location of your data and then select
PivotTable.
3
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.
4
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.
Search JabSto ::




Custom Search