Autoplay
Autocomplete
Previous Lesson
Complete and Continue
VBA Programming for Excel: Zero to Mastery
Introduction
VBA Programming (2:23)
Exercise: Meet Your Classmates and Instructor
ZTM Plugin + Understanding Your Video Player
Cheatsheet
Set Your Learning Streak Goal
Introducing Macros and VBA
A Note to Mac Users (2:26)
Hello World - Introducing Macros (5:39)
Opening Macro-Enabled Files (3:22)
Editing Macros (11:23)
Subroutine Structure (11:00)
Buttons and Shapes (7:17)
The Personal Workbook (10:01)
Exercise: Introducing Macros and VBA
Let's Have Some Fun (+ Free Resources)
Variables and User Input
Introducing Variables (4:22)
Using Variables in Expressions (11:49)
Option Explicit (4:26)
Gathering User Input (6:53)
Gathering User Input - A More Complex Example (7:38)
Exercise: Variables and User Input
Unlimited Updates
Programming in VBA
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)
Objects, Properties and Methods (6:24)
Exercise: Programming in VBA
Course Check-In
Userforms
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
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
Do Loops (8:12)
Debugging Tools (4:43)
Validating User Input With Do Loops (11:52)
For Next Loops (9:47)
Nested Loops (15:16)
For Each Loops (8:07)
Loops - Example Subroutine (15:19)
Loops - Example UDF (10:19)
Exercise: Loops
InfoManager Part 3 - Intro (5:34)
InfoManager Part 3 - Solution (17:08)
Arrays
Introducing Arrays (7:52)
Dynamic Arrays With ReDim Preserve (14:06)
The SPLIT Function (17:15)
Exercise: Arrays
InfoManager Part 4 - Intro (10:43)
InfoManager Part 4 - Solution (9:32)
Worksheets and Workbooks
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
External Data and VBA (14:22)
Controlling Pivot Tables With VBA (14:48)
Exercise: Pivot Tables
InfoManager Part 6 - Intro (6:28)
InfoManager Part 6 - Solution (15:09)
Where To Go From Here?
Thank You! (1:17)
Review This Course!
Become An Alumni
Learning Guideline
ZTM Events Every Month
LinkedIn Endorsements
Working With Worksheets
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures