Module 1 - Course Introduction & Power Up Your Learning!
BONUSES (Premium Edition)
-
BONUS: Download ANY video from this course for offline viewing...
-
BONUS: Excel VBA Top 40 Code Samples (Workbook)
-
BONUS: Lifecycle of your VBA Program (Cheat Sheet)
-
BONUS: Maximize Your Learning (PDF E-Book)
-
BONUS: One page checklist: -- Maximize Your Learning (PDF)
-
BONUS: 3 months of personal e-mail support
Module 2 - Getting Started with Excel Macros and VBA
-
Lesson 1 - Introduction to Macros and VBA (8:02)
-
Lesson 2 - Recording and Playing back Macros (8:51)
-
Lesson 3 - Saving Macros and Macro Security (13:06)
-
Lesson 4 - More Ways to Play Back Macros (14:33)
-
Module 2 Quiz
-
Module 2 - Projects Introduction
-
Project 1: Formula Auditing Macros
-
Project 2: Workbook Navigation Macros (Shapes)
-
Project 3: Workbook Navigation Macros (Buttons)
-
Project 4: Personal Macro Workbook Macros
Module 3 - Master the Excel VBA Editor
-
Lesson 1 - Unlock the Power of Macros with the VBA Editor (10:38)
-
Lesson 2 - Finding Your Way Around the VBA Editor (15:17)
-
Lesson 3 - Writing Our First Macros in the Code Window (9:25)
-
Lesson 4 - How to Modify Existing Macros (14:05)
-
Lesson 5 - The Importance of Comments for Code Readability (13:22)
-
Module 3 Quiz
-
Module 3 - Projects Introduction
-
Project 1: Activating the VBA Editor
-
Project 2: Using the VBA Editor
-
Project 3: Your First Written Macros
-
Project 4: Editing your Recorded Macros
-
Project 5: Make your Macros Easier to Read
Module 4 - Understand the Excel Object Model
-
Lesson 1 - Overview of the Excel Object Model (7:58)
-
Lesson 2 - Excel Object References and Simplifying References (10:21)
-
Lesson 3 - Excel Object Properties with the Macro Recorder, plus two ways to simplify references (19:30)
-
Lesson 4 - Excel Object Methods (9:47)
-
Lesson 5 - Excel Object Events (11:51)
-
Lesson 6 - Learning more about the Excel Object Model (12:01)
-
Module 4 Quiz
-
Module 4 Projects Introduction
-
Project 1: Excel Object References Using The Dot Operator
-
Project 2: Playing With Object Properties
-
Project 3: Playing With Object Methods
-
Project 4: Playing With Object Events
-
Project 5: Using the Excel Object Browser
IMPORTANT NOTICE!
Module 5 - Vital Building Blocks (Controlling Program Flow)
-
Module 5 PDF Handout Download
-
Module 5 Workbooks Download
-
Lesson 1 - Variables, Constants and Data types (3:04)
-
Lesson 2 - Option Explicit (3:17)
-
Lesson 3 - Declaring Variables (4:28)
-
Lesson 4 - Type Mismatch and Variants (4:07)
-
Lesson 5 - Scope (5:28)
-
Lesson 6 - Declaring Constants (3:44)
-
Module 5 Quiz 1
-
Lesson 7 - If Then (9:22)
-
Lesson 8 - Select Case 1 (8:26)
-
Lesson 9 - Select Case 2 (5:23)
-
Lesson 10 - For Next (7:26)
-
Lesson 11 - For Each Next 1 (7:52)
-
Lesson 12 - For Each Next 2 (5:30)
-
Module 5 Quiz 2
-
Module 5 Projects Introduction
-
Project 1 - Declaring Variables
-
Project 2 - Declaring Constants
-
Project 3 - Option Explicit
-
Project 4 - Scope
-
Project 5 - If Then
-
Project 6 - Select Case
-
Project 7 - For Next
-
Project 8 - For Each Next
Module 6 - The Big Three (Workbooks, Worksheets, Ranges)
-
Module 6 PDF Handout Download
-
Module 6 Workbooks Download
-
Lesson 1 - Introduction to the Big Three (2:54)
-
Lesson 2 - Workbooks (No User Input) (4:51)
-
Lesson 3 - Workbooks (User Input) (7:08)
-
Lesson 4 - Workbooks (Information / Properties) (3:37)
-
Lesson 5 - Worksheets (Names) (8:34)
-
Lesson 6 - Worksheets (Add) (4:51)
-
Lesson 7 - Worksheets (Delete) (2:56)
-
Lesson 8 - Worksheets (Move Copy Hide Protect) (5:40)
-
Module 6 Quiz 1
-
Lesson 9 - Ranges (basics part 1 - Select) (4:29)
-
Lesson 10 - Ranges (basics part 2 - Write and Read) (8:57)
-
Lesson 11 - Ranges (basics part 3 - Copy values and Clear contents) (4:12)
-
Lesson 12 - Ranges (Borders) (5:10)
-
Lesson 13 - Ranges (Comments) (4:48)
-
Lesson 14 - Ranges (Cut Copy Paste) (2:31)
-
Lesson 15 - Ranges (Paste Special) (4:49)
-
Lesson 16 - Ranges (Insert Delete Hide Unhide) (7:38)
-
Lesson 17 - Ranges (Rows and Columns) (4:58)
-
Lesson 18 - Ranges (Resize) (4:14)
-
Lesson 19 - Ranges (Offset Intersect Union) (3:57)
-
Lesson 20 - Ranges (Variable Size) (7:22)
-
Module 6 Quiz 2
-
Module 6 Projects Introduction (1:32)
-
Project 1 - Save and Close Workbooks
-
Project 2 - Create new Workbook for each Worksheet
-
Project 3 - Protect all Worksheets
-
Project 4 -Synchronize Worksheets to the Activesheet View (3:49)
-
Project 5 – Sort Sheets Alphabetically (Challenge) (7:16)
-
Project 6 - Learning About Ranges
-
Project 7 - Tic Tac Toe (Challenge) (2:20)
Module 7 - Human Interaction (Input Boxes, Message Boxes, User Forms)
-
Module 7 Workbooks Download
-
Lesson 1 - Introduction to User Interaction (1:55)
-
Lesson 2 - InputBox Function (Simple) (5:55)
-
Lesson 3 - InputBox Function (Improved) (8:38)
-
Lesson 4 - InputBox Method (Ranges) (9:45)
-
Lesson 5 - Message Boxes (11:15)
-
Lesson 6 - Intro to User Forms (8:37)
-
Lesson 7 - Progress Bar Design (10:24)
-
Lesson 8 - Progress Bar Coding (10:21)
-
Module 7 Quiz
-
Module 7 Projects Introduction
-
Project 1 - Input Boxes
-
Project 2 - Message Boxes
-
Project 3 - Progress Bar User Form
Module 8 - The Power of Named Ranges
-
Module 8 Workbooks Download
-
Lesson 1 - Introduction to Named Ranges (10:01)
-
Lesson 2 - Adding and Resizing Named Ranges (10:25)
-
Lesson 3 – Selecting and Looping Named Ranges (10:04)
-
Lesson 4 – Deleting Named Ranges (8:35)
-
Module 8 Quiz
-
Module 8 Projects Introduction
-
Project 1 – Adding Named Ranges
-
Project 2 – Resizing Named Ranges
-
Project 3 – Deleting Named Ranges
Module 9 - Awesome Excel Tables with VBA
-
Module 9 Workbooks Download
-
Lesson 1 - Introduction to Excel Tables (12:44)
-
Lesson 2 - Table Anatomy (Creating new Tables, Selecting Table Parts) (14:25)
-
Lesson 3 - Sorting, Filtering and the Total Row Calculations (23:16)
-
Lesson 4 - Table modifications (Insert, Remove, Clear) (16:18)
-
Module 9 Quiz
-
Module 9 Projects Introduction
-
Project 1 - Adding Excel Tables
-
Project 2 – Sorting and Filtering Excel Tables
-
Project 3 – Keeping the Top 20 Percent of Test Scores
Module 10 - Super Power Arrays and VBA Program Development
-
Module 10 Workbooks Download
-
Lesson 1 - The Benefits of using VBA Arrays (12:07)
-
Lesson 2 - Static Arrays (11:55)
-
Lesson 3 - Dynamic Arrays (11:57)
-
Lesson 4 - Overview of Student Grading Spreadsheet (Part 1 of 3) (9:12)
-
Lesson 5 - VBA Deep Dive into Student Grading Spreadsheet (14:47)
-
Lesson 6 - BONUS: Filter and Sort using Worksheet Events (10:37)
-
Lesson 7 - Program Development Cycle (PCTA) (10:27)
-
Module 10 - Quiz
-
Module 10 Projects Introduction
-
Project 1 - Static 1D Arrays
-
Project 2 - Dynamic Arrays
