PIVOT TABLE In Excel
Pivot Table is used to summarize and organize the data of extensive table. This includes sums, count, average or any other data statistics. Pivot table groups and organize data in a presentable way. Pivot tables are most used to sort out the data and prepare a summarize report in just few seconds.
To create a pivot table and generate a summarize report please follow the step mentioned below.
First Go To Insert Tab available on top ribbon of excel sheet.Then click on Pivot TableOnce clicked a Dialog Box will pop-up.In the select range source bar it will automatic select the source table. But if you want to select the different range you can select it.Then little down in that dialog box you will find 2 option to select the sheet (1) New Sheet (2) Existing Sheet.If you select New Sheet...