Financial Modeling Using VBA - On-demand

Financial Modeling Using VBA - On-demand
CFI is a global provider of online financial training courses with a focus on practical applications. Most courses involve hands on Excel tutorials, which take participants beyond the theory to develop job-based skills. All participants are automatically issued certificates of completion after successfully finishing each course. The price of the course varies and are based on a function of a few criteria including, (1) their duration (CPD hours), (2) level of difficulty, and (3) demand for the topic.


EL19200091  

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 

1 Passport Day - 3 PD Hours
When
4/1/2019 - 3/31/2020
Where
On-line