0Situation: You are part of the Finance Team, and work at Headquarters of an Organization.
Periodically, You receive expense data from Teams in different Regions.
After You receive expense data, You SUM all expenses to create a Master Record.
Solution: Wouldn't You be thrilled if You were able to Consolidate expense data from All Teams with a few clicks!
Correct, Consolidate will help You do it all in a few clicks.
Q) How to use Consolidate?
A) Step 1: Open Workbook(s) OR Worksheet(s) that contain data that You would like to Consolidate.
Step 2: Select the cell in Master Worksheet where You want the Consolidated Data to appear.
Step 3: Click on Data tab
Step 4: In the Data Tools group,
Click on Consolidate
A dialogue box - Consolidate - will open. Please refer following screenshot.
Step 5: Input required information
Step 6: Click on OK
Result: Consolidated Data is created.
Example: Please refer following screenshot - You received expense data from East, North, South and West Regions.
Expense data is available in 4 Worksheets. Names of Worksheets are East, North, South and West.
In Master Worksheet, You Consolidate as follows.
Result: Expense data is Consolidated. Please refer following screenshot.
Note the highlighted part, 1 & 2. Click on 2 to show details, and click on 1 to hide details.
In the above screenshot, click on 2. This is how to Consolidate works. Please refer following screenshot.
Source + To Learn More → Microsoft Official Website
