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

2 – Variables

Chapter 2 – VBA Basics The second chapter of this courses focuses on entry level VBA programming techniques. After some basic fundamentals are taught (no previous programming experience required), we dive into a bit of finance pricing bonds, floaters, and some interpolation.

2 – Variables

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 02 - VBA Basics
    © 2020 ScriptUni

    CONTACT US TODAY TO START PLANNING AHEAD!