Pivot Table is a powerful tool in Excel, which is used to summarize the data.
Using Pivot Tables you can summarize, analyze, explore, and present your data.
In this tutorial, we are going to discuss how to create a pivot table in Excel and the uses of Pivot Table in Excel and how pivot table works in Excel with Examples.
You can also Move Pivot Tables in Excel from multiple sheets into a single sheet.
While creating a pivot table in Excel, the data should not have any blank column or blank row.
In the above given excel pivot table example, we have sample data with the State, Budget, and Category.
And here we need to find a total Budget state wise. we can do it using the filter option or Excel SUMIF function also.
If we have a huge number of records it is time taking process to find state wise total one by one. but using pivot tables in excel, we can find a total of Budget state wise easily.
Execute the below steps to create pivot table in Excel.
Now a new pivot table has been created. Now drag the related fields to the different areas.
1. Drag State field to the Rows area.
2. Budget field to the Values area.
Now automatically total Budget of states shows in the Pivot table.
This is the simple pivot table Excel example to summarize our data as per our requirements.
1. Normal Tables in Excel are fixed but pivot tables are flexible.
2. Normal Tables in Excel give you the entire data but in pivot tables, you will get summarized data.