Explanation
A PivotTable is an Excel tool used to quickly summarize, analyze, and compare large amounts of data without writing complex formulas.
It can summarize data by:
- Product
- Employee
- City
- Region
- Category
- Date
- Sales Amount
- Quantity
Example
From a sales dataset:
|
City |
Product |
Sales |
|
Sirsa |
Laptop |
₹60,000 |
|
Hisar |
Mouse |
₹5,000 |
|
Sirsa |
Monitor |
₹34,000 |
A PivotTable can quickly show total sales by city or product.
Key Point
A PivotTable does not normally change the original source data; it creates a separate summary view.