| Be My Friend

Pivot Table in Excel

Pivot Table in Excel | Create Pivot Table | Drag Fileds | Difference

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.

How to Create Pivot Table in Excel

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.

Insert Excel Pivot Table

  • 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.

Pivot Table Dialog Box

Drag Fileds

Now a new pivot table has been created. Now drag the related fields to the different areas.

PivotTable Field Dialog Box

1. Drag State field to the Rows area.

2. Budget field to the Values area.

Drag Fields to Areas

Now automatically total Budget of states shows in the Pivot table.

Pivot Table Result

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:


Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.

Download the Sample Pivot Table in Excel file for free.

To Get FREE Excel Shortcut Keys





Why basictutorials.in?

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.

Useful Tutorials