What is Pivot Table
Pivot Table is a function in Microsoft Excel. It helps to group your records into categories and provide a subtotal for each category.
Using Pivot Table, you can quickly find out the sum, count, average, max, and min for each category. There is no need to do multiple auto-filter again if you need to find the sub-total for each category.
In fact, Pivot Table allows you to group your data into sub-categories and display the total for these sub-categories too. In fact, you can do it for many sub-categories.
Examples of Pivot Table Reports
Headcount report showing how many staff are in each department
Headcount report showing the age profile of the staff
Headcount report showing the age profile of the staff and the department the staff are working in.