Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-courses - Excel - consolidating data
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel-courses - Excel - consolidating data
Resolved · Low Priority · Version Standard
Reply Wed 9 Jan 2008, 14:02Delegate Gareth said...
Gareth has attended:
Powerpoint Introduction course
Excel - consolidating data
How do you consolidate data in a worksheet?
For upcoming training course dates see: Pricing & availability
RE: Excel - consolidating data
Consolidating Data is used for summarizing data that may be stored in various worksheets within the same workbook or in separate workbooks. The data can be consolidated for Ad hoc purposes or updating data on a regular basis by establishing a link.
A typical example for creating a Consolidating data could be for example, if you have a worksheet of sales figures for each of your regional offices, you might use a consolidation to roll up these figures into an Overall Sales worksheet. This master worksheet might contain expenses totals and averages, current inventory levels, and highest selling products for the entire organization.
To consolidate data:
Step 1: Choose the Master Sheet where you want to consolidate the data and click on the relevant cell.
Step 2: Choose Data > Consolidate
|