Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excel VBA Macros: Save Hours and Automate Excel (All Levels)

Name: Excel VBA Macros: Save Hours and Automate Excel (All Levels)
Rating: 4.4 (323 reviews)

Learn Excel VBA to automate tasks, build tools, and save hours—even if you’ve never written code before.

Created byRami Abou Jaoude

Last updated 8/2025

English

What you'll learn

Automate your tasks in Excel and focus your time on more productive activities
Wow your stakeholders, e.g., Dynamic Charts and AI analyzing your report
Make your team work fast and better with efficient VBA tools
As you can't memorize everything, learn how to search, modify and use the right piece of code
Loose the fear of using VBA

Course content

23 sections • 176 lectures • 19h 42m total length

Introduction2:13
Quick intro:
1) Mac Users
2) Levels
3) Memorizing
4) Having fun!
L02 Important: How to choose the lessons for your level!0:48
Overview of the star concept to choose the right lessons for your level. Since the course is for all levels, this will help you focus on what is right for you

Material For the Section0:01
Material to download for the section
How to Set up your Excel File to use VBA - Just a simple Save! (*)0:39
Important: To make sure the macros always work, you need to save your file as a Macro-Enabled Workbook.
Click File → Save As.
In Save as type, choose Excel Macro-Enabled Workbook (*.xlsm).
Click Save.
If you save it as a normal .xlsx file, all the macros will be removed.
L01 Basic Set up and Introduction to VBE (*)7:59
Activate the Developer Tab
Different ways to access the Visual Basic Editor
How to close and save the code
Where to write code (Sheet, Workbook, Module)
Overview of the Project & Properties Windows
How to add editing tools and remove Error Pop up
L02 Copy Paste & Save your code (*)3:56
Different ways to copy paste your code
How to ensure you are saving your work properly
L03 Forget your fear and write your first macro (*)5:42
Forget your fear and write your first macro!
L04 Run your Macro 10 Ways (**)9:24
Learn many ways to run macros including some nice user designs
L05 Use ChatGPT to write your code! (****)4:40
Use ChatGPT to write your code!
L06 Code Color, Useful Shortcuts & Basic Debugging (*)4:11
What the Green, Red and Blue colors in the code mean
L07 Useful shortcuts & Debugging techniques (*)5:44
Learn 10 useful shortcuts
Learn the basics to debug your code such as running it line by line and using break points

Material for the section0:01
Material to download for the section
L01 Cell Referencing, Row Height & Column Width (*)13:43
Learn many ways to write content into cells so you can easily modify a code if you see it
Change the Height of a Row
Change the Width of a column
Clear content as a best practice before running your code
L02 Common Properties & Methods related to Cells (*)5:44
High level overview of most common properties & methods related to cells that you will use in your project
L03 Finding Last Row/Last Column in dataset (***)10:32
2 methodologies to find the last row / column in a dataset
Introduction to the immediate window
L04 Select Data, Get the address & Delete Data (*)9:41
How to use CurrentRegion
How to select data
How to get the address of a range (e.g., A2:A10)
How to Clear & Delete Data (the same way you would do in Excel - Right click delete)
L05 Part 1 Formatting with VBA (**)10:04
Learn how to format with VBA:
Color Cells
Font Color
Font Size
Underline, Bold, Italic, Superscript, etc...
Borders
Number Format
Value vs Text
Introduction to inserting a formula and checking is a cell has a formula
L05 Part 2 Trick to extract RGB from a color (*****)5:46
Pro trick using MOD to extract the RGB values form a color since there is no reverse RGB function in VBA
L06 Sheet Referencing (*)5:45
Multiple ways to reference sheets:
Activesheet
Sheet index
Sheet Name
Sheet code
L07 Workbook Referencing (*)5:14
4 Ways to reference workbooks:
ActiveWorkbook
ThisWorkbook
Workbook Num (Must be opened)
Workbook Name (Must be opened)
L08 Copy Paste(Special) (*)7:27
How to Copy Paste:
Copy Paste
Paste Special
Use UsedRange and CurrentRegion
L09 Resize a Range (****)7:36
The challenge is to copy paste data without the header by resizing a range
L10 Mini Project Part 1- Sort Data and generate a report using a template (****)9:50
In part 1, learn 2 ways to sort your data (depending on how many sort columns you have):
Range.Sort
Worksheet.Sort
L10 Mini Project Part 2- Sort Data and generate a report using a template (****)11:01
L11 Mini Project - Report Analyzer (*****)14:22
Learn how to code a cool voice that will read and analyze a report:
Select relevant cells
Color cells as it speaks
Change the speech dynamically based on the data

