Why use Macros
Imagine you are a marketing manager. Every day, you plot important graph of Sales data and show it to your reporting manager. Since the task is repetitive in nature, it can be automated using a macro. Record a macro that takes data from a sheet and plots the graphs. All you need to do is to bring the Sales data and run the macro.
Macro appears under the developer tab of excel. Options like record macro, pause recording are there. Under the macros list all the macros in the worksheet appear.
During the course of study of Financial Modelling at Edupristine, macros will be covered that will essentially teach you how to automate frequent tasks like drawing charts etc. Also, you will learn how to edit the code of macro from the visual basic editor
A sample excel sheet which shows how we can use macro to generate graphs is attached
If we perform repetitive tasks in an excel sheet, it can be automated using an excel macro. . A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task.
Recording a Macro
When you record a macro, excel notes information about each step as you perform a series of actions. Running the macro will then repeat the steps. Each macro is stored in a new module attached to the worksheet
Running a macro
To run a macro we can choose it from the list in the macro dialog box. A macro can also be assigned to a key stroke or a button to make it run
Managing your macro
After recording the macro, the code can be viewed with a visual basic editor. The Visual Basic Editor is a program designed to make writing and editing macro code easy for beginners, and provides plenty of online Help.
Advantages of Macros
· Macro reduce the chances of human errors
· They make complex computations easier to perform
· Macros also save time as we do not need to do repetitive tasks