microsoft excel course london - Use of F4

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

Resolved · Low Priority · Version Standard

Use of F4

by - Zoe [guest] (2006 Nov 22 Wed, 15:54) Reply

Should you use F4 all the time when formulating to ensure all formulas are absolute from the start?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Use of F4

by - trainer Richard platinum contributer [761 posts] (2006 Nov 22 Wed, 16:20) Edited on 2006 Nov 24 Fri, 10:36 Reply

No, Use F4 to set the appropriate absolute references as required. Not all formulae need absolute referencing, especially if you want the formula to change relatively when copying.

· How to Create Better Excel Spreadsheets: Part Two
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Prepare for your MOS Certification with MS Excel Courses
· How to Create Better Excel Spreadsheets: Part One