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.

•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 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 box, enter the address of the cell where you want the top 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.