Financial Modeling Using VBA

Financial Modeling Using VBA
Corporate Finance Institute (CFI) on-demand courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance. The courses move through three levels of mastery for anyone looking to be an expert in financial modeling, valuation, and financial analysis. Participants typically include professionals in entry to mid-level positions in financial planning and analysis (FP&A), corporate development, treasury, investor relations, and capital markets. All participants are automatically issued certificates of completion after successfully finishing each course.


NOTE: Course login details are normally sent to registrants within one week from date of registration.

EL22230141
This four part course provides participants with the skills needed to incorporate Visual Basic for Applications (VBA) into financial models. This VBA module series will be particularly valuable to those who regularly build financial models in Excel and are looking for a thorough introduction to VBA.

MODULE 1 - INTRODUCTION TO VBA FOR FINANCIAL MODELING IN EXCEL   
 • Explain the benefits of VBA in financial models 
 • Navigate around the VBE window
 • Record macros using absolute and relative referencing 
MODULE 2 - DESIGN, BUILD AND RUN VBA SUB PROCEDURES  
 • Write VBA code for a sub procedure 
 • Differentiate between VBA objects, properties and methods
 • Understand why and how to declare variables 
 • Call sub procedures when needed
MODULE 3 - CREATE CUSTOMIZED EXCEL FUNCTIONS  
 • Utilize unique VBA functions 
 • Incorporate Excel functions into VBA code
 • Create customized functions using VBA code
MODULE 4 - BRANCHING, LOOPING AND PROCEDURE CODE   
 • Create event handling procedures Use “On Error” statements
 • Create branching code using “If…Then” statements
 • Create looping code using “For…Next” and “Do…Loop” statements 

CPD- 3 Hours
When
4/1/2022 - 3/31/2023 11:59 PM
Where
On-demand