Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



  • VLOOKUP() Function in Excel  
  • Make Your Macros Available in All Workbooks in Excel  
  • Combine Values from Multiple Cells into One Cell in Excel  
  • How to Quickly Find Data Anywhere in Excel  
  • Find the Next Blank Row with VBA Macros in Excel  
  • Ignore Blanks in a Data Validation List in Excel  
  • Prevent Spaces from Being Entered in Cells in Excel  
  • Run a Macro When you Click a Button in Excel  
  • Calculate Someone's Age in Excel  
  • Delete Duplicate Values in All Versions of Excel  
  • Logical Comparison Operators in Excel - How to Compare Things  
  • Open PDF from Excel  
  • NOT Function - Change False to True and True to False in Excel  
  • Highlight, Sort, and Group the Top and Bottom Performers in a List in Excel  
  • Pass Values from One Macro to Another Macro  
  • Get the Decimal Part of a Number in Excel  
  • Convert Scientific Notation to Numbers in Excel  
  • Send Emails through Outlook using Email Addresses from Excel and text from Word  
  • Email Current Workbook & or Other Attachments  
  • Get the Last Row using VBA in Excel  
  • Apply Conditional Formatting to Multiple Cells with a Single Formula  
  • Email List of People from Excel Using a Macro  
  • Count the Visible Rows in a Filtered List in Excel  
  • Vlookup to Return the Min, Max, or Average Value in Excel  
  • 6 Tips to Quickly Clean Data in Excel  
  • 5 Bite-Size Vlookup Tricks for Excel  
  • 4 Easy Ways in Excel to Convert Numbers Stored as Text to Numbers - Workbook Included  
  • Count Occurrences of Unique Values in a List in Excel  
  • 6 Tricks to Make Dates Work in Excel  
  • Easy Excel Web Import  
  • Force a User to Enable Macros in Excel - Advanced Version  
  • How to Use INDEX MATCH Lookups in Excel - Step-by-Step Guide  
  • Send Emails from Excel - Automatically and by Hand  
  • The Power of TRUE FALSE in Excel  
  • Variable Default Values - How to Check for Them and Reset Them  
  • Determine Variable Type - Enables Better Coding  
  • Sheets vs. Worksheets - What You Need to Know  
  • How to Name Variables - Helpful Tips and Common Pitfalls  
  • Helpful Shortcuts for Working with Variables  
  • Message Boxes with Buttons, Formatting, and Style  
  • Message Box Button Clicks - Making Decisions from Message Boxes  
  • How to Use Dates in Excel  
  • Get, Input, Clear, and Move Values Around a Worksheet  
  • Activate vs. Select - The Important Difference  
  • Excel 365 Wildcard Vlookup to Return All Partial Matches  
  • SORTBY() - New Excel 365 Function to Sort Data  
  • FILTER() Function Excel - Power Lookup for the Future  
  • Force the User to Enable Macros to use the Workbook  
  • Verify User Input or Undo It  
  • Don't Let the User Leave a Worksheet Until They Complete a Task  
  • SEQUENCE() Function - Excel 365 New Function for List Making  
  • UNIQUE() Function - Excel 365 Function for Removing Duplicates  
  • Excel Formula Formatting Trick to Make Life Easier  
  • Easily Tab/Enter Through Input Forms in Excel - Faster/Better Forms in Excel  
  • Show the Current Date Every Day in Excel (or Time)  
  • CLEAN() Function Excel  
  • Remove Hidden Spaces from Excel - Including Char(160)  
  • Better Edit Excel Formulas in the Conditional Formatting Window or Name Manager  
  • What are Variables and How to Use Them  
  • Option Explicit - Forced Declarations - When, How, and Why to Use It  
  • Variable Types - A Guide  
  • Declaring Variables - Rules, Tips, and Shortcuts  
  • Variable Scope - Project Variables, Module Variables, and Procedure Variables  
  • Precedence - Controlling Variables with the Same Name  
  • Constants - Hardcoding for Strength  
  • Static - Keep My Variables Alive  
  • Confirm User Input using VBA and Macros in Excel  
  • Excel VBA to Select Data from Other Worksheets - VBA Quickie 1  
  • Automatically Updating Dependent Drop Down List Menus in Excel  
  • InputBox - Simple User Input  
  • Formula Input  
  • Date Input  
  • Select a Cell or Range from a Prompt  
  • Get Multiple Inputs from the User  
  • Reference Workbooks  
  • Reference the Current Workbook  
  • Create a New Workbook - 3 Ways  
  • Open Workbooks - Including Password Protected and Read Only  
  • Get Input - The Better Way - Part 1 - Introduction  
  • Get Input - The Better Way - Part 2 - More Features and Caveats  
  • Save Workbooks - 4 Ways  
  • Close Workbooks - Including All of Excel and With and Without Saving  
  • Delete a Workbook  
  • Work on New, Opened, and Other Workbooks - The Proper Way!  
  • Check if a Workbook Exists and is Open - Prevent Errors  
  • What are Loops and How are they Useful?  
  • Do Loops - Do While, Do Until, & Infinite  
  • For Next Loop  
  • For Each Loop  
  • While Wend Loop  
  • Nesting Loops - Controlling Loops within Loops  
  • Stop Loops Early - User Controlled, Automatic, and Nested  
  • Advanced Loop Condition Checks  
  • Loop through Cells, Worksheets, and Workbooks using Collections - The Proper Way  
  • Breaking Apart Macros for Debugging  
  • Analyzing Variables with the Locals and Watch Windows  
  • Quick and Powerful Checks with the Immediate Window  
  • Option Explicit and Compile VBA Project  
  • Stop a Long-Running or Frozen Macro  
  • Error Handling  
  • Make Better Decisions with Errors  
  • Elegant Custom Errors and Messages  
  • Object Variables - Part 1 - Ranges, Worksheets, and Workbooks  
  • Object Variables - Part 2 - Set to Nothing or Not  
  • Excel Formula to Remove ALL Special Characters  
  • Make Rounded Corner Cells in Excel  
  • Elegant Date and Location Filtering in Excel - A Must See!  
  • Excel ToolTips on Mouse Hover for Buttons and Shapes  
  • Excel Prank - Zooming into Craziness - For Fun :)  
  • Worksheet Nav with Buttons (No VBA)  
  • Custom Cool Buttons in Excel - With Animations!  
  • Hide or Toggle Worksheet Sections without VBA in Excel  
  • Generate a Unique List of Random Numbers With a Simple Formula  
  • Easy Colors in VBA - Store and Use Them  
  • 5 Powerful Techniques for Building Advanced Formulas  
  • Easy Date Conversion with VBA  
  • Worksheet Functions for VBA - VLOOKUP() and More  
  • TEXTJOIN with Different Delimiters at Once in Excel  
  • Automated Text Import in Excel with File Selection - The Easy Way - VBA  
  • Formula Auto-Increment After So Many Rows  
  • Slicer Power Analysis in Excel - Pivot Tables + Pivot Charts + Tables + Slicers  
  • Text to Number Format Formula in Excel  
  • 3 Tips for Faster and Better VBA Macros in Excel - Simple to Advanced  
  • Excel Macro Timer - Easy to Use  
  • Require a Password to View Hidden Worksheets in Excel - VBA Tutorial  
  • Excel Tips - Quickly Fill Formulas and Text Series in a Few Seconds  
  • Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface  
  • Hide Macros (VBA) from the User in Excel  
  • Excel Import Web Data Copy/Paste + Easy Analysis  
  • Pivot Chart Formatting Copy Trick in Excel - Excel Quickie  
  • 3 Slicer Tricks for Pivot Tables in Excel  
  • Save Hours with the Selection Pane in Excel  
  • 5 Tips for Passing Values to Macros (VBA) - Beginner to Advanced  
  • Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Status Bar, and More  
  • SWITCH() Function in Excel and 3 Alternatives  
  • Toggle Visible Items in Excel Using a Button  
  • Remove Deleted Items from Slicers & Pivot Tables  
  • Send Email from Excel - The Basics + Short Syntax for Better Copy/Pasting  
  • Send Emails to Multiple Recipients at Once - Includes a Dynamic Method for Getting the Recipients from a List in the Worksheet  
  • Email a List of People - Custom Emails for Everyone in the List  
  • Send Emails with a Signature from Outlook  
  • Send an HTML Email - Including How to Manage It and Easily Import It into the Macro  
  • Send Emails with Attachments (Single and Multiple)  
  • Email the Current Workbook (And Email Split Syntax Introduction)  
  • Email Worksheets (One or Many)  
  • Email the Entire Workbook as a PDF Attachment  
  • Email a Worksheet as a PDF Attachment (And Solve Common Issues with the Process)  
  • Email Multiple Worksheets as a PDF Attachment  
  • Automatically Send Emails When a Cell Reaches a Certain Value  
  • Handle Common Errors with Sending Emails  
  • Send Emails Faster  
  • Introduction to the Course  
  • ARRAYTOTEXT() Function Excel - 5 Practical Examples  
  • Compare Values in Excel - Beginner to Advanced  
  • Generate Random Dates in Excel  
  • List Slicer Selections in a Cell in Excel  
  • Send Emails from Excel - Automatically and by Hand  
  • Stop Tables from Auto-Filling Formulas Down in Excel  
  • Dynamic Data Templates in Excel 365  
  • FILTER in Excel - Limit, Sort, & Rank  
  • Add Check Marks to Cells by Double-Clicking or Typing  
  • Custom Data Views Controlled by a Drop Down Menu in Excel  
  • ROMAN() & ARABIC() Function in Excel  
  • Explode Cells in Excel  
  • 4 Tips to Camouflage Slicers in Excel  
  • Reuse Pivot Table Filters in Row, Column, & Value Fields  
  • Get the Numeric Value of any Constant in VBA  
  • The Magically Appearing Cell in Excel  
  • Simple Checkbox Control in Excel  
  • Vlookup Date Picker in Excel (Dynamic)  
  • Easier Table References in Excel  
  • Easy Way to Reference Macros from Other Modules in Excel  
  • Use Pivot Tables and Slicers on Protected Worksheets  
  • Make Dates from Drop Down Lists in Excel  
  • Option Buttons with Formulas in Excel  
  • Make Quick Lists for Drop Down Menus - Save A LOT of Time  
  • How to use the CONVERT Function in Excel  
  • Custom Buttons to Hide & Show Worksheets in Excel  
  • Data Validation List with Dynamic Arrays in Excel  
  • Reset a Worksheet with a Button Click  
  • Hide Formulas in Excel  
  • 30 Second VLOOKUP() in Excel  
  • Make a Password Prompt Input for Excel (With Masked Input)  
  • Count Cells that Contain Specific Text in Excel  
  • Automatically Updating Range References in VBA  
  • Your First UserForm  
  • More UserForm Controls & Require/Validate Form Input  
  • Advanced ComboBox and ListBox Usage - Multiple Selections & Columns & Dependent Menus  
  • Multiple Tabs, Scrollable Forms, & Paragraph Style Inputs  
  • Usability Tips for Professional UserForms - Control Protection, Default Values and More  
  • ActiveX & Form Controls in the Worksheet  
  • Introduction to the Project  
  • Sample Import Files to Use for this Project  
  • How to Manage Large Project Creation & Planning  
  • Create Visual Interfaces for Better Programming  
  • Advanced Code Structures for Larger Projects & Address Variable Usage  
  • How to Build & Test Larger Macros with Ease  
  • Robust Function Development & Real-World Debugging Examples  
  • Building Helper Features for Your Project  
  • Advanced Date Programming  
  • Using Wrapper Functions to Make More Maintainable Code  
  • Dynamic File Creation, Deletion & Cleaning Procedures  
  • Create and Manage Custom Reports, Worksheet Configurations, and Exports  
  • Protecting Against Bad User Inputs  
  • Automatically Email Auto-Generated Custom Reports to Lists of People with the Click of a Button  
  • Professional Integration of the Visual Interface with the Backend Programming  
  • Error Handling System for Large Projects  
  • Security - Building a Password Protection Control System & Protected Access Container  
  • Adding Professional Documentation - The 4 Pillars of Documenting Your Code  
  • Congratulations Rockstar!  
  • Introduction to the Project  
  • Planning the Project's Coding and Visuals (A Design Framework)  
  • Visuals Creation - Professional Tables, Rounded Corners, Stylish Buttons  
  • The First Code - How to Build More Complex Macros and Code Structures  
  • How to Save Time by Reusing Code Safely  
  • User-Friendly Support Functions - Viewing, Refreshing, Clearing Values and More  
  • Adding Dynamic Buttons to Entries in a Table to Manage Them - Edit and Delete  
  • Protecting Everything using VBA  
  • The Completed Project  
  • Validate Data & User Input with VBA  
  • Using Worksheet Functions in Macros (Simple & Advanced)  
  • Calling Other Macros and Passing Values - An Introduction  
  • Tables - The Simple Way  
  • Tables - Advanced Guide (Everything You Need to Know)  
  • Search for Values in Excel - Single Match or All Matches  
  • Advanced Searching for Values - Entire Workbook Search, Wildcards, Formatting Search and Last Row Search  
  • Special Cell Magic - Finding/Deleting Empty Rows, Working with Filtered Data & More  
  • Shapes - The Basic Guide  
  • Shapes - Advanced Techniques & Working with Multiple Shapes  
  • Shapes - Looping and Legacy Form Controls  
  • Importing into Excel - The Easy Way  
  • Advanced File Import - Super Fast for Smaller Files  
  • Advanced File Import - Method Required for Large Files  
  • Advanced File Import - Using the File System Object (FSO)  
  • Data Import Analysis Guide  
  • Building a Robust Data Import Parser (Filtering Before Import, Excluding Rows, & More)  
  • Calling Other Macros - Passing Required, Optional, and Default Arguments, Values, and Arrays  
  • Create Custom VBA Functions that Return Values to a Macro  
  • ByRef vs ByVal - Learn How to Keep Your Data Safe  
  • Add More Power with Advanced Arguments & Result Control  
  • Create Custom Excel Worksheet Functions - User Defined Functions (UDF)  
  • Public vs Private Procedures - How to Hide Your Macros  
  • Enums - Manage Custom Lists and Macro Argument Inputs with Ease  
  • Large Project Management, Documentation & When to Make New Procedures (Code Abstraction)  
  • PivotTables - What You Need to Know!  
  • PivotTables - Filtering and Loops (Dates Included)  
  • PivotTables - Slicers and Timelines (The Guide)  
  • Filtering and Sorting - The How To Guide  
  • Filtering and Sorting - Date Filters (Basic to Advanced - Rolling Dates & More)  
  • Learn New Commands on Your Own & Do Something Useful with Ranges (Macro Recorder + Object Browser)  
  • Practical Use of Better Range References and Number Formatting (On Imported Data)  
  • Powerful Range Methods You Must Know - Union, Resize, CurrentRegion and Intersect  
  • Find the Next Empty or Last Row/Column (The Complete Guide)  
  • The Proper Way to Work with Ranges (Advanced)  
  • Simple System for Using a Default Input Value and Validating It  
  • Force the User to Input Something - 2 Ways  
  • Require Single Cell Selection - And How to Structure More Advanced Code  
  • Zero and "False" Inputs - Avoiding Common Errors  
  • Let the User Choose Which Files to Work With - Including Filtered Selections  
  • Multiple File Selection - How to Allow it and Work with The Files  
  • Let the User Choose Where to Save Files and Under What Name and Type  
  • The Proper Way to Work with Worksheets  
  • Cross-Worksheet (and Workbook) Range Reference Concept - Very Important  
  • The Running Turkey in Excel - Happy Thanksgiving :)  
  • Turkey Takeover in Excel - Turkeys Everywhere Edition  
  • Export to PDF & Managing Print Settings - Entire Workbook, Selected Worksheets or Specific Ranges  
  • Export TXT, CSV & Worksheets (A Professional System that Ensures Data Integrity)  
  • Export PivotTables (The Proper Way) + Unique File Generation Trick  
  • Email from Excel (The Full Guide) - With Multiple Recipients, Attachments, HTML, Signatures, Email Error Handling & More  
  • Password Protect Macros and VBA Projects  
  • Protect a Worksheet - Advanced Options & Avoiding Errors  
  • Making Admin Worksheets (With Password Protection)  
  • Next Empty Row Trick in Excel VBA & Macros  
  • Dynamic Excel Formulas Made Easy - 2 Methods  
  • Assignment Task - Ranges & Assignment Section Explanation  
  • Assignment Answer - Ranges  
  • Assignment Task - Get & Input Data  
  • Assignment Answer - Get & Input Data  
  • Assignment Task - Worksheets  
  • Assignment Answer - Worksheets  
  • Assignment Task - Logic & Control  
  • Assignment Answer - Logic & Control  
  • Assignment Task - Variables Introduction  
  • Assignment Answer - Variables Introduction  
  • Assignment Task - Popup Windows & Input  
  • Assignment Answer - Popup Windows & Input  
  • Assignment Task - Workbooks  
  • Assignment Answer - Workbooks  
  • Assignment Task - Loops  
  • Assignment Answer - Loops  
  • Assignment Task - Variables  
  • Assignment Answer - Variables  
  • Assignment Task - Arrays  
  • Assignment Answer - Arrays  
  • Assignment Task - Error Handling  
  • Assignment Task - Automation  
  • Assignment Answer - Error Handling  
  • Assignment Answer - Automation  
  • Assignment Task - Advanced Macro Control  
  • Assignment Answer - Advanced Macro Control  
  • Assignment Task - Security  
  • Assignment Answer - Security  
  • How to Use the Course  
  • Your First Macro! (The VBA/Macro Intro.)  
  • Quick Tip to Better Understand VBA Code  
  • The Visual Basic Editor Interface (VBE)  
  • The Basics of How VBA Works (Objects & The Object Browser)  
  • The Macro Recorder (Good & Evil)  
  • Excel VBA Course Preview  
  • VBA Login System for Excel  
  • Cell Change Tracker Video  
  • VBA Login System Files  
  • Cell Change Tracker Files  
  • One-Click Workbook Reset Video  
  • One-Click Workbook Reset Files  
  • Better Worksheet References Video  
  • Better Worksheet References Files  
  • Professional Interface Video  
  • Professional Interface Files  
  • Fast Export Worksheets Video  
  • Fast Export Worksheets Files  
  • Auto-Workbook Directory Video  
  • Auto-Workbook Directory Files  
  • Auto-Delete Excel Files Video  
  • Auto-Delete Excel Files (Files)  
  • Auto-Close Excel Workbook Video  
  • Auto-Close Excel Workbook File  
  • Loop Through a Folder Using VBA/Macros Video  
  • Loop Through a Folder Using VBA/Macros File  
  • Introduction to the Tutorial  
  • Video Tutorial and Downloadable File  
  • Add Check Boxes for a More User Friendly Excel Worksheet  
  • Dark Mode for Excel (Including Worksheets) - NO VBA Required  
  • Organize Data in Excel with Custom Lists  
  • Quickly Reset All Form Controls in a Worksheet in Excel  
  • Easy Cell Change Tracker in Excel  
  • Make Perfect Scrollable Boxes in Worksheets in Excel - Great for a Dashboard  
  • 4 Powerful Dynamic Chart Designs in Excel  
  • 5 Simple Tips for Making BETTER Macros in Excel!  
  • Custom Password Template to Auto-Hide Data in Worksheets  
  • Kill Command in Excel (Delete Files Using VBA)  
  • Data Visualization and Summary Trick for Excel - Outlining Data  
  • Easy Pivot Table in Excel (Auto-Subtotals Feature)