Creating a new pivot table

First, make sure the active cell is inside your table of data by clicking somewhere inside the table of data.

Choose the “Insert” tab on the ribbon.

Click the “PivotTable” button (located at the far left of the ribbon), and then click “OK” in the dialog box that appears.

A new worksheet has appeared in the workbook, with a special pane at the right hand side.

This new worksheet is used to operate the pivot table and all its features.