excel microsoft training - The whole of unit 2

Resolved · Low Priority · Version Standard

The whole of unit 2

Rebekah has attended:
Excel Intermediate course

by - delegate Rebekah [1 post] (2007 Oct 11 Thu, 17:49) Reply

Please can I have more help with whole of unit 2?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: The whole of unit 2

by - trainer Richard platinum contributer [818 posts] (2007 Oct 17 Wed, 11:52) Reply

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