98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel-courses - Excel - consolidating data
excel-courses - Excel - consolidating data
Resolved · Low Priority · Version Standard
Gareth has attended:
PowerPoint Introduction course
Excel - consolidating data
How do you consolidate data in a worksheet?
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 [b]Data > Consolidate
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 tip:Copying Formulae QuicklyThere is a quicker way of copying a formula down a column. |