excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Godwin has attended:
Excel Introduction course

Excel

how do you do micros

RE: excel

Hi Godwin,
Thank you for your post, I'm going to assume you mean Macos, this is covered in some depth in our Advanced course but as a little background... A macro is a recording of keystrokes and mouse movements which is played back when required. Macros are normally recorded using the Macro recorder and are used to complete repetitive and mundane tasks. Basically whatever can be recorded by the Macro recorder will be played back ... somewhat like a tape recorder would.
To create a Macro go to Tools>Macro.Record a new macro, give your macro a name (no spaces) and then record your key and mouse commands. When you have finished click the Stop Recording button. To 'play' your macro follow the steps above and from the macro list in Macros click run, there are other methods of running macros but these are covered on the Advanced course ... Pete


 

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips


Server loaded in 0.1 secs.