ScriptUni ScriptUni
  • Career Coach
  • Additional Resources
    • Career Tips
    • LinkedIn
    • YouTube
  • FAQs
Select Page
  • Cart
  • Contact us
  • Login

VBA

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

Python
© 2020 ScriptUni

CONTACT US TODAY TO START PLANNING AHEAD!