Create a pivot table

A pivot table is a tool that allows you to present data from an ordinary flat table in a form that is easy to analyze.

Pivot tables allow you:

•To quickly place data from the source table columns into the pivot table columns and rows and swap them around.

•To perform calculations.

•To filter data.

To create a pivot table, create a source table first, which is a flat table with the required data.

When preparing the source table, it is recommended to take into account the following requirements:

•The columns in the source table must have headings.

•It is recommended to use data in one format within one column of the table. For example, only in General format or only in Date format.

You can create a pivot table on a new sheet or on the sheet you are working on.

To create a pivot table, follow these steps:

1.Select one of the following elements required to create a pivot table:

•A range of data in the source table which will be used as the basis of the future pivot table. The range of data should be selected with the column headings.

•A single cell within the data range, or an empty cell adjacent to the range if you want to use the entire range.

•The cell on the current sheet into which you want to insert the pivot table. This cell will become the upper left cell of the table. The selected cell should not contain any data.

2.Open the Create Pivot Table dialog box in one of the following ways:

•In the Insert menu, select Pivot Table.

•On the Toolbar, in the Insert section, click  Pivot Table.

•On the Toolbar, in the Insert section, click . In the insertion pane that appears, click  Pivot Table.

3.In the Create Pivot Table window, do the following:

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

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

oNew sheet: Insert the table in a new sheet. The new sheet will be created automatically. By default, the new sheet will be named Pivot table <No.>, where No. is the number of the pivot table in the document you are working on. If needed, you can edit the sheet name.

oExisting sheet: Insert the table on the sheet that is currently displayed on the screen. In the Specify a destination cell field, enter the cell address manually or click to select an empty cell in the workspace where you want the upper-left cell of the pivot table to be located. There should be at least two empty rows above the initial cells for filters.

4.Click OK.