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