Course curriculum

  • 1

    VBA for Finance in a Chat GPT World

    • READ THIS FIRST!

    • Module 1: Intro & Why Learn VBA? Especially Now with AI

    • Demo_ChatGPT_Empty

    • Demo_Speed

    • Demo_Scale
  • 2

    VBA Basics

    • Module 2: VBA Basics

    • Demo_Macro_Recorder

    • Demo_First_Code

    • Exercise_First_Code

    • Exercise_First_Code_Complete
  • 3

    Storing, Using, and Referencing Data in VBA

    • Module 3: Storing, Using, and Referencing Data in VBA

    • Demo_Variables1

    • Demo_Variables2

    • Demo_Offset1

    • Exercise_Variables_Offset

    • Exercise_Variables_Offset_Complete
  • 4

    Using VBA to Move Around and Repeat

    • Module 4, Part I: Using VBA to Move Around and Repeat

    • Demo_SimpleLoop

    • Exercise_SimpleLoop

    • Exercise_SimpleLoop_Complete

    • Module 4, Part II: Using VBA to Move Around and Repeat

    • Demo_Offset2

    • Exercise_ForNextOffset

    • Exercise_ForNextOffset_Complete
  • 5

    Creating a Scenario Generator

    • Module 5: Creating a Scenario Generator

    • Demo_ScenGen

    • Exercise_ScenGen

    • Exercise_ScenGen_Complete

    • Demo_IntScenGen
  • 6

    Understanding and Using AI to Build VBA Code

    • Module 6, Part I: Understanding and Using AI to Build VBA Code

    • Demo_ChatGPT_Tests

    • Module 6, Part II: Understanding and Using AI to Build VBA Code

    • Exercise_AIPrompts

    • Exercise_AIPrompts_Complete
  • 7

    Data / Asset Aggregation

    • Module 7, Part I: Data / Asset Aggregation

    • Demo_SheetAgg

    • Demo_VBA_Agg1

    • Demo_VBA_Agg2

    • Module 7, Part II: Data / Asset Aggregation

    • Demo_VBA_CalcAgg

    • Exercise_Aggregate

    • Exercise_Aggregate_Complete
  • 8

    Auditing VBA Code

    • Module 8: Auditing VBA Code

    • Demo_CommonProblems

    • Exercise_AuditThis

    • Exercise_AuditThis_Complete