excel course - Workbooks

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

Resolved · Low Priority · Version Standard

Workbooks

Leena has attended:
Excel Intermediate course

by - delegate Leena [2 posts] (2007 Jul 3 Tue, 12:48) Reply

How do I link workbooks?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: workbooks

by - trainer Amanda platinum contributer [968 posts] (2007 Jul 3 Tue, 16:16) Reply

Hi Leena

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

· Microsoft Excel Training: Essential for Today's Employees
· Database Tips from an Excel Training Course
· Prepare for your MOS Certification with MS Excel Courses
· What's Better Than the Help Function in Excel? Microsoft Training
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips