ms excel courses - Excel

The UK's most regular instructor-led training courses.
Training information: ms excel courses · Excel course london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel

Nadia has attended:
Excel Intermediate course

by - delegate Nadia [1 post] (2007 Jul 3 Tue, 12:51) Reply

how do i link workbooks

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	0	FULL
2003	2008 Oct 23 Thu + 24 Fri	Southwark	0	FULL
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Nov 3 Mon + 4 Tue	Bayswater	4	book now	£475	£485
2003	2008 Nov 17 Mon + 18 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 40 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: excel

by - trainer Amanda diamond contributer [1091 posts] (2007 Jul 3 Tue, 16:14) Reply

Hi Nadia

Thank you for your question.

You can link one cell in one file to another cell in a different file by:

Opening both files

Choosing the cell that you want the linked result to appear in

Press =

Go to the other file and clicking on the cell you want to link to

Press Enter.

Amanda

· Compare Different MS Excel Training Methods
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Basic Excel Training
· Microsoft Excel Training: Not Just for Newbies Anymore
· Tap the Power of Recorded Macros with MS Excel Courses

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips