excel training onsite - Simple Excel macros

Hi Divya,

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