Excel VBA Mastery - 10-HOUR Programming from Beginner to Pro
Created by Team Mammoth
01
Skill level
All levels
02
Sections
20
03
Lectures
145
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
20
Sections
✓
145
Lectures
✓
143
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ Welcome! 2 lectures
Submit a Question / Feedback
Locked
AI Edge, a Mammoth Club Daily Briefing
Locked
+ Course Introduction 3 lectures
01.00 Course Overview
Locked
01.01 How To Save Macros
Locked
Source Files
Locked
+ Send Messages with MsgBox 6 lectures
02.00 Topics Overview
Locked
02.01 Build A Simple Message
Locked
02.02 Build An Advanced Message
Locked
02.03 Empty A Sheet With The Msgbox Function
Locked
02.04 Prompt User For Input
Locked
Source Files
Locked
+ Workbook and Worksheet Object 10 lectures
03.00 Topics Overview
Locked
03.01 Object Hierarchy
Locked
03.02 Change Multiple Worksheets
Locked
03.03 Add And Count Worksheets
Locked
03.04 Get Path Of A Workbook
Locked
03.05 Open And Close Workbooks
Locked
03.06 Loop Through Worksheets And Workbooks
Locked
03.07 Build A Sales Calculator
Locked
03.08 Change Charts
Locked
Source Files
Locked
+ Work with the Range Object 10 lectures
04.00 Topics Overview
Locked
04.01 Program A Range Of A Spreadsheet
Locked
04.02 Use Cells Instead Of A Range
Locked
04.03 Use A Range Variable
Locked
04.04 Select A Range
Locked
04.05 Access A Row
Locked
04.06 Copy And Paste A Range
Locked
04.07 Clear A Range
Locked
04.08 Count A Range
Locked
Source Files
Locked
+ Work with Range Properties 8 lectures
05.00 Topics Overview
Locked
05.01 Find The Current Region Of A Cell
Locked
05.02 Dynamic Range Program
Locked
05.03 Resize A Range
Locked
05.04 Select Entire Rows And Columns
Locked
05.05 Offset Property
Locked
05.06 End Property
Locked
Source Files
Locked
+ More Range Projects 10 lectures
06.00 Topics Overview
Locked
06.01 Union And Intersect Of Ranges
Locked
06.02 Detect Content
Locked
06.03 Build A Range Program
Locked
06.04 Change Text Color
Locked
06.05 Bold A Range
Locked
06.06 Change Cell Color
Locked
06.07 Work With Areas
Locked
06.08 Find Differences In Ranges
Locked
Source Files
Locked
+ Variables 7 lectures
07.00 Topics Overview
Locked
07.01 Integer Data Type
Locked
07.02 String Data Type
Locked
07.03 Double Data Type
Locked
07.04 Boolean Data Type
Locked
07.05 Retain Variable Value
Locked
Source Files
Locked
+ Work with Conditionals 4 lectures
08.00 Topics Overview
Locked
08.01 If Then Statement
Locked
08.02 Else Statement
Locked
Source Files
Locked
+ Work with AND, OR and NOT 5 lectures
09.00 Topics Overview
Locked
09.01 Greeting Program - Logical Operator AND
Locked
09.02 Logical Operator OR
Locked
09.03 Logical Operator Not
Locked
Source Files
Locked
+ Build Conditionals Projects 9 lectures
10.00 Topics Overview
Locked
10.01 Select Case
Locked
10.02 Build A Commission Calculator Project
Locked
10.03 Find Remainder With Mod
Locked
10.04 Check Number Program
Locked
10.05 K Smallest Value Program
Locked
10.06 Group By Font Style
Locked
10.07 Remove Empty Cells
Locked
Source Files
Locked
+ Introduction to Loops 7 lectures
11.00 Topics Overview
Locked
11.01 Single Loop
Locked
11.02 Double Loop
Locked
11.03 Triple Loop
Locked
11.04 Do While Loop
Locked
11.05 Build A Commission Table
Locked
Source Files
Locked
+ Loop Projects 10 lectures
12.00 Topics Overview
Locked
12.01 Loop Through Defined Range
Locked
12.02 Loop Through Entire Column
Locked
12.03 Do Until Loop
Locked
12.04 Use Step To Increment
Locked
12.05 Build A Pattern Project
Locked
12.06 How To Sort
Locked
12.07 Sort By Related Data
Locked
12.08 Delete Duplicate Values
Locked
Source Files
Locked
+ String Manipulation 11 lectures
13.00 Topics Overview
Locked
13.01 Join Strings
Locked
13.02 Extract Substrings From Left Or Right
Locked
13.03 Extract Substring At Middle
Locked
13.04 Get Length Of A String
Locked
13.05 Get Substring Position
Locked
13.06 How To Split Strings
Locked
13.07 Reverse Characters
Locked
13.08 Change String Casing
Locked
13.09 Count Words In A Range
Locked
Source Files
Locked
+ Build Custom Functions 5 lectures
14.00 Topics Overview
Locked
14.01 Make And Use Your Own Function
Locked
14.02 Pass Arguments To A Function
Locked
14.03 Custom Calculator Function
Locked
Source Files
Locked
+ Build Arrays 10 lectures
15.00 Topics Overview
Locked
15.01 One Dimensional Array
Locked
15.02 Two Dimensional Array
Locked
15.03 Change Array Size
Locked
15.04 Build An Array
Locked
15.05 Populate Row With Array
Locked
15.06 Array Length
Locked
15.07 Split String Into An Array
Locked
15.08 Join Array Into A String
Locked
Source Files
Locked
+ Work with Dates 8 lectures
16.00 Topics Overview
Locked
16.01 Delay A Procedure
Locked
16.02 Schedule A Procedure
Locked
16.03 Count Years
Locked
16.04 Count Days Between Dates
Locked
16.05 Count Weekdays Between Dates
Locked
16.06 Sort Dates
Locked
Source Files
Locked
+ Application Object 8 lectures
17.00 Topics Overview
Locked
17.01 How To Access Excel Functions
Locked
17.02 Disable Screen Updating
Locked
17.03 Disable Alerts
Locked
17.04 Show Progress Of Macro_1
Locked
17.05 Read Data From A File
Locked
17.06 Write Data To A File
Locked
Source Files
Locked
+ VBA Projects 7 lectures
18.00 Topics Overview
Locked
18.01 Build A Table
Locked
18.02 Build A Table Of Contents
Locked
18.03 Build A Table Of Contents 2
Locked
18.04 Combine Worksheets
Locked
18.05 Combine Worksheets By Column
Locked
Source Files
Locked
+ Programming Charts 5 lectures
19.00 Topics Overview
Locked
19.01 Program A Chart
Locked
19.02 Program An Embedded Chart
Locked
19.03 Delete Charts Programatically
Locked
Source Files
Locked
Description
About this course.
Unlock the full power of Excel with VBA programming.
This 10-HOUR course takes you from beginner to advanced, showing you how to write custom macros and automation tools that save time, reduce errors, and boost your productivity.
Here’s what you’ll do:
✅ Learn how to write VBA code that automates repetitive Excel tasks
✅ Learn how to create custom functions, forms, and interactive tools
✅ Learn how to control worksheets, ranges, and data dynamically
✅ Learn how to build user-friendly interfaces and dashboards
✅ Learn how to troubleshoot, debug, and structure efficient VBA projects
Whether you’re managing reports, building tools for your team, or just want to take Excel further—VBA gives you the power to make Excel work the way you need it to.
🎁 Includes lifetime access and downloadable project files for every lesson.
Take control of Excel. Automate everything. Build smarter.
Start coding with VBA today.
Instructors
Taught by people who ship.
Team Mammoth
Instructor
Produced by a team of Mammoth Club industry experts. Over 14 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.