How to create a pivot table in Excel 2013?

Go to insert

Pivot Tables

Choose Data source

Arrange the data the way you want to present it

Create pivot chart

a good option in Excel 2013 is to select your data then click Ctrl and excel will give you multiple options to utilize your data, one of the options is Tables; which will recommend most obvious 4 tables, if not the required pivot, select More and build your own.

Good question

just select a cell inside you data.

go to insert tab >> insert pivot table command.

or use the very fast way

Alt+N+V

done.

Hope this helps you.

1. Select the table or cells (including column headers) containing the data you want to use. ...
2. From the Insert tab, click the PivotTable command. ...
3. The Create PivotTable dialog box will appear. ...
4. A blank PivotTable and Field List will appear on a new worksheet.