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 » training in excel - Consolidating data
training in excel - Consolidating data
Resolved · Low Priority · Version Standard
Jessica has attended:
Excel Introduction course
Excel Intermediate course
Consolidating data
What is the easiest way of consolidating data?
RE: Consolidating data
Hi Jessica,
Sorry for the delay in replying. The consolidation function in excel works so that you highlight the range of cells you wish to group together and then you choose a function, most people go for the sum function and then you choose where you want to place the results. Under the Data>Consolidation. I hope this helps
Tracy
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:Add a € to your cellsIf you need to add a € symbol to your Excel sheet - hold down the key Alt Gr and 4. |