Become an Excel VBA Expert

Master VBA and automate Excel tasks to save time and boost productivity.

SALE Price: $495 $195

Sale Ends in...

00
Hours
00
Minutes
00
Seconds

Here's Everything You Get

Full VBA Course

200+ Tutorials - 14 Core Sections - 14 Assignments - 40+ Feature Tutorials - 3 Real-World Projects

Unlimited Access

Pay once!

Keep forever!

Watch whenever!

Premium Email Support

Got questons? No problem, you get direct email access to the creator of the course, Don.

Excel Guides

Fully commented Excel Reference  Guides come with every tutorial so that you can open the file and know exactly what is happening and why.

Excel Code Templates

Jump-start every project with over 40 pre-made code templates that you can copy/paste into any project - they include Importing, Exporting, Emailing, Selecing Files and much more!

Working Projects

Real-world projects, fully customizable and ready for you to use. (Billing/Invoice System, Task Manager System & The Data Analysis System - Import/Analyze/Export/Email)

Advanced Course Design

  • 200+ Video Tutorials
  • 14 Core Lesson Sections
  • 14 Core Assignments (Build an Invoice/Billing System
  • 40+ Excel VBA Feature Tutorials
  • 3 Real World Projects

SALE Price: $495 $195

Price: $495

60% Discount!

Sale ends in:

00
Hours
00
Minutes
00
Seconds

Course Delivery

  • 24/7 Lifetime Access
  • Self-Paced Video Tutorials
  • Watch on Mobile, Tablet or Desktop
  • Re-watch, Fast-forward, Rewind the Videos
  • Excel Reference Files for Every Tutorial & Project

Testimonials

How has this course helped you? Saved me a fortune in time and paying someone to carry out the work for me.

What was your favorite part of the course? I enjoyed the whole course as you can choose which parts to learn as you need them.

Would you recommend this course to a friend? Absolutely

Excellent, easy to follow course. Money and more importantly TIME saver.

Great value for money.

Mark B.Managing Director

TeachExcel is the best, most thorough explanation of how to create macros utilizing the Visual Basic language.

Customer service is great as well. I got hung up a few times trying to tailor the course material to my specific needs and they were quick to respond to my questions and even looked at my source code and told me where I was messing up.

The best teacher and overall experience I have ever had in a coding class.

Garry L Mullins JrHealth, Safety, & Environmental Trainer

I can honestly say it is the best VBA course I have ever seen or experienced and I would have absolutely no hesitation in recommending this course to anyone who desires to master excel VBA.

Yunus BhulaAccountant

I'm actually a Master JOAT (Jack Of All Trades). I wear many hats on this job because my supervisor knows that if he asks me to do something then I will figure out how to do it and do it well.

My current task is a skill set database of all our employees. I built that in Excel, but now I'm creating macros and user forms to assist in searching information from the database and inputting new information into the database.

Keith B.Safety Manager, Service Industry

Frequently Asked Questions

Is VBA/Macro experience required to take the course?

No VBA or Macro experience is required to take this course.

How long can I access this course?

Forever! You pay once and you get lifetime access to the course.

What version of Excel does this work for?

Excel 2007 and newer versions. This course focuses almost entirely on code that works across all versions of Excel from 2007 and newer. However, some tutorials will use newer features from Excel 2010/2013, but that is rare.

How long will it take to finish the course?

That's up to you - you can finish it in a week or take your time and finish it in a month, or, if you are in a real hurry, finish it in just a few days. The course runs over 50 hours and has over 200 downloadable files, but you take the course as slow or as fast as you want.

What if I have questions?

Once you purchase the course, you will receive premium email support.

Questions? Ask Us!

Course List

ALL tutorials come with a downloadable Excel File/Guide

(Except the Preview and How to Use the Course videos.)

Introduction

9:39
Excel VBA Course Preview

First Steps

2:55
How to Use the Course
27:27 Has File
Your First Macro! (The VBA/Macro Intro.)
1:58 Has File
Quick Tip to Better Understand VBA Code
15:45 Has File
The Visual Basic Editor Interface (VBE)
17:24 Has File
The Basics of How VBA Works (Objects & The Object Browser)
6:14 Has File
The Macro Recorder (Good & Evil)

Working with Cells and Ranges

12:25 Has File
Reference Cells and Ranges
10:56 Has File
Advanced Range Selection
4:49 Has File
Never Select Cells Again
12:14 Has File
Learn New Commands on Your Own & Do Something Useful with Ranges (Macro Recorder + Object Browser)
8:45 Has File
Reference Rows and Columns
9:27 Has File
Practical Use of Better Range References and Number Formatting (On Imported Data)
5:11 Has File
Activate vs. Select - The Important Difference
7:00 Has File
User Selected Cells and Ranges
9:17 Has File
Offset Ranges
28:14 Has File
Powerful Range Methods You Must Know - Union, Resize, CurrentRegion and Intersect

Assignment 1 - Ranges

4:43 Has File
Assignment Task - Ranges & Assignment Section Explanation
10:50 Has File
Assignment Answer - Ranges

Practical Tasks - Ranges

14:29 Has File
Find the Next Empty or Last Row/Column (The Complete Guide)
9:11 Has File
Select Cells, Ranges, Rows and Columns within Other Ranges
5:05 Has File
The Proper Way to Work with Ranges (Advanced)

Get & Input Data into the Worksheet

16:29 Has File
Get, Input, Clear, and Move Values Around a Worksheet
7:12 Has File
Storing Data in the Macro
12:01 Has File
Copy and Paste Data
15:24 Has File
Working with Formulas
21:35 Has File
Insert/Delete Cells, Ranges, Rows & Columns
6:22 Has File
Additional Ways to Get/Input Data into the Worksheet

Assignment 2 - Get & Input Data

3:10 Has File
Assignment Task - Get & Input Data
18:30 Has File
Assignment Answer - Get & Input Data

Working with Worksheets

13:48 Has File
Reference Worksheets
5:13 Has File
Additional Method to Reference Worksheets
5:32 Has File
Navigate to and Select Worksheets
2:55 Has File
Work on the Currently Visible Worksheet
15:02 Has File
Reference Cells and Ranges on Other Worksheets
21:46 Has File
Adding and Removing Worksheets
8:32 Has File
Work on New Worksheets - Rename, Add Data, etc.
10:32 Has File
Move and Copy Worksheets
9:53 Has File
Common Worksheet Properties
4:27 Has File
The Proper Way to Work with Worksheets
10:09 Has File
Cross-Worksheet (and Workbook) Range Reference Concept - Very Important

Assignment 3 - Worksheets

3:50 Has File
Assignment Task - Worksheets
4:04 Has File
Assignment Answer - Worksheets

Add Logic and Control to Macros

22:09 Has File
IF Statement - The Foundation of Decision Making
20:30 Has File
IF Statement Advanced
19:20 Has File
Select Case Statement - Make More Readable Decisions
13:10 Has File
With Statement - Easier Code Writing
22:33 Has File
GoTo Statement - The correct way to use this!
9:44 Has File
Simplify Complex IF Statements
9:48 Has File
Case Insensitive Checks - Control How VBA Compares Text
17:00 Has File
Arithmetic Operators - Let's Do Math!
9:45 Has File
Comparison Operators
6:02 Has File
Logical Operators - Allow Multiple Conditional Checks
16:31 Has File
Operator Precedence - Control What Occurs When

Assignment 4 - Logic & Control

4:01 Has File
Assignment Task - Logic & Control
24:18 Has File
Assignment Answer - Logic & Control

Variables Introduction

14:12 Has File
What are Variables and How to Use Them
6:36 Has File
Option Explicit - Forced Declarations - When, How, and Why to Use It
8:12 Has File
How to Name Variables - Helpful Tips and Common Pitfalls
26:58 Has File
Variable Types - A Guide
7:55 Has File
Declaring Variables - Rules, Tips, and Shortcuts
18:56 Has File
Object Variables - Part 1 - Ranges, Worksheets, and Workbooks
10:19 Has File
Object Variables - Part 2 - Set to Nothing or Not
6:57 Has File
Helpful Shortcuts for Working with Variables

Assignment 5 - Variables Introduction

1:19 Has File
Assignment Task - Variables Introduction
18:20 Has File
Assignment Answer - Variables Introduction

Popup Windows & User Input

31:10 Has File
Message Boxes with Buttons, Formatting, and Style
12:10 Has File
Message Box Button Clicks - Making Decisions from Message Boxes
23:25 Has File
InputBox - Simple User Input
16:49 Has File
Get Input - The Better Way - Part 1 - Introduction
16:03 Has File
Get Input - The Better Way - Part 2 - More Features and Caveats
11:11 Has File
Formula Input
7:35 Has File
Date Input
12:42 Has File
Select a Cell or Range from a Prompt
11:47 Has File
Get Multiple Inputs from the User

Assignment 6 - Popup Windows & Input

1:30 Has File
Assignment Task - Popup Windows & Input
6:30 Has File
Assignment Answer - Popup Windows & Input

Practical Tasks - Searching, Worksheet Functions & More

15:34 Has File
Validate Data & User Input with VBA
26:10 Has File
Search for Values in Excel - Single Match or All Matches
15:57 Has File
Advanced Searching for Values - Entire Workbook Search, Wildcards, Formatting Search and Last Row Search
18:43 Has File
Using Worksheet Functions in Macros (Simple & Advanced)
21:17 Has File
Special Cell Magic - Finding/Deleting Empty Rows, Working with Filtered Data & More
12:23 Has File
Calling Other Macros and Passing Values - An Introduction

Working with Workbooks

9:49 Has File
Reference Workbooks
4:05 Has File
Reference the Current Workbook
8:55 Has File
Create a New Workbook - 3 Ways
15:10 Has File
Open Workbooks - Including Password Protected and Read Only
14:58 Has File
Save Workbooks - 4 Ways
12:59 Has File
Close Workbooks - Including All of Excel and With and Without Saving
21:09 Has File
Delete a Workbook
22:23 Has File
Work on New, Opened, and Other Workbooks - The Proper Way!
11:53 Has File
Check if a Workbook Exists and is Open - Prevent Errors

Assignment 7 - Workbooks

1:45 Has File
Assignment Task - Workbooks
5:36 Has File
Assignment Answer - Workbooks

Loops

5:52 Has File
What are Loops and How are they Useful?
19:30 Has File
Do Loops - Do While, Do Until, & Infinite
14:43 Has File
For Next Loop
16:01 Has File
For Each Loop
3:19 Has File
While Wend Loop
7:51 Has File
Nesting Loops - Controlling Loops within Loops
22:06 Has File
Stop Loops Early - User Controlled, Automatic, and Nested
7:42 Has File
Advanced Loop Condition Checks
12:42 Has File
Loop through Cells, Worksheets, and Workbooks using Collections - The Proper Way

Assignment 8 - Loops

1:32 Has File
Assignment Task - Loops
14:12 Has File
Assignment Answer - Loops

Practical Tasks - Tables & Shapes (The Ultimate Guide)

3:34 Has File
Tables - The Simple Way
52:33 Has File
Tables - Advanced Guide (Everything You Need to Know)
34:16 Has File
Shapes - The Basic Guide
29:17 Has File
Shapes - Advanced Techniques & Working with Multiple Shapes
15:26 Has File
Shapes - Looping and Legacy Form Controls

Project: The Task Manager

3:23 Has File
Introduction to the Project
10:24 Has File
Planning the Project's Coding and Visuals (A Design Framework)
17:56 Has File
Visuals Creation - Professional Tables, Rounded Corners, Stylish Buttons
41:06 Has File
The First Code - How to Build More Complex Macros and Code Structures
21:13 Has File
How to Save Time by Reusing Code Safely
27:36 Has File
User-Friendly Support Functions - Viewing, Refreshing, Clearing Values and More
24:40 Has File
Adding Dynamic Buttons to Entries in a Table to Manage Them - Edit and Delete
7:36 Has File
Protecting Everything using VBA
2:28 Has File
The Completed Project

Practical Tasks - User Input Applications & File Selections

4:38 Has File
Simple System for Using a Default Input Value and Validating It
8:25 Has File
Force the User to Input Something - 2 Ways
10:27 Has File
Require Single Cell Selection - And How to Structure More Advanced Code
5:55 Has File
Zero and "False" Inputs - Avoiding Common Errors
18:00 Has File
Let the User Choose Which Files to Work With - Including Filtered Selections
9:15 Has File
Multiple File Selection - How to Allow it and Work with The Files
9:17 Has File
Let the User Choose Where to Save Files and Under What Name and Type

Variables - Unlocking Their Power

22:18 Has File
Variable Scope - Project Variables, Module Variables, and Procedure Variables
11:29 Has File
Precedence - Controlling Variables with the Same Name
20:41 Has File
Constants - Hardcoding for Strength
8:27 Has File
Static - Keep My Variables Alive
10:09 Has File
Variable Default Values - How to Check for Them and Reset Them
15:41 Has File
Determine Variable Type - Enables Better Coding
13:09 Has File
Sheets vs. Worksheets - What You Need to Know

Assignment 9 - Variables

1:41 Has File
Assignment Task - Variables
8:19 Has File
Assignment Answer - Variables

Practical Tasks - Debugging Your Macros & VBA

21:03 Has File
Breaking Apart Macros for Debugging
18:47 Has File
Analyzing Variables with the Locals and Watch Windows
13:38 Has File
Quick and Powerful Checks with the Immediate Window
2:58 Has File
Option Explicit and Compile VBA Project
2:42 Has File
Stop a Long-Running or Frozen Macro

Arrays in VBA - The Power Variable

7:19 Has File
What is an Array in VBA and How to Make Your First Array
12:55 Has File
Static Arrays - You Decide the Size
19:03 Has File
Dynamic Arrays Part 1 - Increased Flexibility
10:50 Has File
Dynamic Arrays Part 2 - Dynamic Resizing
13:58 Has File
Multi-Dimensional Arrays - First Step to Working with Ranges in Arrays
15:02 Has File
Arrays & Ranges Part 1 - Super Fast Range Evaluation
11:55 Has File
Arrays & Ranges Part 2 - Dynamic Ranges & Single Cell Selection
5:57 Has File
Easy Array Looping - Look but Don't Touch
20:07 Has File
Helpful Array Features - Clearing, Checking, Splitting, Joining and Option Base

Assignment 10 - Arrays

1:00 Has File
Assignment Task - Arrays
6:10 Has File
Assignment Answer - Arrays

Error Handling

21:48 Has File
Error Handling
9:27 Has File
Make Better Decisions with Errors
11:25 Has File
Elegant Custom Errors and Messages

Assignment 11 - Error Handling

2:45 Has File
Assignment Task - Error Handling
8:51 Has File
Assignment Answer - Error Handling

Automating Macros

13:25 Has File
How to Make Macros Run Automatically
22:07 Has File
Workbook Automation Events - Opening, Closing, Saving and Navigating Worksheets
23:21 Has File
Worksheet Automation Events - Activating, Selecting, Changing Data and Navigating Worksheets
8:48 Has File
ME to the Rescue - Making Life Easier
11:05 Has File
Run a Macro When a Specific Cell, Range, Row or Column Changes
10:10 Has File
Prevent Endless Loops with Error Handling in Events - The Better Way
6:06 Has File
Highlight the Selected Cell

Assignment 12 - Automation

1:51 Has File
Assignment Task - Automation
19:07 Has File
Assignment Answer - Automation

Advanced Macro Control & Custom Functions

13:33 Has File
Calling Other Macros - Passing Required, Optional, and Default Arguments, Values, and Arrays
15:19 Has File
Create Custom VBA Functions that Return Values to a Macro
5:55 Has File
ByRef vs ByVal - Learn How to Keep Your Data Safe
10:28 Has File
Add More Power with Advanced Arguments & Result Control
12:41 Has File
Create Custom Excel Worksheet Functions - User Defined Functions (UDF)
5:41 Has File
Public vs Private Procedures - How to Hide Your Macros
17:58 Has File
Enums - Manage Custom Lists and Macro Argument Inputs with Ease
16:42 Has File
Large Project Management, Documentation & When to Make New Procedures (Code Abstraction)

Assignment 13 - Advanced Macro Control

1:11 Has File
Assignment Task - Advanced Macro Control
8:35 Has File
Assignment Answer - Advanced Macro Control

Practical Tasks - Pivot Tables, Filtering & Sorting

1:03:02 Has File
PivotTables - What You Need to Know!
36:43 Has File
PivotTables - Filtering and Loops (Dates Included)
58:46 Has File
PivotTables - Slicers and Timelines (The Guide)
26:18 Has File
Filtering and Sorting - The How To Guide
17:04 Has File
Filtering and Sorting - Date Filters (Basic to Advanced - Rolling Dates & More)

Security in VBA & Excel

1:58 Has File
Password Protect Macros and VBA Projects
11:45 Has File
Protect a Worksheet - Advanced Options & Avoiding Errors
5:03 Has File
Making Admin Worksheets (With Password Protection)
9:10 Has File
Verify User Input or Undo It
6:50 Has File
Don't Let the User Leave a Worksheet Until They Complete a Task
8:25 Has File
Force the User to Enable Macros to use the Workbook

Assignment 14 - Security

1:51 Has File
Assignment Task - Security
11:09 Has File
Assignment Answer - Security

Practical Tasks - Import, Export & Email Ultimate Guide

15:42 Has File
Importing into Excel - The Easy Way
25:26 Has File
Advanced File Import - Super Fast for Smaller Files
10:29 Has File
Advanced File Import - Method Required for Large Files
12:33 Has File
Advanced File Import - Using the File System Object (FSO)
25:35 Has File
Data Import Analysis Guide
21:22 Has File
Building a Robust Data Import Parser (Filtering Before Import, Excluding Rows, & More)
22:07 Has File
Export to PDF & Managing Print Settings - Entire Workbook, Selected Worksheets or Specific Ranges
23:27 Has File
Export TXT, CSV & Worksheets (A Professional System that Ensures Data Integrity)
10:18 Has File
Export PivotTables (The Proper Way) + Unique File Generation Trick
25:48 Has File
Email from Excel (The Full Guide) - With Multiple Recipients, Attachments, HTML, Signatures, Email Error Handling & More

Project: Bringing It All Together - Data Import, Visualization, and Export

9:20 Has File
Introduction to the Project
00:58 Has File
Sample Import Files to Use for this Project
14:42 Has File
How to Manage Large Project Creation & Planning
38:50 Has File
Create Visual Interfaces for Better Programming
25:12 Has File
Advanced Code Structures for Larger Projects & Address Variable Usage
19:56 Has File
How to Build & Test Larger Macros with Ease
26:45 Has File
Robust Function Development & Real-World Debugging Examples
23:43 Has File
Building Helper Features for Your Project
26:27 Has File
Advanced Date Programming
19:18 Has File
Using Wrapper Functions to Make More Maintainable Code
32:56 Has File
Dynamic File Creation, Deletion & Cleaning Procedures
29:53 Has File
Create and Manage Custom Reports, Worksheet Configurations, and Exports
6:54 Has File
Protecting Against Bad User Inputs
22:50 Has File
Automatically Email Auto-Generated Custom Reports to Lists of People with the Click of a Button
18:36 Has File
Professional Integration of the Visual Interface with the Backend Programming
28:57 Has File
Error Handling System for Large Projects
26:48 Has File
Security - Building a Password Protection Control System & Protected Access Container
11:41 Has File
Adding Professional Documentation - The 4 Pillars of Documenting Your Code
1:16 Has File
Congratulations Rockstar!

(Bonus) UserForms - Build a Fully Featured Form for Easy Data Entry

22:43 Has File
Your First UserForm
25:41 Has File
More UserForm Controls & Require/Validate Form Input
40:06 Has File
Advanced ComboBox and ListBox Usage - Multiple Selections & Columns & Dependent Menus
16:56 Has File
Multiple Tabs, Scrollable Forms, & Paragraph Style Inputs
22:10 Has File
Usability Tips for Professional UserForms - Control Protection, Default Values and More
11:11 Has File
ActiveX & Form Controls in the Worksheet

Course Sale Ends...

Master Excel VBA Today!

Price: $495 $195

Price: $495

80% Discount!

Discount Ends Soon!

Master Excel Today! (Before the Sale Ends)

Sale Ends in:

00
Hours
00
Minutes
00
Seconds