Visual Basic For Applications (VBA) – Excel

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Inputting and Outputting to Excel

Lecture 3: Data Types

Lecture 4: Object Hierarchy

Lecture 5: Simplification and Offset

Lecture 6: Variations – That All Work

Chapter 2: Second Steps

Lecture 1: More on Data Types

Lecture 2: Arrays and User Defined Type Intro

Lecture 3: Using VBA and Excel Functions in Code

Chapter 3: If and Select/Case Statements

Lecture 1: If

Lecture 2: Select Case

Chapter 4: While Loops. For Loops, and For Each Loops

Lecture 1: While Examples

Lecture 2: While Examples 2 (Primes and Collatz)

Lecture 3: While Examples 3 (Backwards Numbers, Bonds Price)

Lecture 4: For Loops

Lecture 5: For Each Loops

Chapter 5: Functions, Passing and Arrays

Lecture 1: Functions Intro

Lecture 2: Functions Practice

Lecture 3: Function Examples #1

Lecture 4: Function Examples #2

Lecture 5: ByVal and ByRef Examples

Lecture 6: Multiple Passes and Passing Arrays – Bubble Sort

Lecture 7: Arrays Reading and Writing Quickly

Lecture 8: Array Methods and More Sorting Examples

Chapter 6: User Forms

Lecture 1: Introduction to User Forms

Lecture 2: User Form Initial Example

Lecture 3: Spin Button and Text Box

Lecture 4: List Box Read and Write

Chapter 7: Buttons / Financial Examples

Lecture 1: Bond Example

Lecture 2: Monte Carlo Option Pricing with Data Tables and VBA

Lecture 3: Swaps and FRAs in VBA with Choices

Lecture 4: Spin buttons in Excel / linking output – Bond discounting example with rotation

Chapter 8: Student Questions

Lecture 1: Counter for List of Information

Lecture 2: Use highlighted values to find statistics

Lecture 3: Summing Across Worksheets with Blank Cells In Between