How to make a pivot table in excel?

To make a Pivot Table, first select the table or cell that you want to use in the Pivot Table.
After that go to the Insert tab and click on PivotTable
By doing this the dialog box of Create PivotTable will open.
Here you will find many options
Here you just have to choose a new worksheet or a Current worksheet in the location if you want to Existing
If you select the worksheet, then the Pivot Table will be ready on the same worksheet on which you are working.
On doing ok a blank PivotTable and Field List will be visible to you.
Now as soon as you click on the field, your PivotTable will be ready.

Pro Study Skills