Intermediate Excel VBA Automation Programming
01
Skill level
All levels
02
Sections
7
03
Lectures
45
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
7
Sections
✓
45
Lectures
✓
45
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.
+ Intro to Mammoth Interactive 2 lectures
00 About Mammoth Interactive
Locked
01 How to Learn Online Effectively
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
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.