excel microsoft training - The whole of unit 2

When you say unit 2, do you mean on the course you attended?

You need to understand the basics of Cell referencing.

--------------------------------------------------

Simple cell reference:
=A1

Cell Range
=A1:B4

--------------------------------------------------

Referring to a cell on the next sheet:
=Sheet2!A1

Referring to a range of cells on the next sheet:
=Sheet2!A1:B4

--------------------------------------------------

Referring to a cell on another workbook:
=[workbookname.xls]Sheet2!A1

Referring to a range of cells on the next sheet:
=[workbookname.xls]Sheet2!A1:B4

--------------------------------------------------

Let me know if that makes sense to you, and we can go from there. If you have any specific questions, please ask.

Regards

richard