| Be My Friend

# Pivot Table in Excel

## What is Pivot Table in Excel?

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.

## How to Create Pivot Table in Excel?

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.

• 1. Click any cell inside the data set.
• 2. Click on Insert tab, in the Tables group, click PivotTable. • 3. it will select data range automatically or you can select it manually.
• 4. Once range selection is done, select where you want insert pivot table and click OK. ### Drag Fileds

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.

### Difference Between Normal Tables and Pivot Tables

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.

#### You May Also Like the Following Excel Tutorials:

##### To Get FREE Excel Shortcut Keys

###### Why basictutorials.in?

To Learn:

Tutorials in a simple Way.