excel vba courses - Microsoft Excel

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

Resolved · Low Priority · Version Standard

Microsoft Excel

Anne has attended:
Excel Introduction course
Access Introduction course
Excel Intermediate course
Access Intermediate course

by - delegate Anne [4 posts] (2007 Oct 25 Thu, 09:51) Reply

What is the easiest way of remembering short cut commands when using Excel?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Microsoft Excel

by - trainer Amanda diamond contributer [1297 posts] (2007 Oct 26 Fri, 17:03) Reply

Hi Anne

Thank you for your question.

If you need a prompt to remember shortcut keys for commands you normally see displayed on a menu, e.g. the Edit menu for cut, copy or paste, select the menu that the command is found on. If there are any shortcut keys for that command they will be listed next to the command itself.

You can also get a complete list of all Excel shortcut keys you can look up keyboard shortcuts in Excel Help.
It would be impossible to remember all the shortcut keys that are available so perhaps pick the ones you will use most often and try to memorise those.

I hope this helps.
Amanda

· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Interesting Lifestyle Applications for Microsoft Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· How to Create Better Excel Spreadsheets: Part Three
· Microsoft Office and the Small Business: Part 1 Excel

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

Rate this page: