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

microsoft excel training - macro excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Macro excel

microsoft excel training - Macro excel

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

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

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.13 secs.