Macros for Financial Modeling Part 1 - Inscribing Macros

Duration 03:00 7007 Views

Hello and Welcome to Module 2A part 1 the Financial Modeling Course by SimpliLearn! This lesson is an introduction to the use of macros.

Macros are a very important part of Excel workbooks. Macros are like short programs that can allow to automatize some tasks in excel or to perform some more complicated calculations and manipulations in the excel workbook.

This presentation will give the reader the basics about macros: how to create one using the excel macro recorder function, or by coding the macro directly in VBA. At the end of this training one should feel confident in using macros for practical applications to financial modeling.

Now let’s move on to our agenda!


We will start this presentation by an introduction on how to write and use macros. We will first learn how to write a macro, either directly using some VBA coding, or using the excel macro recording function. We will then see how a macro can be run, either from the macro menu in excel or by linking the macro name to any object in the excel workbook. We will then wrap up this part with case study 13 where we will apply our knowledge through a practical example of a macro for the pricing of a fixed-coupon bond.

Our next part will then focus on the use of cells and ranges in excel. We will learn how to manipulate ranges and cells in excel tabs, how to work with arrays and finish this section with case study 14 though which we will learn how to apply a function to an array.

The last part of this presentation will then focus on the use of VB forms for applications where the graphical interface is important and the formatting of inputs and outputs require better control than on mere excel tabs. We will see how to output data on a VB form instead of on excel tabs.

Now let’s move on to our next slide and get started with this exciting presentation.

Writing and using macros

Macros are bits of VBA code that can be executed like small programs. There are two types of macros. The first type of macros is macros built as procedures or functions by directly writing the VBA code yourself. The second type is for macros that are “recorded” rather than written directly. The recording happens using the Excel functionality of macro recording.

Writing a functional macro is not done directly. Instead Excel has a functionality to allow the user to record his own macros based on actions taken on-screen.