How to create Pivot table ?

Its very simple Select data go insert > Pivot Table.

short-cut. Select data the press ALT+N+V.

Click on the Insert menu and click the PivotTable/ ALt +N+V

select you data (should have headers)

from insert >> Pivot table

1. 1. On the Insert tab, in the Tables group, click PivotTable. ...
2. 2. In the Create PivotTable dialog box, make sure that Select a table or range is selected, and then in the Table/Range box, verify the range of cells. ...
3. 3. Do one of the following: ...
4. 4.Click OK

Have the data with titles.  Should not have any subtotals or totals.

Select the whole range of data required.

Insert Pivot table.

Choose the way you need the data to be shown row wise and column wise

On the Insert tab, in the Tables group, click PivotTable