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

4 – Classes

Chapter 4 – Classes Now we progress to more advanced VBA topics such as user data types, classes, and collections. Armed with these we can now advance from pricing single instruments to analyzing portfolios.

4 – Classes

Please sign up for the course before starting the lesson.

    VBA 01 - Advanced Excel Features

    • 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

    • 1 – Subs and Functions
    • 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

    • 1 – Intro to Options
    • 2 – Binomial Asset Pricing Model
    • 3 – Binomial Asset Pricing Model Code
    • 4 – Black Scholes
    • 5 – Homework Prep

    VBA 04 - Classes

    • 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

    • 1 – Selection
    • 2 – Charts
    • 3 – File Manipulation
    • 4 – User Forms
    • 5 – Pivot Tables
    • 6 – SQL
    • 7 – The Interview
    • 8 – Case Study
    Back to: VBA > VBA 04 - Classes
    © 2020 ScriptUni

    CONTACT US TODAY TO START PLANNING AHEAD!