Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel microsoft training - The whole of unit 2
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel microsoft training - The whole of unit 2
Resolved · Low Priority · Version Standard
Reply Thu 11 Oct 2007, 17:49Delegate Rebekah said...
Rebekah has attended:
Excel Intermediate course
The whole of unit 2
Please can I have more help with whole of unit 2?
For upcoming training course dates see: Pricing & availability
RE: 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
|