Material for the section0:01
Material to download for the section
L01 The Excel Object Model (*)2:35
Definition of the Object Model
Object Hierarchy
How to perform an action on an object
L02 Object Properties (*)1:54
Understand the difference between object and properties including hierarchy
L03 Object Methods (*)2:18
Difference between object & method. Also you will see the different syntaxes for methods
L04 Don't Memorize -Different ways to get find Objects, Properties & Methods(**)5:19
Check out the different way to find the code you need:
Macro recorder
Object Library
F1
Intellisense
Immediate Window
Internet
Copy Paste

Material for section0:01
Material to download for the section
L01 Intro to Variables & Types (*)6:46
What is a variable
Why use variables
Variable types
L02 Declaring Variables - best practices (*)10:39
How to declare variables with the Dim statement
Best practices in naming and declaring a variables
Other variables such as arrays and constants
L03 Object Variables (***)8:47
Theory behind object variables
Exercise where we create a new workbook, copy paste data and color it in green
Includes some best practices on Workbook, Worksheet and Range Objects
L04 Variable Scope - Rock Paper Cisor Game (***)14:40
How to share a:
Variable within procedure
Variable within module
Variable within project
Variable between workbooks
L05 Order of Preference in Calculations (*)5:33
Know the order of preference in calculations to be able to write a correct equation in VBA
L06 Convert to a different Data Type (**)5:49
Convert a result into different data types (string, double, integer, Long, etc...)
L07 Formulas (****)12:47
How to write formulas (including pitfalls and best practice) using:
Evaluate
Worksheetfunction
Trick to write Range("XX") in a shorter way
L08 Mini Project Expense Report (***)16:12
Help John and Ana generate their expense report - You will use variables and formulas

Material for section0:01
Material to download for the section
L01 Macro Recorder (*)7:59
How to use the macro recorder and clean the code
L02 R1C1 Notation (****)13:49
Understand the R1C1 notation:
Absolut referencing
Relative referencing
How to reference a range & a column
Write formulas with R1C1 notation and drag them down
L03 Practical use of Macro Recorder to automate Task (***)7:55
Look at an example where you can use the macro recorder & clean the data to automate a task
L04 Absolute vs Relative Reference in Recording (***)6:10
Difference in using the Macro Recorder with:
Absolute reference
Relative Reference

Material for section0:01
Material to download for the section
L01 With...End With (**)6:24
How to write a With...End With code to improve your coding
L02 For Each...In...Next (****)5:57
Looping through objects
L03 If Statement with Protect/Unprotect Sheet (**)6:40
Discover the If statement and use it to protect/unprotect sheets
L04 And / Or Logical Operators (**)5:03
Learn how to incorporate And / Or in your if statements
L05 Like Operator (****)8:20
Use Like to do partial match comparaison
L06 IsNumeric (***)3:21
Use IsNumeric to avoid a common pitfall
L07 Select Case (***)8:17
How and When to use the Select Case Statement

Material for section0:01
Material to download for section
L01 MsgBox Deep Dive (**)11:04
Learn how to use the Msgbox beyond just displaying a message:
How to get the username of the person using excel
How to go to the line
How to Add multiple buttons
How to use the user answer to perform some actions
L02 InputBox (***)13:44
Learn the Ins and outs of the InputBox:
Key parameters
How to handle potential pitfalls and errors
L03 Get a Range of Cells with InputBox (****)4:12
How to ask the user to input a range with an InputBox
L04 Mini Project - Identify the winners (***)7:36
Use your section learnings to get the winners of a competition

Material for section0:01
Material to download for section
L01 Use For...Next Loop to filter Data (***)12:45
Basics about For...Next Loop + Example
L02 Reverse For...Next Loop (****)7:54
Most frequent case when you should use a reverse For...Next Loop
L03 Do Until / Do While / Do (***)8:12
How to use:
Do Until Loop
Do While Loop
Do Loop with Exit Loop
L04 Do Loop with InputBox (***)8:10
Learn a trick to keep on showing the InputBox until you get a number
L05 Find 1 Match (***)10:24
Find a a faster way to go through data and search for a match. Here we will look at 1 match.
L06 Find Multiple Matches (*****)7:32
Find a a faster way to go through data and search for a match. Here we will look at multiple matches.
L07 Timer to Measure Code RunTime (**)4:15
Properly use the Timer to measure the Execution speed of a code
L08 Stop an infinite Loop (*)1:41
Use Esc to stop an Infinite Loop
L09 While Loop with a new way to find last row in dataset (***)7:02
Check out the While loop (not used a lot these days) and try to find the last row in a dataset having random blanks
L10 Mini Report with Loops (***)11:51
Use the techniques you learned in this section to automate a report

