VBA $750 - Purchase this Course Or log in to access your purchased courses Modules VBA 01 - Advanced Excel Features Lessons 1 – Intro to VBA 2 – Excel Functions 1 3 – Excel Functions II 4 – Compounding 5 – Compounding Rates 6 – Discount Factors 7 – Bond Pricing 8 – Offset 9 – Pivot Tables 10 – Homework Prep 11 – Homework Tips and Tricks VBA 02 - VBA Basics Lessons 1 – Subs and Functions Free Preview 2 – Variables 3 – Vectors 4 – Loops 5 – Bond Pricing 6 – Conditional Statements 7 – Linear Interpolation 8 – Linear Interpolation Code 9 – Forward Rates Curve 10 – Forward Rates Code 11 – Homework Prep 12 – VBA Tips and Tricks – HW2 13 – Debugging Your Code VBA 03 - Option Pricing Lessons 1 – Intro to Options 2 – Binomial Asset Pricing Model 3 – Binomial Asset Pricing Model Code 4 – Black Scholes 5 – Homework Prep VBA 04 - Classes Lessons 1 – Cell vs Range 2 – User Data Types 3 – Collections 4 – Classes 5 – Portfolio Analysis 6 – Value At Risk 7 – Homework Prep VBA 05 - Data Structuring Lessons 1 – Selection 2 – Charts 3 – File Manipulation 4 – User Forms 5 – Pivot Tables 6 – SQL 7 – The Interview 8 – Case Study
VBA 01 - Advanced Excel Features Lessons 1 – Intro to VBA 2 – Excel Functions 1 3 – Excel Functions II 4 – Compounding 5 – Compounding Rates 6 – Discount Factors 7 – Bond Pricing 8 – Offset 9 – Pivot Tables 10 – Homework Prep 11 – Homework Tips and Tricks
VBA 02 - VBA Basics Lessons 1 – Subs and Functions Free Preview 2 – Variables 3 – Vectors 4 – Loops 5 – Bond Pricing 6 – Conditional Statements 7 – Linear Interpolation 8 – Linear Interpolation Code 9 – Forward Rates Curve 10 – Forward Rates Code 11 – Homework Prep 12 – VBA Tips and Tricks – HW2 13 – Debugging Your Code
VBA 03 - Option Pricing Lessons 1 – Intro to Options 2 – Binomial Asset Pricing Model 3 – Binomial Asset Pricing Model Code 4 – Black Scholes 5 – Homework Prep
VBA 04 - Classes Lessons 1 – Cell vs Range 2 – User Data Types 3 – Collections 4 – Classes 5 – Portfolio Analysis 6 – Value At Risk 7 – Homework Prep
VBA 05 - Data Structuring Lessons 1 – Selection 2 – Charts 3 – File Manipulation 4 – User Forms 5 – Pivot Tables 6 – SQL 7 – The Interview 8 – Case Study