Thursday, November 21

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.

  1. First Go To Insert Tab available on top ribbon of excel sheet.
  2. Then click on Pivot Table
  3. Once clicked a Dialog Box will pop-up.
  4. 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.
  5. Then little down in that dialog box you will find 2 option to select the sheet (1) New Sheet (2) Existing Sheet.
  6. If you select New Sheet and click ok button it will automatically create a table on a New Sheet.
  7. If you choose Existing Sheet you will need to give the location below it. Select any single cell and click ok button.
  8. Then you will find a Pivot Table fields on the right side of the sheet and under it you will find Filter – Column – Rows – Values.
  9. Filter is used to filter the data.
  10. Column is used to display the data Column wise
  11. Row is use to display the data Row wise
  12. Value is use to count – sum – or other operation.
  13. Last step – Select the Pivot Fields and drag to the relative areas.
  14. For more details see the example provided below in image and video.

Leave a Reply

Your email address will not be published. Required fields are marked *