Beginners Excel

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

Resolved · Low Priority · Version Standard

Beginners Excel

Patrick has attended:
Excel Introduction course

by - delegate Patrick [1 post] (2008 Feb 27 Wed, 16:32) Reply

What are the function buttons again (i.e. F1, F2, F3 etc.)

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 22 Fri	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Aug 22 Fri	Bayswater	2	book now	£195	£205
2003/XP	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003/XP	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003/XP	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2003/XP	2008 Sep 10 Wed	Tooting	0	FULL
Full Schedule: See all 129 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Beginners Excel

by - trainer Mark gold contributer [180 posts] (2008 Feb 29 Fri, 11:47) Reply

Hi Patrick how are you

the usage of the function keys is a good question and your answer is as follows

F1 = help, F2 = edit cell or formula
F4 = to insert dolloar signs (absolute ref)
F5 = go to window for navigation
F7 = will start a spell check
F9 = update field or cell data
F11 = Insert chart from selected cells
F12 = will open up the save as window

hope this helps you Patrick

Mark East

· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Crazy Things People Have Done With Excel
· Microsoft Excel Training Course
· Prepare for your MOS Certification with MS Excel Courses
· Fun Things I've Done With Excel

Please browse our web site to find out more about
excel+courses and other Microsoft training courses.

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips