excel.training.course.london

excel.training.course.london - F keys

Resolved · Low Priority · Version Standard

F keys

Jenny has attended:
Excel Introduction course
Excel Intermediate course
Powerpoint Advanced course

by - delegate Jenny [4 posts] (2008 Jan 10 Thu, 11:41) Reply

When creating/using formulas, could you please remind me which F key is used and what its used for?

Many thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 5 Fri	Bayswater	0	FULL
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: F keys

by - trainer Amanda diamond contributer [1243 posts] (2008 Jan 10 Thu, 13:14) Reply

Hi Jenny

Thank you for your question.

I think you are referring to using the F4 key when creating a formula. You would use the F4 key after you have selected (clicked on ) a cell to put it in the formula, if you wanted that cell reference to stay the same/fixed if the formula was copied to other cells. This is called an absolute reference in Excel-speak, so if you want to look this up in Excel Help at any point, try typing in absolute reference as your search term.

I hope this helps.
Amanda