You can create a pivot table on a new sheet or on an existing sheet.
To create a pivot table:
1.Select any cell or the desired range of cells.
2.On the Insert tab, click the Pivot table button. The Create pivot table window opens.
3.Customize the Data source:
•If you selected only one cell, specify the range to analyze.
•If you have selected a range, it will be specified in the Data source field automatically.
4.Customize table location:
•New sheet: the pivot table will be placed on a new sheet. It will be created automatically with the name "Pivot table No." (you can change the name later).
•Existing sheet: the pivot table will be inserted on the current sheet. In the Destination cell field, enter the address or select the cell that will become the upper left corner of the pivot table. Make sure there are at least two empty rows above the starting cell to accommodate filters.
5.Click OK to create the pivot table.