How to create Pivot table ?

Question

Abdul Basit Ali Tahir · Answer

Its very simple Select data go insert > Pivot Table.

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

Firas Shahadi · Answer

select you data (should have headers)

from insert >> Pivot table

Jasmin Iris Fernandez · Answer

1. On the Insert tab, in the Tables group, click PivotTable. ...
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. Do one of the following: ...
4.Click OK

Cristian Florin Dascalu · Answer

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

Prathmesh Agarwadekar · Answer

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

Maciyudeen Khan · Answer

Here you go,

Click-> Insert in the Menu Ribbon

Select Pivot Table under Tables

Select the Data Range and Click OK.

Abhishek Padmanabhan · Answer

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