Project Based Excel VBA Course

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Ranges and Cells

Lecture 1: ★★★★ Developer Tab

Lecture 2: ☆☆☆☆☆ VBA Editor

Lecture 3: ★★★★ Dot Notation

Lecture 4: ☆☆☆☆☆ Ranges and Cells (Part 1)

Lecture 5: ☆☆☆☆☆ Ranges and Cells (Part 2) – Other Range Properties

Lecture 6: ☆☆☆☆☆ Debugging

Lecture 7: ★★★ Extra Functions

Lecture 8: Exercise 1 – Boat Stuff

Lecture 9: Exercise 2 – Debugging

Lecture 10: Course Project Introduction – Battleship!

Lecture 11: Project Step 1

Chapter 3: Variables and IF THEN

Lecture 1: ☆☆☆☆☆ Variables

Lecture 2: ☆☆☆☆☆ IF THEN

Lecture 3: Exercise – More Boat Stuff

Lecture 4: Project Step 2

Chapter 4: Text Manipulation

Lecture 1: ★★★★ Strings (Part 1)

Lecture 2: ★★★★ Strings (Part 2)

Lecture 3: Exercise – Job Application

Chapter 5: Loops and Arrays

Lecture 1: ☆☆☆☆☆ Loops (Part 1 – FOR and FOR EACH)

Lecture 2: ★★★★ Loops (Part 2 – DO LOOP)

Lecture 3: ☆☆☆☆☆ Arrays (Part 1 – Static and Dynamic Arrays)

Lecture 4: ★★★ Arrays (Part 2 – ARRAY() and Multidimensional Arrays)

Lecture 5: Exercise – Adding headers into a list

Lecture 6: Project Step 3.1 – NewGame

Lecture 7: Project Step 3.2 – StartGame Overview and PopulateLog Solution

Lecture 8: Project Step 3.3 – FindBoats Solution

Lecture 9: Project Step 3.4 – FormatBoats Solution

Lecture 10: RESOURCES – Project Step 3 Solution

Chapter 6: Subs and Functions

Lecture 1: ☆☆☆☆☆ Subs (Part 1 – Calling Subs)

Lecture 2: ☆☆☆☆☆ Subs (Part 2 – Passing Parameters)

Lecture 3: ★★★ Functions

Lecture 4: Exercise – Medical form

Lecture 5: Project Step 4.1 – StartGame Edits

Lecture 6: Project Step 4.2 – FireShot Overview

Lecture 7: Project Step 4.3 – FindTarget Solution

Lecture 8: Project Step 4.4 – FireShot, HitMessage, DoTurn Solution

Lecture 9: Project Step 4.5 – Adding Buttons

Lecture 10: RESOURCES – Project Step 4 Solution

Chapter 7: Files

Lecture 1: ★★★ Excel Files

Lecture 2: ★★★ Text/CSV Files (Part 1 – Reading)

Lecture 3: ★★★ Text/CSV Files (Part 2 – Writing)

Lecture 4: Exercise – Listing Files

Lecture 5: Project Step 5

Chapter 8: Forms

Lecture 1: ★★★ User Interface Forms

Lecture 2: ★★★ Progress Bars

Lecture 3: Exercise – Password

Lecture 4: Project Step 6 (Finale)

Chapter 9: Outro

Lecture 1: Final Thoughts

Chapter 10: Supplemental Projects

Lecture 1: Battleship! (Unstructured version of Course Project)

Lecture 2: NCAA March Madness Bracket

Lecture 3: Task List Companies

Lecture 4: Companies in a Cell

Lecture 5: PDF Renamer