Divya has attended:
Excel Intermediate course
Simple Excel macros
how do you start a macro and when are they used? can you give an example of a simple macro?
RE: 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
