How to create Pivot table ?

Its very simple Select data go insert > Pivot Table.

short-cut. Select data the press 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

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

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

Here you go,

Click-> Insert in the Menu Ribbon

Select Pivot Table under Tables

Select the Data Range and 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