microsoft excel training day courses near kent - 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