What is pivot table in excel?

In Microsoft Excel, A pivot table is a tool that allows you to review huge quantities of data quickly and easily. With the pivot table, we can build good looking reports for presentation. To understand pivot tables, use it on your worksheet.

Select your worksheet or just click on any cell and Go to Insert Tab & click on the Pivot table. Excel will display the create Pivot Table window. The default location for a new pivot table is created on a new worksheet. But you can change location according to your work requirements.

pivot table excel example

You can see the pivot table field list is uncheck, now choose/checkmark those fields that you want to add in your reports.

how to create a pivot table in excel

When fields marked your reports will be prepared.

pivot table in excel sales report

Also Read:

How to insert picture in Ms Excel

What is insert table in Microsoft Excel