excel course - Linking formulae between spreadsheets

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

Resolved · Low Priority · Version Standard

Linking formulae between spreadsheets

suzanne has attended:
Excel Advanced course

by - delegate suzanne [1 post] (2008 Jan 23 Wed, 09:47) Reply

How do I link formulae between spreadsheets?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: linking formulae between spreadsheets

by - trainer Mark gold contributer [328 posts] (2008 Feb 1 Fri, 13:07) Reply

Hope you are well
what you need to do

firstly when you are linking formulas you need to use your mouse and your keyboard to create the formula, and i will show you an example of the formula below:

=E5+Sheet2!D3 this is how the formula looks, but when you create this you will need figures in both of the cells used in the formula then, on a blank cell type =e5+, then click the sheet 2 tab at the bottom of the screen then click on cell d3 when you have done that press enter

Hope this helps

Mark east

· From the Classroom to the Corporate World
· Crazy Things People Have Done With Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel Features and Functions for Accountants
· Database Tips from an Excel Training Course

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

Rate this page: