You can select / deselect them to instantly change your PivotTable to display only the information you want and in a way that you want. The headers in your data table will appear as the fields in the PivotTable.

You can observe the PivotTable fields that was selected in the PivotTable fields list. The selected PivotTable appears on a new worksheet. Click the PivotTable Sum of Order Amount by Salesperson and month.Ĭlick OK.Click each of the PivotTable options to see the preview on the right side.In the recommended PivotTables dialog box, the possible customized PivotTables that suit your data are displayed. The Recommended PivotTables dialog box appears. In case you are new to PivotTables or you do not know which fields to select from the data, you can use the Recommended PivotTables that Excel provides.Ĭlick on Recommended PivotTables in the Tables group. Click New Worksheet to tell Excel where to keep the PivotTable.Ī Blank PivotTable and a PivotTable fields list appear.In the Table / Range Box, type the table name.

The PivotTable dialog box appears.Īs you can see in the dialog box, you can use either a Table or Range from the current workbook or use an external data source. To create PivotTables, ensure the first row has headers. The easy way to handle these tasks is to create a PivotTable that you can dynamically modify to summarize the results the way you want. From this data, you might have to summarize total sales region wise, month wise, or salesperson wise.

It involves summarizing the data, obtaining the needed values and presenting the results.Įxcel provides PivotTable to enable you summarize thousands of data values easily and quickly so as to obtain the required results.Ĭonsider the following table of sales data. Data analysis on a large set of data is quite often necessary and important.

Quick analysis button in excel 2007