Explanation
Consolidate combines data from multiple ranges or worksheets into one summary.
It is useful when the same type of data is maintained separately for:
- Different branches
- Different months
- Different departments
- Different products
- Different regions
Go to:
Data → Consolidate
Common Functions
Excel can consolidate data using:
- Sum
- Count
- Average
- Max
- Min
- Product
Example
Suppose three branches maintain separate sales sheets:
Sirsa | Hisar | Fatehabad
You can combine their sales into one summary.
Practice
Create three small branch sales tables and identify which fields are common.