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.
Very good 👍👍
I learned a lot of formulas and functions through this lecture in free of cost. Thanks
Please give us an assignment or workbook to download and practice Excel after watching videos.
MORI PARTH RAMESHBHAI
IT'S VERY GOOD AND USEFULL APLICATION WHERE WE CAN LEARN MANY COURSE AND MAKE CARRIER FREE OF COST . HOW CAN I APPRICIATE YOU I DON'T HAVE ANY WORDS REALLY IT'S VERY USEFUL FOR WHO CAN DO JOB LIKE ME
In this video they have mentioned like 2.1% increase in the salary how it can be above 1 lakhs , it should be 52000+2.1%+52000 which seems to be 53092 so, it's my feels as per the question they have
this is very help for excel study .thanks
I M VERY IMPRESSED SIR, THIS KNOWLEDGE IS VERY UISEFULL SIR
THANK YOU SO MUCH SIR