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.
This is very much a quick reference guide, if you need help using these formulas you should come on our Excel Training course aimed at beginners. If you’re already up to scratch with all of these functions and are looking for something more advanced then our Advanced Excel Training Course is right for you.
Microsoft Excel 2007 Text Functions
Description: Changes double-byte characters (full-width) into single-byte characters (half-width) for Double-byte characters sets (DBCS).
Description: Changes numbers into Thai currency by changing the number to Thai text and adding the suffix “Baht”