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

Excel Macro

You can download and see the model in action . EduPristine’s extensive Financial Modeling course covers macros in detail. To know more, quickly write an email to


I am greatly impressed by the quality of your training. In fact it is the reason I am going to take the exam this time as I had previously decided not to take it because the quality of the training I had purchased was not what I had expected. All the best to you and everyone at Edupristine.
I am very pleased to have found these courses offered by a recognized, reputable training firm at a great value! Thank you!

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by Edu for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP is not responsible for any fees or costs paid by the user to Edu nor is GARP responsible for any fees or costs of any person or entity providing any services to Edu Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas®, and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

2015 © Edupristine. ALL Rights Reserved.

tick_classroom_city.php Post ID = 55320