Download the New LearnVern Android App and enter Lucky Draw to win Free Certificate
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.
Have a friend to whom you would want to share this course?