Example Curriculum
Introduction
Available in
days
days
after you enroll
Introducing Macros and VBA
Available in
days
days
after you enroll
Variables and User Input
Available in
days
days
after you enroll
Programming in VBA
Available in
days
days
after you enroll
- Comments (5:12)
- Error Handling With IF Statements (13:19)
- Branching Logic With Else and ElseIf (11:58)
- Formatting Code (4:39)
- Naming Conventions (6:10)
- Using Worksheet Functions in VBA (9:22)
- User Defined Functions - A Simple Example (6:45)
- User Defined Functions - A More Complex Example (7:48)
- Converting UDFs to Add-Ins (5:54)
- The LAMBDA Function - Part 1 (11:30)
- The LAMBDA Function - Part 2 (14:55)
- Objects, Properties and Methods (6:24)
- Exercise: Programming in VBA
- Course Check-In
Userforms
Available in
days
days
after you enroll
- Introducing Userforms (14:34)
- Adding Functionality to Userforms (13:41)
- Enhancing Userforms With Option Buttons (15:06)
- Enhancing Userforms With Combo Boxes (11:30)
- Exercise: Userforms
- Combining Multiple Userforms (11:10)
- Introducing the InfoManager Project (5:28)
- InfoManager Part 1 - Intro (2:43)
- InfoManager Part 1 - Solution (7:27)
- Implement a New Life System
Working With Ranges in VBA
Available in
days
days
after you enroll
- Targeting Ranges With VBA (12:35)
- Advanced Methods For Targeting Ranges (9:06)
- Properties and Methods of Ranges (11:10)
- Exercise: Working with Ranges
- Exercise: Imposter Syndrome (2:55)
- Dynamic Methods For Targeting Ranges (12:31)
- Capturing Ranges As User Input (5:54)
- Writing Formulas With VBA (16:27)
- InfoManager Part 2 - Intro (6:15)
- InfoManager Part 2 - Solution (17:55)
Loops
Available in
days
days
after you enroll
Arrays
Available in
days
days
after you enroll
Worksheets and Workbooks
Available in
days
days
after you enroll
- Working With Worksheets (4:12)
- Iterating Through Worksheets (16:21)
- Consolidating Worksheets (12:54)
- Working with Workbooks (11:40)
- The Workbooks Collection (5:14)
- Opening Multiple Workbooks (13:51)
- Consolidating Workbooks (15:08)
- Worksheet and Workbook Events (11:18)
- Exercise: Worksheets and Workbooks
- InfoManager Part 5 - Intro (8:42)
- InfoManager Part 5 - Solution (19:14)
Pivot Tables
Available in
days
days
after you enroll
Where To Go From Here?
Available in
days
days
after you enroll