This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Standard Edition - Excel Macros and VBA School
Module 1 – Course Introduction & Power Up Your Learning!
Lesson 1 - Introduction to the Course (4:23)
Lesson 2 - Course Information
Lesson 3 - How to Study This Course (9:39)
Lesson 4 - Course Structure and Encouragement
Lesson 5 - Using the Course Platform
Module 1 Quiz
Roadmap: Course Overview (Printable PDF)
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!
Watch this: Why you'll love modules 5 - 10 (2:33)
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
Lesson 20 - Ranges (Variable Size)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock