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”
This is the complete list of every Excel Function for text. For each function I have provided a description, the formula and in some cases an example. Where text is necessary I have included the word ‘text’ as an example and where a target cell is specified I have used ‘A1′. Where appropriate I have provided links to other uses for the functions.