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

3 – File Manipulation

Chapter 5 – Data Structuring This chapter focuses on importing/exploring data, automating reports, UI, and other general VBA topics. While not quantitative in nature, these skills are frequently used in finance and should not be glossed over.

3 – File Manipulation

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 05 - Data Structuring
    © 2020 ScriptUni

    CONTACT US TODAY TO START PLANNING AHEAD!