Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Data cosolidating
|
|
|
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. |
2002 excel microsoft training - Data cosolidating
Resolved · Low Priority · Version Standard
Reply Tue 3 Apr 2007, 09:46Delegate Asger said...
Asger has attended:
Excel Introduction course
Excel Intermediate course
Data cosolidating
How do I consolidate data?
For upcoming training course dates see: Pricing & availability
RE: data cosolidating
Good morning Asger,
Thanks for the question
Consolidating data is where you group all the numbers together and you can get a total (or average...) at the end. You have to use Data, consolidate, and make sure you pitch your cursor high up in the page the data is going to as the result appears below the cursor. Highlight the labels as well as the data and this works best when all the data is at the same place in each sheet.
Hope this helps
Tracy
|