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 » microsoft excel training day courses near kent - Consolidating Data
microsoft excel training day courses near kent - Consolidating Data
Resolved · Low Priority · Version Standard
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
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:Saving your Excel Spreadsheet as a CSV FileIn situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps. |