Recommended Recommended Prep Courses

These preparatory courses are optional, but we recommend you to complete the stated prep course(s) or possess the equivalent knowledge prior to enrolling in this course:

  1. Building a Financial Model in Excel
  2. Business Valuation Modeling

Excel VBA Course Overview

This four-part Excel VBA 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.

Excel VBA Course screenshot

Introduction to Excel VBA course for financial modeling

In this first module, we explore the benefits of using VBA in financial models, outline how to navigate around the Visual Basic Editor Window and record a wide range of macros. By the end of this module, you will have a solid understanding of VBA Excel principles and how to record macros using absolute and relative referencing.

  • Explain the benefits of VBA in financial models
  • Navigate around the VBE window
  • Record macros using absolute and relative referencing

Learn VBA in Excel with this course

Design, build and run Excel VBA sub procedures

In this second section of this Excel VBA course, we cover how to create sub procedures using objects, properties, and methods. By the end of this module, you will be able to 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

Create customized Excel functions

In this third section of the course, we cover how to create and use functions in VBA code. By the end of this module, you will be able to take advantage of a wide range of VBA functions, incorporate Excel functions into your VBA code and create customized Excel functions.

  • Utilize unique VBA functions
  • Incorporate Excel functions into VBA code
  • Create customized functions using VBA code

Excel VBA tutorial sub procedure

Branching, looping and procedure code

In this fourth module we cover how to write branching and looping code. By the end of this module, you will be able write branching and looping code, create event handling procedures and use “On Error” statements.

  • 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

This section of the Excel VBA course incorporates sophisticated search and navigation tools that allow you to go at your own pace while pop quizzes get you to test what you have just learned. This module 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 to your computer for future reference.

Example of Excel VBA course lesson

Who should take this Excel VBA course?

This Excel VBA course is designed for professionals working in a wide range of finance and accounting positions.  It's ideal for anyone who wants to use VBA to enhance their Excel skills.

For further CPE information, please read before purchasing:


What You'll Learn


Financial Modeling using VBA

$147.00 Enroll Now Free Preview

Approx 2.0 hrs to complete

Path to Certification

Prerequisite Courses

6 courses from beginner to intermediate level.


Core Courses

10 courses from beginner to intermediate level.


Elective Courses

Take 3 out of 9 courses at an advanced level.


Get Certified

Submit your FMVA®️ checklist and order your certificate.


Join Our Community

Get access to the Global Corporate Finance Society.


How the Certification Works

FMVA® Financial Analyst Certification courses are offered 100% online, allowing you the flexibility to start the financial analyst program anytime and learn when it’s most convenient for you.
Students must complete all core and elective courses (12 in total) and demonstrate mastery of the topics through successful completion of course materials, quizzes, and assessments.
Within 48 hours of program completion, your Blockchain Verified FMVA Certification will be emailed to you.

What Our Students Say

Reinis Rudolfs Ozolkaja
Most frustrating about this course: *) Several 20 second videos. Very annoying to have to constantly click next and lose focus when you could just merge videos to be not that ridiculously short. *) The presenter speaks very slowly and sometimes with annoying too long pauses. Makes me feel like I'm losing time. Also, he speaks as if educating people in elementary school or a retirement home. I don't think that's your primary audience. *) Seems unprofessional that you use 12 year old software (Excel 2007) for demonstration in this course. And even spend half the time talking about Excel 2003 (at least in the introduction section). If I'm not wrong at least Excel 2013 is used in most of your other courses. That's just form spending 15 minutes on the VBA course. Also, I think it would benefit you if you included text field questions asking to comment the course in the surveys that have to be completed at the end of each course. I'm pretty sure most people has at least something to add about how to improve the courses, but not everyone wants to write these formal reviews, with no anonymity that you personally answer to afterwards.
Teka Derick Tikum

Michelle Jackson
Really useful!
This is my first time programming in VBA. I found the introductions and course material very good and learned a lot from the hands-on examples.
Rustom Rupand
Great VBA course!
I have not seen any other courses on VBA with financial modeling before - super interesting to understand how you use VBA in your Excel model.
See More

Frequently Asked Questions

Can I download the Excel files and financial modeling templates?
How long do I have to complete the courses?
Are CFI courses verified?
Are there any additional fees or costs?
What currency are your courses priced in?
How do I earn my certificates?
Can I email the instructor if I have questions?
Will these courses help me advance my career?
More Questions?

FMVA® Financial Analyst Certification

Become a Financial Modeling and Valuation Analyst (FMVA)® by completing all required courses in accounting, finance, modeling, Excel, presentations, and strategy. From beginner to advanced courses you will have the complete training you need to become a world-class financial analyst.