Excel Dashboard & VBA Course - Beginner to Expert
Instant Access! - Lifetime Access!
- NO VBA Experience Required!
- 200+ Online Videos
- 200+ Downloadable Excel Resource Files
- Practical Project-Based Learning
- 14 VBA Core Sections
- 14 Practical Assignments
- 40+ Excel VBA Feature Tutorials
- 3 Real World Projects
- Instructor with 10+ Years of Excel VBA Teaching
Original Price $495 >>> Now $189 (usd)
Sale ENDS SOON
(60% Discount)
Price: $189 (usd)
A preview of what's in this course, who it's for, and how it can help you succeed in Excel and VBA
Introduction
First Steps
2:55
How to Use the Course
27:27
Your First Macro! (The VBA/Macro Intro.)
1:58
Quick Tip to Better Understand VBA Code
15:45
The Visual Basic Editor Interface (VBE)
17:24
The Basics of How VBA Works (Objects & The Object Browser)
6:14
The Macro Recorder (Good & Evil)
Working with Cells and Ranges
12:25
Reference Cells and Ranges
10:56
Advanced Range Selection
4:49
Never Select Cells Again
12:14
Learn New Commands on Your Own & Do Something Useful with Ranges (Macro Recorder + Object Browser)
8:45
Reference Rows and Columns
9:27
Practical Use of Better Range References and Number Formatting (On Imported Data)
5:11
Activate vs. Select - The Important Difference
7:00
User Selected Cells and Ranges
9:17
Offset Ranges
28:14
Powerful Range Methods You Must Know - Union, Resize, CurrentRegion and Intersect
Assignment 1 - Ranges
4:43
Assignment Task - Ranges & Assignment Section Explanation
10:50
Assignment Answer - Ranges
Practical Tasks - Ranges
14:29
Find the Next Empty or Last Row/Column (The Complete Guide)
9:11
Select Cells, Ranges, Rows and Columns within Other Ranges
5:05
The Proper Way to Work with Ranges (Advanced)
Get & Input Data into the Worksheet
16:29
Get, Input, Clear, and Move Values Around a Worksheet
7:12
Storing Data in the Macro
12:01
Copy and Paste Data
15:24
Working with Formulas
21:35
Insert/Delete Cells, Ranges, Rows & Columns
6:22
Additional Ways to Get/Input Data into the Worksheet
Assignment 2 - Get & Input Data
3:10
Assignment Task - Get & Input Data
18:30
Assignment Answer - Get & Input Data
Working with Worksheets
13:48
Reference Worksheets
5:13
Additional Method to Reference Worksheets
5:32
Navigate to and Select Worksheets
2:55
Work on the Currently Visible Worksheet
15:02
Reference Cells and Ranges on Other Worksheets
21:46
Adding and Removing Worksheets
8:32
Work on New Worksheets - Rename, Add Data, etc.
10:32
Move and Copy Worksheets
9:53
Common Worksheet Properties
4:27
The Proper Way to Work with Worksheets
10:09
Cross-Worksheet (and Workbook) Range Reference Concept - Very Important
Assignment 3 - Worksheets
3:50
Assignment Task - Worksheets
4:04
Assignment Answer - Worksheets
Add Logic and Control to Macros
22:09
IF Statement - The Foundation of Decision Making
20:30
IF Statement Advanced
19:20
Select Case Statement - Make More Readable Decisions
13:10
With Statement - Easier Code Writing
22:33
GoTo Statement - The correct way to use this!
9:44
Simplify Complex IF Statements
9:48
Case Insensitive Checks - Control How VBA Compares Text
17:00
Arithmetic Operators - Let's Do Math!
9:45
Comparison Operators
6:02
Logical Operators - Allow Multiple Conditional Checks
16:31
Operator Precedence - Control What Occurs When
Assignment 4 - Logic & Control
4:01
Assignment Task - Logic & Control
24:18
Assignment Answer - Logic & Control
Variables Introduction
14:12
What are Variables and How to Use Them
6:36
Option Explicit - Forced Declarations - When, How, and Why to Use It
8:12
How to Name Variables - Helpful Tips and Common Pitfalls
26:58
Variable Types - A Guide
7:55
Declaring Variables - Rules, Tips, and Shortcuts
18:56
Object Variables - Part 1 - Ranges, Worksheets, and Workbooks
10:19
Object Variables - Part 2 - Set to Nothing or Not
6:57
Helpful Shortcuts for Working with Variables
Assignment 5 - Variables Introduction
1:19
Assignment Task - Variables Introduction
18:20
Assignment Answer - Variables Introduction
Popup Windows & User Input
31:10
Message Boxes with Buttons, Formatting, and Style
12:10
Message Box Button Clicks - Making Decisions from Message Boxes
23:25
InputBox - Simple User Input
16:49
Get Input - The Better Way - Part 1 - Introduction
16:03
Get Input - The Better Way - Part 2 - More Features and Caveats
11:11
Formula Input
7:35
Date Input
12:42
Select a Cell or Range from a Prompt
11:47
Get Multiple Inputs from the User
Assignment 6 - Popup Windows & Input
1:30
Assignment Task - Popup Windows & Input
6:30
Assignment Answer - Popup Windows & Input
Practical Tasks - Searching, Worksheet Functions & More
15:34
Validate Data & User Input with VBA
26:10
Search for Values in Excel - Single Match or All Matches
15:57
Advanced Searching for Values - Entire Workbook Search, Wildcards, Formatting Search and Last Row Search
18:43
Using Worksheet Functions in Macros (Simple & Advanced)
21:17
Special Cell Magic - Finding/Deleting Empty Rows, Working with Filtered Data & More
12:23
Calling Other Macros and Passing Values - An Introduction
Working with Workbooks
9:49
Reference Workbooks
4:05
Reference the Current Workbook
8:55
Create a New Workbook - 3 Ways
15:10
Open Workbooks - Including Password Protected and Read Only
14:58
Save Workbooks - 4 Ways
12:59
Close Workbooks - Including All of Excel and With and Without Saving
21:09
Delete a Workbook
22:23
Work on New, Opened, and Other Workbooks - The Proper Way!
11:53
Check if a Workbook Exists and is Open - Prevent Errors
Assignment 7 - Workbooks
1:45
Assignment Task - Workbooks
5:36
Assignment Answer - Workbooks
Loops
5:52
What are Loops and How are they Useful?
19:30
Do Loops - Do While, Do Until, & Infinite
14:43
For Next Loop
16:01
For Each Loop
3:19
While Wend Loop
7:51
Nesting Loops - Controlling Loops within Loops
22:06
Stop Loops Early - User Controlled, Automatic, and Nested
7:42
Advanced Loop Condition Checks
12:42
Loop through Cells, Worksheets, and Workbooks using Collections - The Proper Way
Assignment 8 - Loops
1:32
Assignment Task - Loops
14:12
Assignment Answer - Loops
Practical Tasks - Tables & Shapes (The Ultimate Guide)
3:34
Tables - The Simple Way
52:33
Tables - Advanced Guide (Everything You Need to Know)
34:16
Shapes - The Basic Guide
29:17
Shapes - Advanced Techniques & Working with Multiple Shapes
15:26
Shapes - Looping and Legacy Form Controls
Project: The Task Manager
3:23
Introduction to the Project
10:24
Planning the Project's Coding and Visuals (A Design Framework)
17:56
Visuals Creation - Professional Tables, Rounded Corners, Stylish Buttons
41:06
The First Code - How to Build More Complex Macros and Code Structures
21:13
How to Save Time by Reusing Code Safely
27:36
User-Friendly Support Functions - Viewing, Refreshing, Clearing Values and More
24:40
Adding Dynamic Buttons to Entries in a Table to Manage Them - Edit and Delete
7:36
Protecting Everything using VBA
2:28
The Completed Project
Practical Tasks - User Input Applications & File Selections
4:38
Simple System for Using a Default Input Value and Validating It
8:25
Force the User to Input Something - 2 Ways
10:27
Require Single Cell Selection - And How to Structure More Advanced Code
5:55
Zero and "False" Inputs - Avoiding Common Errors
18:00
Let the User Choose Which Files to Work With - Including Filtered Selections
9:15
Multiple File Selection - How to Allow it and Work with The Files
9:17
Let the User Choose Where to Save Files and Under What Name and Type
Variables - Unlocking Their Power
22:18
Variable Scope - Project Variables, Module Variables, and Procedure Variables
11:29
Precedence - Controlling Variables with the Same Name
20:41
Constants - Hardcoding for Strength
8:27
Static - Keep My Variables Alive
10:09
Variable Default Values - How to Check for Them and Reset Them
15:41
Determine Variable Type - Enables Better Coding
13:09
Sheets vs. Worksheets - What You Need to Know
Assignment 9 - Variables
1:41
Assignment Task - Variables
8:19
Assignment Answer - Variables
Practical Tasks - Debugging Your Macros & VBA
21:03
Breaking Apart Macros for Debugging
18:47
Analyzing Variables with the Locals and Watch Windows
13:38
Quick and Powerful Checks with the Immediate Window
2:58
Option Explicit and Compile VBA Project
2:42
Stop a Long-Running or Frozen Macro
Arrays in VBA - The Power Variable
7:19
What is an Array in VBA and How to Make Your First Array
12:55
Static Arrays - You Decide the Size
19:03
Dynamic Arrays Part 1 - Increased Flexibility
10:50
Dynamic Arrays Part 2 - Dynamic Resizing
13:58
Multi-Dimensional Arrays - First Step to Working with Ranges in Arrays
15:02
Arrays & Ranges Part 1 - Super Fast Range Evaluation
11:55
Arrays & Ranges Part 2 - Dynamic Ranges & Single Cell Selection
5:57
Easy Array Looping - Look but Don't Touch
20:07
Helpful Array Features - Clearing, Checking, Splitting, Joining and Option Base
Assignment 10 - Arrays
1:00
Assignment Task - Arrays
6:10
Assignment Answer - Arrays
Error Handling
21:48
Error Handling
9:27
Make Better Decisions with Errors
11:25
Elegant Custom Errors and Messages
Assignment 11 - Error Handling
2:45
Assignment Task - Error Handling
8:51
Assignment Answer - Error Handling
Automating Macros
13:25
How to Make Macros Run Automatically
22:07
Workbook Automation Events - Opening, Closing, Saving and Navigating Worksheets
23:21
Worksheet Automation Events - Activating, Selecting, Changing Data and Navigating Worksheets
8:48
ME to the Rescue - Making Life Easier
11:05
Run a Macro When a Specific Cell, Range, Row or Column Changes
10:10
Prevent Endless Loops with Error Handling in Events - The Better Way
6:06
Highlight the Selected Cell
Assignment 12 - Automation
1:51
Assignment Task - Automation
19:07
Assignment Answer - Automation
Advanced Macro Control & Custom Functions
13:33
Calling Other Macros - Passing Required, Optional, and Default Arguments, Values, and Arrays
15:19
Create Custom VBA Functions that Return Values to a Macro
5:55
ByRef vs ByVal - Learn How to Keep Your Data Safe
10:28
Add More Power with Advanced Arguments & Result Control
12:41
Create Custom Excel Worksheet Functions - User Defined Functions (UDF)
5:41
Public vs Private Procedures - How to Hide Your Macros
17:58
Enums - Manage Custom Lists and Macro Argument Inputs with Ease
16:42
Large Project Management, Documentation & When to Make New Procedures (Code Abstraction)
Assignment 13 - Advanced Macro Control
1:11
Assignment Task - Advanced Macro Control
8:35
Assignment Answer - Advanced Macro Control
Practical Tasks - Pivot Tables, Filtering & Sorting
1:03:02
PivotTables - What You Need to Know!
36:43
PivotTables - Filtering and Loops (Dates Included)
58:46
PivotTables - Slicers and Timelines (The Guide)
26:18
Filtering and Sorting - The How To Guide
17:04
Filtering and Sorting - Date Filters (Basic to Advanced - Rolling Dates & More)
Security in VBA & Excel
1:58
Password Protect Macros and VBA Projects
11:45
Protect a Worksheet - Advanced Options & Avoiding Errors
5:03
Making Admin Worksheets (With Password Protection)
9:10
Verify User Input or Undo It
6:50
Don't Let the User Leave a Worksheet Until They Complete a Task
8:25
Force the User to Enable Macros to use the Workbook
Assignment 14 - Security
1:51
Assignment Task - Security
11:09
Assignment Answer - Security
Practical Tasks - Import, Export & Email Ultimate Guide
15:42
Importing into Excel - The Easy Way
25:26
Advanced File Import - Super Fast for Smaller Files
10:29
Advanced File Import - Method Required for Large Files
12:33
Advanced File Import - Using the File System Object (FSO)
25:35
Data Import Analysis Guide
21:22
Building a Robust Data Import Parser (Filtering Before Import, Excluding Rows, & More)
22:07
Export to PDF & Managing Print Settings - Entire Workbook, Selected Worksheets or Specific Ranges
23:27
Export TXT, CSV & Worksheets (A Professional System that Ensures Data Integrity)
10:18
Export PivotTables (The Proper Way) + Unique File Generation Trick
25:48
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
Introduction to the Project
00:58
Sample Import Files to Use for this Project
14:42
How to Manage Large Project Creation & Planning
38:50
Create Visual Interfaces for Better Programming
25:12
Advanced Code Structures for Larger Projects & Address Variable Usage
19:56
How to Build & Test Larger Macros with Ease
26:45
Robust Function Development & Real-World Debugging Examples
23:43
Building Helper Features for Your Project
26:27
Advanced Date Programming
19:18
Using Wrapper Functions to Make More Maintainable Code
32:56
Dynamic File Creation, Deletion & Cleaning Procedures
29:53
Create and Manage Custom Reports, Worksheet Configurations, and Exports
6:54
Protecting Against Bad User Inputs
22:50
Automatically Email Auto-Generated Custom Reports to Lists of People with the Click of a Button
18:36
Professional Integration of the Visual Interface with the Backend Programming
28:57
Error Handling System for Large Projects
26:48
Security - Building a Password Protection Control System & Protected Access Container
11:41
Adding Professional Documentation - The 4 Pillars of Documenting Your Code
1:16
Congratulations Rockstar!
(Bonus) UserForms - Build a Fully Featured Form for Easy Data Entry
22:43
Your First UserForm
25:41
More UserForm Controls & Require/Validate Form Input
40:06
Advanced ComboBox and ListBox Usage - Multiple Selections & Columns & Dependent Menus
16:56
Multiple Tabs, Scrollable Forms, & Paragraph Style Inputs
22:10
Usability Tips for Professional UserForms - Control Protection, Default Values and More
11:11
ActiveX & Form Controls in the Worksheet