Financial Modeling using VBA (CF)
The course provides participants with the skills needed to incorporate Visual Basic for Applications (VBA) into financial models.
Corporate Finance Institute (CFI) on-demand courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance and supporting skillsets.
After registering for a CFI On Demand Course, CPA Saskatchewan will send you information on how to access the course within 2 business days.
On completion of the CFI courses, CFI will issue a certificate as supporting documentation for CPD audit purposes.
Click HERE for more information.
The course provides participants with the skills needed to incorporate Visual Basic for Applications (VBA) into financial models. The 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.
The course incorporates sophisticated search and navigation tools that allow participants to go at their own pace while pop quizzes to test what was just learnt. It includes several Excel-based case studies and solutions as well as a PDF - VBA reference guide - that can be used while taking the course and downloaded for future reference.
WHO WILL BENEFIT:
Professionals working in a wide range of finance and accounting positions. The course is ideal for anyone who wants to use VBA to enhance their Excel skills.
Participants will learn how to use VBA for financial modelling through four modules:
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