Introduction To Excel VBA
  • Introduction - First Steps in Excel VBA
  • Understand The Difference Between a Function And a Sub
  • The Variables
  • The Conditions
  • How Learning VBA for Excel Will Give You a Real Edge in Investment Banking
The Black & Scholes Model with VBA
  • The Black & Scholes Formula
  • B&S
  • The Pricing Function
  • Pricing Function
  • D1 and D2
  • D1 and D2
  • Greeks
  • Greeks
Build a Complete Bond Pricer in VBA
  • Intro to Bonds Instrument
  • Intro to Bonds Instrument
  • The Userform on VBA
  • The Userform on VBA
  • Manage Data Storage
  • Manage Data Storage
  • Introduction to Oriented Object Programmation for VBA
  • Introduction to OOP
  • Implement the Bond Formula
  • The Bond Formula
  • The Userform in Excel
  • Userform on Excel
Learn How to Manipulate Large Quantities of Financial Data
  • Prepare And Format Your Data
  • Data Format
  • Import Your Data From Internet in Excel with VBA
  • Data Import
  • Automate Graphs Generation
  • Graphs Generation
Learn to Link Your Excel Data to a Database
  • Database and Tools
  • Setting up the database
  • Building the Excel Application
  • Application Design with VBA
  • Connect the Function