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 3 - Saving Macros and Macro Security
Download
Write your comments and feedback below
If you have questions or comments about this lesson, write it in the section below.
Alternatively you can email the instructor Victor at
[email protected]
Complete and Continue
Discussion
0
comments
Load more
0 comments