How to make Pivot table in MS Excel

Pivot table in MS Excel

Pivot Tables are used to reorganize data in a spreadsheet. They won’t change the data that you have, but they can sum up values and compare different information in your spreadsheet, depending on what you’d like them to do.
an example.I want to take a look at how many people are in working in one area
To create the Pivot Table, I go to Data > Pivot Table.
Report Filter: This allows you to only look at certain rows in your data set.
Column Labels: These could be your headers in the data set.
Row Labels: These could be your rows in the data set. Both Row and Column labels can contain data from your columns 

Leave a Reply

Your email address will not be published. Required fields are marked *