How to Insert pivot Table in an Excel Sheet?

Thank you all for participation in answering this question.  Yes agreed we can spend our weekend at bayt.com by participation in question/answer session.

100%

In Office2010 Click on the  Insert  Menu next to home menu  and you will see the Pivot table option select the pivot table option and then you will be shown options to select the data range and pivot table placement option just fill in the data and click ok and you have created a pivot table.

1. Select the type of report to generate by doing one of the following:
2. To create a PivotTable report, on the Insert tab, in the Tables group, click PivotTable, and then click PivotTable

Its  ALT  -   N - V - T

Open Excel Sheet

press Alt key then  press  in sequence  the following key

N      then V then T

it will take you the window of selection the data range for Pivot

we can use shortcut key for pivot table. Press Alt+D & than P

 You can use excel short cut Alt-D-P-P

INEXCEL SHEET>>> GO TO>>>INSERT>>>>>>>>>>SELECT  PIVOT TABLE

Correct or you can for as shortcut:

Alt >> n >> V >> T

Good luck ^__^

First you should arrage your date in proper table manner as per the need,then u can insert pivot table .In excel2013 u can make veriety of reports by using Pivot table

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.