microsoft excel training - macro 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 » microsoft excel training - Macro excel

microsoft excel training - Macro excel

resolvedResolved · Low Priority · Version Standard

James has attended:
Excel Intermediate course

Macro excel

how to record / run a macro

RE: macro excel

Hi James,

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored and can be run whenever you need to perform the task.

For example, if there is a seris of calculations or formatting that are regularly carried out manually this could be automated as a macro

When you record a macro, Excel stores information about each step you take as you perform a series of commands. You then run the macro to repeat, or "play back," the commands.

Macros are created from the Tools > Macros > Macro menu options

Hope this helps


 

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips


Server loaded in 0.09 secs.