This tutorial is covered on our Beginners Excel course, if you want to learn some more complex techniques then take a look at our Advanced Excel course outline.
When constructing large spreadsheets it is likely that you will need to cross-reference data from different worksheets.
An example of this could be monthly figures on individual worksheets and a total or yearly worksheet.
You can use a simple formula to automatically update the total figures based on the monthly worksheets but this means referencing cells in multiple worksheets in one formula. So how do you do this?
It is actually very simple. In this example I will show you how to add together two cells from separate worksheets into another worksheet using employee sales figures.
As you can see we have January, February & Total worksheets.

We want to combine Rachel’s January and February sales figures to give us her total in 2012. Read the rest of “How to Reference Cells from Other Worksheets in a Formula”

After the popularity of our previous