Create a pivot table

A pivot table is a tool for processing, summarizing, and analyzing data.

Using the pivot table, you can do the following:

•Quickly put data from the columns of the source table in the columns and rows of the pivot table and swap them.

•Make calculations.

•Filter the data.

You can create a pivot table on a new or current document sheet.

To create a pivot table, do the following:

1.Select a cell or range of cells to build a pivot table.

2.Open the window containing elements to build a pivot table using one of the following methods:

•In the Command menu, select Insert > Pivot table.

•On the Toolbar, click , then select and click Pivot table.

3. In the Create pivot table window, perform the following steps:

•If you selected a cell to insert the pivot table in the first step, then in the Data source window, specify the range of data in the source table from which to create the pivot table.

•If you selected a range of data, a single cell within the range, or an adjacent empty cell in the first step, then specify where you want to insert the table:

oNew sheet: Insert the table on a new sheet. A new sheet is created automatically. By default, the sheet is named Pivot table No. If needed, the name of the sheet can be edited.

oExisting sheet: Insert the table into the sheet that is currently displayed on the screen. In the Destination cell field, enter the cell address manually or select an empty cell in the workspace in which you want to place the upper-left cell of the pivot table. There should be at least two empty rows above the starting cell to place the filters.

4. Click OK.