EN
Start unlimited
Catalog Courses Books Assets Newsletter Merch About Contact Blogs
Cart Sign in Start unlimited
Catalog / All levels / Beginners Excel VBA
Mammoth Club All levels 10 sections 72 lectures

Beginners Excel VBA

Learn to code and automate Excel with Visual Basic for applications.

Created by John Bura
01
Skill level
All levels
02
Sections
10
03
Lectures
72
04
Instructor
John Bura
What's inside

This course includes.

✓
10
Sections
✓
72
Lectures
✓
72
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.

10 sections · 72 lectures
+ 01-02 Course Introduction 3 lectures
Source Files Locked
01.00 Course Overview Locked
02.00 How To Save Macros Locked
+ 03 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
+ 04 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.05 Open And Close Workbooks Locked
04.04 Get Path Of A Workbook 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
+ 05 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
+ 06 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
+ 07 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
+ 08 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
+ 09 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
+ 10 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
+ 11 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
Description

About this course.

Learn how to build your first macros with this beginners VBA course. Learn Excel Visual Basic for Applications to automate your Excel workflow.

Build Projects Including:

Learn how to send messages with MsgBox.

Learn how to automate workbooks with the Workbook object.

Program ranges with the Range object.

Manipulate range properties with VBA macros.

Build hands-on projects to automate Excel.

Learn the fundamentals of programming: variables, conditionals, and more with VBA projects.

And much more!

A SCHOOL YOU CAN TRUST

●     Lifetime access that never expires

●     Project-based curriculum to superboost your portfolio

●     Graduation certificate for every course

●     Absolute beginner-friendly

●     New courses every month

●     Efficient lectures with step by step explanations

●     Relevant industry topics

●     10 years of award-winning course delivery

●     1.1 million students in 186 countries

●     Learn with free tools and affordable courses

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work! Concise, yet comprehensive and informative.

Instructors

Taught by people who ship.

John Bura

John Bura

Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.

Ready to start building?

Learn to code and automate Excel with Visual Basic for applications.

Buy lifetime access →