Requirements

Be comfortable using the normal Excel sheets. You don't need to be a formula Guru but you need to have the basic knowledge of Excel. How to use basic formulas, how to write in cells, copy paste formulas, etc...

Description

About Me

I’m not just an Excel fan—I’ve used it to build analytics departments, automate reports, and lead strategy at the VP level. I hold a Harvard MBA, a degree in Computational Sciences, and spent over a decade managing teams in a global bank. I was also a McKinsey consultant, trained to solve complex problems under pressure. I’ve worked in AI, built chatbots, and automated full workflows—but I still believe Excel is the fastest path to real-world productivity. And nothing unlocks that faster than VBA.

1. Why Learn Microsoft Excel VBA?

Excel is already powerful—but with VBA, it becomes unstoppable. Over 500,000 companies in the U.S. rely on Excel. Most reporting and analysis work doesn’t require complex models—it just needs to be automated.

That’s where VBA comes in. You’ll be able to:

Automate repetitive tasks
Build one-click dashboards and tools
Create dynamic workflows without hiring a developer
Control files, PDFs, emails, PowerPoint—and even simulate keyboard actions

And you’ll be surprised how much of it is easier than you think.

2. Work Smarter, Not Harder

The difference between someone who knows Excel… and someone who automates Excel is career-changing.

While others stay late updating reports, you’ll be building tools that run in seconds. You’ll finally move from manual work to impactful work—and from “Excel user” to “Excel wizard.”

This course will help you free up time, reduce errors, and turn spreadsheets into fully functional apps—without needing to be a programmer.

3. Why This Course?

You don’t need to memorize code. You need to understand it just enough to use it.

That’s what this course does. We break VBA down into practical, real-world steps, so you can:

Read and adapt existing code
Create your own macros from scratch
Build tools and reports that actually help your team

This course is built for real-life workflows, not classroom theory. You’ll build solutions you can actually use at work—like:

Copy/paste automation
Dynamic dashboards
Auto-generated reports
PDF-to-Excel tasks
Customized user forms and interfaces

Whether you're a beginner or looking to sharpen your skills with event-based triggers, error handling, or advanced userforms, this course will give you the confidence to stop asking for help… and start automating like a pro.

And yes—you’re protected by Udemy’s 30-day refund policy, as long as you’re within their terms.

Frequently Asked Questions

Q: Is this course beginner-friendly?
Yes. You’ll start from zero, and every concept is explained in simple, clear language.

Q: Do I need coding experience?
No. You’ll learn step by step. And you’ll see how even small scripts can make a big difference.

Q: What if I’ve already recorded macros before?
Perfect. You’ll now learn how to actually understand, clean, and modify that code—and build on it.

Q: Can I apply this in my job right away?
Yes. Every lesson is built around real-world use cases—not abstract examples.

Q: Will this work with Excel 365 / 2021 / older versions?
Yes. VBA has been stable across versions for years, so the material applies no matter your Excel version.

Q: What if I don’t like the course?
You’re covered by Udemy’s 30-day refund policy, provided your request meets their platform conditions.

Who this course is for:

Beginners with no prior knowledge of VBA: You will learn step by step
Intermediate VBA users: You will be able to sharper your skill and take away a wealth of codes to use to in your projects

Excel VBA Macros: Save Hours and Automate Excel (All Levels)

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 3min

My First Macro (*)9 lectures • 42min

Referencing and Copy Paste (**)14 lectures • 1hr 57min

Data Object Model (*)5 lectures • 12min

Menus & Toolbar Walkthrough (*)5 lectures • 23min

Variables & Formulas (**)9 lectures • 1hr 21min

Macro Recording (***)5 lectures • 36min

Looping through Objects, Conditional & Logical Operators (***)8 lectures • 44min

Interacting with Users (***)5 lectures • 37min

Looping (***)11 lectures • 1hr 20min

Requirements

Description

Who this course is for: