Excel Advanced

Hi Celia,

Thank you for your question.

The Indirect function allows the creation of a formula by referring to the contents of a cell, rather than the cell reference itself.

The indirect formula can be used to retrieve data using both text strings and cell references.

Please find the following link with some examples:

http://www.exceldigest.com/myblog/2009/03/18/how-to-use-the-indirect-function/.

If you go to stl-training.co.uk and click Delegate Sign In in the top right of the window. Enter the email address from your evaluation along with the four digit password that was assigned to you after the training evaluation.

Once logged in, go to the last tab and find the relevant course and click on the appropriate zipped folder to download the contents which include the Reference manual.

I hope this answers your question.

Regards

Simon