Excel VBA Programming: Unleash Your Excel Expertise from Novice to Advanced
Created by Team Mammoth
·
143 lectures
01
Skill level
All levels
02
Sections
19
03
Lectures
143
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
19
Sections
✓
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.
+ Course Introduction 3 lectures Preview
01.00 Course Overview
Locked
02.00 How To Save Macros
Locked
Source Files
Locked
+ Send Messages with MsgBox 6 lectures
03.00 Topics Overview
Locked
03.01 Build A Simple Message
Locked
03.02 Build An Advanced Message
Locked
03.03 Empty A Sheet With The Msgbox Function
Locked
03.04 Prompt User For Input
Locked
03 Source Files
Locked
+ Workbook and Worksheet Object 10 lectures
04.00 Topics Overview
Locked
04.01 Object Hierarchymp4
Locked
04.02 Change Multiple Worksheets
Locked
04.03 Add And Count Worksheets
Locked
04.04 Get Path Of A Workbook
Locked
04.05 Open And Close Workbooks
Locked
04.06 Loop Through Worksheets And Workbooks
Locked
04.07 Build A Sales Calculator
Locked
04.08 Change Charts
Locked
04 Source Files
Locked
+ Work with the Range Object 10 lectures
05.00 Topics Overview
Locked
05.01 Program A Range Of A Spreadsheet
Locked
05.02 Use Cells Instead Of A Range
Locked
05.03 Use A Range Variable
Locked
05.04 Select A Range
Locked
05.05 Access A Row
Locked
05.06 Copy And Paste A Range
Locked
05.07 Clear A Range
Locked
05.08 Count A Range
Locked
05 Source Files
Locked
+ Work with Range Properties 8 lectures
06.00 Topics Overview
Locked
06.01 Find The Current Region Of A Cell
Locked
06.02 Dynamic Range Program
Locked
06.03 Resize A Range
Locked
06.04 Select Entire Rows And Columns
Locked
06.05 Offset Property
Locked
06.06 End Property
Locked
06 Source Files
Locked
+ More Range Projects 10 lectures
07.00 Topics Overview
Locked
07.01 Union And Intersect Of Ranges
Locked
07.02 Detect Content
Locked
07.03 Build A Range Program
Locked
07.04 Change Text Color
Locked
07.05 Bold A Range
Locked
07.06 Change Cell Color
Locked
07.07 Work With Areas
Locked
07.08 Find Differences In Ranges
Locked
07 Source Files
Locked
+ Variables 7 lectures
08.00 Topics Overview
Locked
08.01 Integer Data Type
Locked
08.02 String Data Type
Locked
08.03 Double Data Type
Locked
08.04 Boolean Data Type
Locked
08.05 Retain Variable Value
Locked
08 Source Files
Locked
+ Work with Conditionals 4 lectures
09.00 Topics Overview
Locked
09.01 If Then Statement
Locked
09.02 Else Statement
Locked
09 Source Files
Locked
+ Work with AND, OR and NOT 5 lectures
10.00 Topics Overview
Locked
10.01 Greeting Program - Logical Operator And
Locked
10.02 Logical Operator Or
Locked
10.03 Logical Operator Not
Locked
10 Source Files
Locked
+ Build Conditionals Projects 9 lectures
11.00 Topics Overview
Locked
11.01 Select Case
Locked
11.02 Build A Commission Calculator Project
Locked
11.03 Find Remainder With Mod
Locked
11.04 Check Number Program
Locked
11.05 K Smallest Value Program
Locked
11.06 Group By Font Style
Locked
11.07 Remove Empty Cells
Locked
11 Source Files
Locked
+ Introduction to Loops 7 lectures
12.00 Topics Overview
Locked
12.01 Single Loop
Locked
12.02 Double Loop
Locked
12.03 Triple Loop
Locked
12.04 Do While Loop
Locked
12.05 Build A Commission Table
Locked
12 Source Files
Locked
+ Loop Projects 10 lectures
13.00 Topics Overview
Locked
13.01 Loop Through Defined Range
Locked
13.02 Loop Through Entire Column
Locked
13.03 Do Until Loop
Locked
13.04 Use Step To Increment
Locked
13.05 Build A Pattern Project
Locked
13.06 How To Sort
Locked
13.07 Sort By Related Data
Locked
13.08 Delete Duplicate Values
Locked
Source Files
Locked
+ String Manipulation 11 lectures
14.00 Topics Overview
Locked
14.01 Join Strings
Locked
14.02 Extract Substrings From Left Or Right
Locked
14.03 Extract Substring At Middle
Locked
14.04 Get Length Of A String
Locked
14.05 Get Substring Position
Locked
14.06 How To Split Strings
Locked
14.07 Reverse Characters
Locked
14.08 Change String Casing
Locked
14.09 Count Words In A Range
Locked
14 Source Files
Locked
+ Build Custom Functions 5 lectures
15.00 Topics Overview
Locked
15.01 Make And Use Your Own Function
Locked
15.02 Pass Arguments To A Function
Locked
15.03 Custom Calculator Function
Locked
15 Source Files
Locked
+ Build Arrays 10 lectures
16.00 Topics Overview
Locked
16.01 One Dimensional Array
Locked
16.02 Two Dimensional Array
Locked
16.03 Change Array Size
Locked
16.04 Build An Array
Locked
16.05 Populate Row With Array
Locked
16.06 Array Length
Locked
16.07 Split String Into An Array
Locked
16.08 Join Array Into A String
Locked
16 Source Files
Locked
+ Work with Dates 8 lectures
17.00 Topics Overview
Locked
17.01 Delay A Procedure
Locked
17.02 Schedule A Procedure
Locked
17.03 Count Years
Locked
17.04 Count Days Between Dates
Locked
17.05 Count Weekdays Between Dates
Locked
17.06 Sort Dates
Locked
17 Source Files
Locked
+ Application Object 8 lectures
18.00 Topics Overview
Locked
18.01 How To Access Excel Functions
Locked
18.02 Disable Screen Updating
Locked
18.03 Disable Alerts
Locked
18.04 Show Progress Of Macro_1
Locked
18.05 Read Data From A File
Locked
18.06 Write Data To A File
Locked
18 Source Files
Locked
+ VBA Projects 7 lectures
19.00 Topics Overview
Locked
19.01 Build A Table
Locked
19.02 Build A Table Of Contents
Locked
19.03 Build A Table Of Contents 2
Locked
19.04 Combine Worksheets
Locked
19.05 Combine Worksheets By Column
Locked
19 Source Files
Locked
+ Programming Charts 5 lectures
20.00 Topics Overview
Locked
20.01 Program A Chart
Locked
20.02 Program An Embedded Chart
Locked
20.03 Delete Charts Programatically
Locked
20 Source Files
Locked
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.