The Evaluation of Mining Real Estate

Financial Modeling Using VBA

Login to your SavvyInvestor account

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.

Introduction to VBA – Recording Macros

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. This module 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 learnt. 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. By the end of this module, you will have a solid understanding of VBA principles and how to record macros using absolute and relative referencing.

Creating and Using VBA Sub Procedures

In this second module we cover how to create sub procedures using objects, properties and methods. This module includes four 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. This module also 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 learnt. By the end of this module, you will be able design, build and run VBA sub procedures.

Creating and Using Functions in VBA

In this third module we cover how to create and use functions in VBA code. This module includes four 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. 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.

Using More Advanced VBA Code

In this fourth module we cover how to write branching and looping code. This module includes four 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. By the end of this module, you will be able write branching and looping code, create event handling procedures and use "On Error" statements.

Accounting Fundamentals

Reading Financial Statements

Financial Analysis

Financial Math

Fundamentals of Financial Modeling

Building a Financial Model

Financial Modeling Using VBA

Business Valuation Fundamentals

Behavioural Finance

Capital Markets Fundamentals