Unlock Excel VBA and Excel Macros
4.6 (17,834 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
78,946 students enrolled

Unlock Excel VBA and Excel Macros

Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.
Bestseller
4.6 (17,852 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
79,014 students enrolled
Created by Leila Gharani
Last updated 5/2020
English
English, French [Auto-generated], 6 more
  • German [Auto-generated]
  • Indonesian [Auto-generated]
  • Italian [Auto-generated]
  • Polish [Auto-generated]
  • Portuguese [Auto-generated]
  • Spanish [Auto-generated]
Current price: $129.99 Original price: $199.99 Discount: 35% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 22.5 hours on-demand video
  • 28 articles
  • 53 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Enhance your current Excel files & automate your work with VBA.
  • Master Excel VBA & Macros
  • Directly apply the Excel VBA example files included to your own work.
  • Reduce manual routine tasks to the click of a button.
  • Make your work-life easier.
  • Create simple solutions to complex problems by levering Excel functionality with Macros.
  • Formulas & Excel core functionality can't do everything. Use VBA when you reach a limitation.
  • Easily adjust VBA code you find online to fit your purpose.
Requirements
  • Familiarity with Microsoft Excel.
  • Demonstration is done with Excel 2016 but the techniques work with any version of Excel.
  • Excel on Windows (some techniques might work on mac, but I will not be able to support you).
Description

Go from Beginner to Microsoft Excel VBA Expert!

I'll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects. 

What differentiates this course from the other Microsoft Excel VBA & macros courses? It includes:

  1. Over 50 Microsoft Excel VBA & macro examples. These are solutions my clients have needed through the years. They are likely to be useful for you too.

  2. Using the right VBA syntax is the most difficult part. An important topic which isn't covered enough in other VBA courses. In this course you understand why you write things in certain ways.

  3. Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step.

  4. Over 100 pages of documentation (including useful code) so you can easily refer to it when in need.

  5. Simple explanations for complex concepts.

  6. High quality video and different delivery methods to keep things interesting.

  7. Lots of ideas to automate your current tasks.


Learn from Google or from this Course?

I've been there! I first learnt VBA from Google.

It was truly a light-bulb moment, when I realized that Google has some answers - it could give me some of the code I was looking for - but there two things missing:

  1. The WHY - why does the code work in one situation but not another.

  2. Structure - topic sequence, real-case examples, workbooks, documentation.

Don’t waste your time

Don't waste your time on poor quality videos and confusing explanations. In this Excel VBA course, complex topics are taught in a simple way by an instructor with 17 years of experience. The content has been carefully crafted and clearly organized. The videos are high quality and include animations to emphasize points. Most importantly you learn VBA by doing. 

"I have already tried some VBA classes but so far I was never able to apply what I learnt to my own work. This course is different. I have already used some of the techniques Leila is teaching and applied it to my work files. I was able to reduce manual work for me and my colleagues by creating my own macros from scratch. Highly recommended!!!" -- Randy Taylor

"Leila is the real deal... there are many VBA courses on Udemy (some of which I've taken) that merely demonstrate the functionalities. Leila explains the important foundation concepts and how the model is set up allowing you to truly create VBA code from thought rather than copying and pasting from various places. Her class is professionally constructed, with resources and content for each lecture, practice content for you to try things yourself and good Q&A opportunities to answer specific questions. Trust me, this is the course you want to take."  -- Justin Fazzio

What you can look forward to in this course:

  • Understand how to use the right syntax in VBA

  • Useful Excel VBA codes you can directly use for your work

  • Use the macro recorder for simpler tasks and improve the code

  • Working with the Visual Basic Editor

  • Debugging tools and error handling methods

  • Different ways to reference ranges and cells

  • Different methods to loop

  • How to work with data types

  • PivotTables in Excel using VBA

  • Importing data from other files and exporting data to text files

  • Interacting with other applications (Word, PowerPoint, Outlook)

  • ActiveX and Userforms to enhance the Excel interface

  • Basically all the knowledge you need to automate tasks in Excel

Who this course is for:
  • Business Professionals who'd like to simplify & automate work flow.
  • Data analysts.
  • You currently use Excel and like to improve your skills.
Course content
Expand all 172 lectures 22:30:18
+ Introduction & Scope
5 lectures 13:20

Check out what is included in the course and what you can do with Visual Basic in Microsoft Excel. You'll find examples to Excel tools you can create using VBA. 

Preview 04:19
Course Resources: Download Course Project Files
01:57
Course Expectations
02:51
Course Outline for Quick Reference
00:13
+ Your First Macro
9 lectures 55:22
Overview: Macros & Visual Basic Editor (VBE)
01:40
Steps to Your First Macro Recording
06:01
Visual Basic Editor: What You Need to Know
11:56
Project: Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros
11:28
7 Ways to Run Macros / VBA code (incl. creative & modern buttons)
12:24
OFFICE 365 Update: Change from Excel Comments to Notes
00:38
Activity: Record a Macro that Deletes all Comments
00:35
What's the Difference Between Macros and VBA?
01:07

Please fill out the following 4 questions to ensure you're ready to enter the next section.

Quiz: Test Your Knowledge on Macros
4 questions
+ The Object Model
8 lectures 46:01

To become an expert in Excel VBA, it's important to fully understand the Object Model. This way you'd be able to write the correct VBA syntax for your Excel projects (without guessing!). Selecting the wrong combination of objects, properties and methods will result in errors in your code.

Preview 01:39

Writing VBA code is all about manipulating objects on the screen. These objects have code words for easier reference. This code can be found in the VBA reference library. In this lecture you'll learn how to use the Excel VBA reference library so you can find the correct code for your Excel macro.

VBA's Code Reference Object Library
04:12

In this lecture we cover a few essential Excel VBA concepts including what a sub and function procedures are and what the different color codes mean. We also learn some useful shortcuts we can use the VBA editor.

VB Color Guidelines & Keyboard Shortcuts
12:09

In this lecture we get into the setup of the object model. VBA syntax is object first, then action. Objects can also have relationships with other objects - you need to be aware of the object hierarchy. It gets really interesting and fun.

Excel VBA Object Model
06:17

In this lecture you learn all about Excel VBA object properties and what these are. 

Object Properties
04:36

When you start to learn Excel VBA, it's important to understand what methods are and how you can use them together with objects to automate tasks.

Object Methods
05:54

VBA syntax is not easy to remember. How do you find the correct object, property or method that you need for your code? 

How to Find the Object, Property & Method
08:16

Make sure you answer these before moving on to the next section.

Test Your Knowledge about the Object Model
4 questions
Conclusion: Key Takeaways & Message from Me
02:58
+ Referencing Ranges, Worksheets & Workbooks with VBA
10 lectures 01:36:43

This lecture is a complete guide that teaches you how to refer and write to a range or to cells in Excel VBA. You'll learn how to change a cells value with VBA by using range and the cells property, the offset property. You'll also learn how to refer to different ranges in one statement, how to select a row or a column with VBA and how the used range property works.

Preview 15:37
Most Useful Range Properties & Methods
13:19

Find out how find the last empty row or the last empty column using different methods. Some work also with blank cells inside the data set. We take a look at using the end property of the range object. Then the current region property and the used range property of the worksheet object. We also take a look at using SpecialCells method to find the last used cell in the worksheet.

4 Methods to Find the Last Row of your Range
15:34
Copying & resizing a variably sized range
09:28
Properly Referencing Worksheets
14:50
Properly Referencing Workbooks
10:21
Project: Save Hard-coded Copy & Macro-free version of workbook
12:24
Key Takeaways for Referencing Ranges
03:03
+ Working with Variables
7 lectures 35:42
Overview: Role of Assignment & Variables
02:55
Data Types for Better Performance
03:33
Declaring Variables, Arrays & Constants (Role of Option Explicit)
12:52
Using Object Variables (Set statement)
06:50
Scoping Variables
06:58
Test Your Knowledge on Variables and data types
4 questions
Key Takeaways for Working with Variables
02:15
+ Looping through Collections & Making Decisions
10 lectures 58:49
Overview: Why Collections are a VBA Essential
01:27
With & End With for Easier Code Writing
06:21
For Each to Loop Through Collections (sheets, ranges etc.) in one go
10:14
IF Then (Else, ElseIF) for Conditional Outcomes
10:20
Select Case as Alternative for Many IF Statements
05:21
Goto Statement to Change Program Flow
07:37
Activity: Get the Number of Formulas on the worksheet
00:15
Project: Get the Number of Formulas on the Worksheet
07:00

Learn 3 ways how you can unhide all Excel tabs in one go. You can also apply this to all macro-free Excel Workbooks.

Bonus: Unhide All Sheets in One Go
10:09
Key Takeaways for Collections & Decision Making in VBA
00:05
+ Useful Built-in Functions
8 lectures 01:04:11
Overview: VBA versus Worksheet Functions
13:38
Most Useful VBA Functions
10:05
Input Box (VBA InputBox Function)
07:28
Input Box that can Select Ranges (Excel InputBox Method)
12:28
Activity: Show Top 3 Values in a Message Box Based on Range Selected
00:25
Project: Show Top 3 Values in a Message box based on Range Selected
11:19
Key Takeaways Built-in Functions
00:05
+ Debugging, Error Handling & Procedure Scope
9 lectures 01:06:55
Overview: Debugging, Handling Errors & Procedure Scope
02:00
Debugging Options: Watch, Locals, Immediate Windows & More
13:10
Error Handling: Different Methods
10:47
Faster Code by Suppressing Pop-ups & Flickering Screen
10:39
Procedure Scope & Running one Sub from Another
06:23
Passing Arguments to Sub Procedures (By Ref, By Val)
09:50
Activity: Get the Total Number of Formulas (or Comments) Used in a Workbook
00:26
Project: Get the Total Number of Formulas (or Comments) Used in a Workbook
11:43
Key Takeaways Debugging, Error Handling & Course Map Status
01:57
+ Main Project #1: Create a Tool to Automate Table of Contents
7 lectures 43:59
TOC Project: The Basics
10:33
TOC Project: Adding Hyperlinks
06:11
TOC Project: Testing the VBA Code
04:29
TOC Project: Adding Error Handling & More Checks
13:29
TOC Project: Adding to Personal Macro Workbook (Make it Available to all Files)
07:09
First Milestone Completed!
00:07
+ Looping in VBA (Controlling the Flow of Code)
12 lectures 01:28:43
Section Overview: Looping in VBA
02:28
For Next Counter Loops (Simple Example)
08:49
For Next Nested Loop (Loop through Text & Cells)
15:35
For Next Reverse Loop (Delete Filtered/Hidden Rows)
08:37
Do Until & Do While Loop
09:57
Practical Example of Do Loop (with Inputbox)
03:22
Find Method for Quicker Lookup Results
09:02
Find Method with Do Loop - Multiple Matches
06:24
Add a Timer to Test & Speech to Inform
07:56
Activity: Document all Comments in Workbook in a Sheet
00:32
Project: Document all Comments in Workbook in a Sheet
12:31
Useful VBA Statements & Key takeaways for Looping in VBA
03:30