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

excel

ResolvedVersion 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:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.