Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - 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. |
microsoft excel training day courses near kent - Consolidating Data
Resolved · Low Priority · Version Standard
Reply Wed 5 Dec 2007, 17:05Delegate Amanda said...
For upcoming training course dates see: Pricing & availability
RE: Consolidating Data
Hi Amanda
Thank you for your question, and apologies for the delay in response.
The idea of consolidating data this that you can create a summary spreadsheet of more than one spreadsheet. It is easier to use if the data on each spreadsheet that you are summarising is in the same cells on each sheet.
The summary spreadsheet can give you totals, averages, minimums or maximums (amongst other things) for the spreadsheets you choose to summarise.
I hope this helps to explain.
Amanda
|