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 Table in Excel is the easiest way to create and share small data reports, pivot tables, and charts. Excel's PivotTable is a powerful tool for summarizing, analyzing, and displaying data. With our free Excel add-in, you can quickly pivot into a tabular view of your information. Easily sort filter, and group your data with a few clicks of the mouse. Pivot Table in Excel is the smartest way to quickly summarize your data with easy-to-use visualizations. Combine your visuals with formulas and functions to get answers you never thought possible.

There are a few different types of Pivot tables. One of the most common is a column Pivot table, which lets you summarize data in a column.The process of creating pivot tables can be as easy as inserting a single row or as complicated as designing an advanced dashboard using Excel formulas. Once you have your data stored in your workbook, you will need to set up the range that will hold the pivot table and then pick from one of the four basic types of pivot tables that exist: a Column Pivot table, a Row Pivot table, a Filtered Row pivot table, or an Unfiltered row pivot table.

Pivot tables allow data analysis and manipulation. They can be used to summarize, filter, and analyze data. Pivot tables are a powerful tool for analyzing and sorting data. They provide a visual representation of the data by arranging it on a grid. The pivot table displays statistical information in rows and columns. It uses formulas to transform the values in each row into values in each column as well as sums, averages, or other aggregate measures of that row's values across all their corresponding columns.

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
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ 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