Course Content

Course Content

Creating Pivot Table in MS Excel

How to create Pivot Table in MS Excel

Now we will see an important feature of MS Excel that is how we can create a Pivot Table and what it is.

For creating pivot table we need to understand what does the word 'pivot' actually means in reference to MS Excel. It means that whenever we have a very large amount of data and when we are talking about anything referring to any particular column, so that means that every data revolves around that column, this is pivot.

Suppose we have a data which shows many things such as customer name, from where he has bought things, what category of product he has bought, how much units, and what is the total pricing, and other things. Now if we want to save this data in a good representable manner then we have an option of pivot table in MS Excel.

For using this option we will go to our INSERT tab and in that the left first option we will see 'Pivot Table'. This option easily arranges and summarize complex data in a Pivot table.

Pivot table in short is nothing but an easy way to summarize all the complex data in our spreadsheet and make it easier for anyone to understand it.

So as soon as we click on our pivot table option we will be directed with a dialogue box which will tell us to choose the data that we want to analyze, and then choose where we want to place our pivot table i.e. in new worksheet or existing worksheet.

Now when we apply that option we will be asked to choose field from the pivot table field list to build a report, pivot table field list will be located in our right side of the screen with all the fields checkbox to add in report, whichever field we need we can mark it will be generated in our pivot table report.

We can also drag field in any of the four mentioned areas below the list of fields i.e. Filters, Columns, Rows, and Values as per our requirement.

When we were on any of the data from pivot table we will see all the related information of it and also the location of that particular cell i.e. on which cell that data is stored in our sheet.

And if we double click on any of the data from pivot table we will be directed to another sheet which will be mentioning that from where that data is generated particularly.

We can easily drag the fields according to our requirement and in parallel our data will get arranged in our pivot table.

We also have Filters area which can be helpful for viewing only necessary data in our pivot table.

So this is how pivot table in MS Excel works and it is very useful for representing any complex data in an easy manner to anyone.


Pivot tables are most often used for summarizing and analyzing data. They are a great tool for reporting and analysis. There are many ways to create pivot tables in Excel, but the easiest way is to use the Pivot Table feature found in the Data tab of the ribbon.

Pivot tables are a powerful and versatile tool for summarizing large amounts of data. They can be used to summarize data in a variety of ways, such as listing the number of products sold by salesperson, or total sales for each product category.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere