Course curriculum
-
1
Course Introduction
-
VBA Course Introduction
-
Course Outline
-
Why Use VBA?
-
Case Study Scenario
-
-
2
Custom Formulas
-
Custom Formulas Start File
-
Session Objectives
-
How to Open VBA
-
A Tour of VBA
-
Create a Module
-
Enable Macros Notification
-
A Formula in Excel
-
A Basic Function
-
Making a Variable Dynamic
-
Application.Volatile
-
Future Proofing Our Code
-
Comments
-
Making our Output Currency Dynamic
-
Session Recap
-
Session Summary
-
-
3
Errors and Exceptions
-
Errors and Exceptions Start File
-
Session Objectives
-
Using Breakpoints
-
Tracking Down an Error
-
Option Explicit & Types of Variables
-
Testing Option Explicit
-
Variable Types for Arguments
-
Code Order
-
Other Ways to Track Values
-
Trapping an Exception with On Error Resume Next
-
Exit Function & Colons
-
Session Recap
-
Session Summary
-
-
4
Finalize and Publish Functions
-
Finalize and Publish Functions Start File
-
Session Objectives
-
Currency Recap
-
Catching an Exception By Using an Indented IF
-
Setting Up Our Code to Handle Multiple Output Currencies
-
Output In Any Currency
-
Review the Final Function
-
Saving our Function as an Addin
-
Download a Colleague's File
-
Installing an Addin
-
Preventing Addin Code Conflicts
-
Session Summary
-
-
5
Events & Automations
-
Events and Automation Start File
-
Session Objectives
-
Why use a Central Assumptions File
-
Create a Message Box Routine
-
Call the MSGBOX each time the Workbook Opens
-
Creating the Central Assumptions File
-
Setting Up A Code Framework
-
Pasting Data Back to the Workbook
-
Testing Our Code
-
How to reference another workbook (Excel)
-
Creating a VBA Reference to Another Workbook
-
Using a VBA Reference to GET value from another file
-
Common Errors When Referencing Workbooks
-
Catching an Exception with an IF Statement
-
Ensuring the Update happens every time the file is opened
-
For Each Loop
-
Adapting our Loop
-
Session Summary
-
-
6
Working with Arrays
-
Working with Arrays Start File
-
Sessions Objectives
-
Setting Up Our Project
-
Working With Multiple Workbooks
-
Testing with STOP
-
Selecting a Sheet in Another Workbook
-
Assigning Values to an Array
-
Testing an Array
-
Gathering Data and Returning to This Workbook
-
Methods
-
Resize a Table
-
Populating a Table of Data
-
Loop Through Rows
-
Success or Failure Message
-
Using our Array of Data in our Model
-
Session Summary
-
COUNT - Code Quality Rating
-
-
7
Qualified Assessment
-
Qualified Assessment
-
Excel VBA for Finance course evaluation
-