Excel Macros & Excel VBA Programming for Beginners
4.2 (610 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.
2,298 students enrolled

Excel Macros & Excel VBA Programming for Beginners

Become a proficient Excel Macros and Excel VBA Programmer in very short time. Excel 2019 Macros & VBA Examples included.
4.2 (610 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.
2,298 students enrolled
Last updated 8/2020
English
English [Auto], Polish [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 4 articles
  • 43 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
  • Create and Modify Macros in Excel
  • Understand VBA and create your first piece of code
  • The course is full of code examples that you can use straight away
  • Become a proficient Excel Macro Programmer in a very short time
  • Know the difference between Macros and VBA
  • Choose the right Loop for each task
  • Learn Automation secrets in Excel VBA
  • Follow along with included Excel project files
  • Learn from an instructor with over 16 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
  • Learn the most current version of Microsoft Excel
  • Course updated regularly
  • An instructor ready to answer your questions in less than 24 hours
  • Watch high-quality video lectures with lifetime access
  • Quizzes and exercises
  • Certificate of completion
Requirements
  • Only basic prior experience in Microsoft Excel or spreadsheets is required to get the most out of this Excel course.
  • Break your tasks down into small parts. The more you practice the better you become
  • This course was recorded with Excel 2016 but it's also compatible with Excel 2007, 2010 and 2013
  • It is also compatible with Microsoft Office for Mac
Description

Become a proficient Excel Macros & VBA Programmer in a very short time.

Excel VBA is powerful. Everybody wants to learn Excel Macros and VBA. They can make Excel work like magic. But most Excel users never use them. Other spending several days on a multi-hour course or working through a 1000-page book, getting overwhelmed with information. So why waste a great deal of time learning things you may never use.

In this course my goal is to help you learn ways to create Excel Macros that won’t burst your brain. Also to convey the main principles of VBA language and allow beginners, taking their first steps, to learn without requiring individual training.

Content and overview

A macro is a sequence of instructions that automates some aspect of Excel so that you can work more efficiently and with fewer Errors. Macros are written in VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft.

If you think Excel VBA programmers are smarter or more gifted than you, then you’re mistaken. Yes, macros can be intimidating and yes, programming is a huge topic. If you saw a course on Excel programming with hundreds of lectures, would you really watch all of them?

But wait a minute… What about people who may not have programming background, but aspire to reap the utmost from the program? Are there any programming principles and well-guarded secrets that you can learn and use them to create any Macros you want?

In this course you will find several short, to the point lectures covering Excel Macros and VBA entertaining and accessible to non-techies. The goal is not to make you a star Excel programmer. If you want to be that, go for it! But I’ll give you some best practices and make this course extremely practical. After all, you are not a programmer, you just need to write an Excel Macro to help you get your work done.

Why is this course different?

  • It's super practical. Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.

  • It's comprehensive and fast. Microsoft Excel Macros and VBA are complex, that's why the course is broken down into bite-sized pieces

  • I update the Excel class monthly with new lectures!

  • It has a Homework-Quiz after section so to prove that you have learned the material.

  • You will learn the most current version of Microsoft Excel (2019) but the concepts are compatible with Excel 2007, Excel 2010, Excel 2013 and Excel 2016

  • Compatible with Microsoft Office for Macintosh

Are you looking to learn practical Macro and VBA techniques you can put to use instantly? If so, then this is the course for you. It’s entirely project based and it’s full of examples which are fully explained and easy to understand. It has been recorder with the brand new Excel 2019 in full HD 1080p. If you get stacked don’t worry. I have fast and fully support through the discussion board. And if you don’t like the course simply return it. There is a 30-day money back guarantee. At the end of this Microsoft Excel class you will be given a Certificate of Completion

What are you waiting for? Enroll now! (it is 100% no risk deal)

Who this course is for:
  • All Excel users who have always been interested in macros but have never found a good resource to learn them
  • Individuals who wish to turn Microsoft Excel into a powerful tool in their daily work
  • Students with willingness for learning
  • Business Professionals and Entrepreneurs
Course content
Expand all 68 lectures 04:44:39
+ Introduction
3 lectures 05:04

Introduction of the course

Become a proficient Excel Macro Programmer in a very short time.

Preview 02:09
Course Resources & Important Notes for New Student
01:22

Let’s get started by answering the most common questions.

Preview 01:33
+ The Basics of Macros
12 lectures 32:47
With macros you can take multiple steps sequences and turn it into a single step

In this Lecture we are going to learn how we can use Macros.

Preview 01:50
As we said in previous lecture, a macro is a set of instructions or code that you create to tell Excel to execute a number of actions. Let’s see some examples to understand how you can use them to automate repetitive tasks
Why macros are huge time-savers? See examples
02:04

All workbooks with an .xlsx file extension are automatically known to be safe, whereas you can recognize .xlsm files as a potential threat. Learn all the secrets of security in this Lecture.

Macros and Security
03:16
There are many ways to start recording a macro.

Learn the most important.

Ways of Recording a Macro
03:08

Running a Macro using the Ribbon

Run a Macro using the Ribbon
00:53
Running a Macro using the Quick Access Toolbar
Run a Macro using the Quick Access Toolbar
02:15
Running a Macro using Buttons or Graphics
Run a Macro using Buttons or Graphics
02:39
Assign a Macro to Ribbon Icons and Create your Own Ribbon
04:11
Relative OR Absolute Method?
04:44

Learn the differences between these two methods to create an automated task

Macro Recorder vs VBA
03:28
Rules regarding Naming Macros
Rules regarding Naming Macros
03:03
Quiz 1: The Basics of Macros
4 questions
EXERCISE: Record a Macro
01:16
+ Visual Basic Editor: What You Need to Know
7 lectures 26:11

Welcome to the 2nd main section of this course. It’s absolutely awesome that you are here to enter the world of Excel VBA

Preview 04:01
Take your first look behind the curtain to explore Visual Basic Editor
The VBA Environment
04:24
Visual Basic Editor contains several windows that you can customize and make your life easier
VBA Editor Basics
02:09
VBA Modules and Editor Tab Tips
05:46
Excel VBA Object Model
05:36
Like all programming languages, dealing with errors can by scary. Anytime you start something new you will make mistakes. But you don’t know that most of the times mistakes are easy to resolve
Dealing with VBA Errors
00:55
Using VBA's Help System
03:20
Quiz 2: Enter the world of VBA
3 questions
+ Get in-depth with Macros
6 lectures 15:20

Learn in detail the most important elements of VBA

Preview 01:36
Most of the time when we create a macro, it is designed for use in a specific workbook. But

what if you want a macro to be available all the time, regardless which workbook is opened that time?

Make a macro available all the time
02:57
If you work with macros a lot, you may need to organize them based on what a macro really does
Organizing your Personal Macro Workbook
01:36

In this lecture you'll learn the steps in detail to record and test a macro

Recording your first Macro
03:33
When we create a macro we actually create the VBA code behind the scenes. Learn how to do it!
Watch An Excel Macro Write Your VBA Code
02:22

A simple but effective way to run a macro is with the help of form controls and specifically buttons. How can you do that?

Project #1: Use navigation buttons to change Chart Type
03:16
Quiz 3: Get in-depth with Macros
3 questions
+ VBA Procedures
8 lectures 34:41
Welcome to this new Section, it’s fantastic that you made it here, as you are going to create your first piece of code. And in this lecture, we are going to write our first line of VBA code
How to Create your First Piece of Code
03:40
How VBA "speaks"
06:56
I hope you ‘re excited writing your first code in the previous lecture. Now we’ll continue to learn more about the 3 important elements of VBA
Workbook, Worksheet and Range
02:36
Object Properties and Methods
08:31
Sub Procedures
02:40
Sub Procedure Examples
03:26
Functions Procedures
03:35
Function Procedure Examples
03:17
Quiz 4: How to create your First Piece of Code
4 questions
+ VBA Language Elements
11 lectures 47:11
Variables
05:43
Constants
03:14
Strings and Dates
03:18

Learn how to use Range and Cells properties

Range and Cells properties
01:42
Assignment Statements
03:37
Arrays
04:00
Range Property
05:20
Cells Property
04:50
Offset Property
04:05
Useful Range Object Properties
07:13
Useful Range Object Methods
04:09
+ Make Decisions with VBA
13 lectures 51:55

In this lecture I wonna talk about With End With statement

With …End With Constructs
02:19

You have already learned how to write a value to a cell. But what if you want to read from one cell to another?

EXAMPLE: How to read from a cell
01:21
From the previous lecture we learned how to use With for a specific workbook. Using With is fine when we have one workbook or worksheet. But when using multiple sheets we need to use something else. This is where Dim and Set comes in
Dim and Set statements
02:32
In this lecture you'll understand how important are the If Then Else statements and the freedom that give us when we want to create trickier macros
Using IF..ELSE Statements with Macros
05:19
Using Relative or Absolute Reference and the difference between them
Using Relative or Absolute Reference
03:12
If you need to count something or you need to loop through a series of predetermined elements within a given set then the For and Next statements are a must.
Using FOR…NEXT Statements with Macros
05:48

Using DO…UNTIL Statements with Macros

Using DO…UNTIL Statements with Macros
02:09
Project #2: Add a confirmation dialog box with VBA IF statements
09:10

Case Study: Prompting a user to select a worksheet and run a macro

Project #3: Prompting a user to select a worksheet and run a macro
02:21

Sometimes we need to create more complex macros. Learn how to combine Macro Recording and VBA Statements

Combining Macro Recording and VBA Statements
05:44
How to join 2 different Macros
How to join 2 different Macros
01:40

Tips for running your Macros fast

Tips for running your Macros fast
02:01

How to Automatically Transfer Data From One Excel Worksheet To Another With Vba and Macros.

We use a command button and code it using VBA so that the data entered by an operator is automatically transferred to another worksheet on click.
Project #4: Transfer Data From one Excel Worksheet to another
08:19
Quiz 5: Supercharge Macros and VBA with Loops
3 questions
+ Ready-to-use Excel Macros & VBA Projects
4 lectures 16:39

In this lecture, we will create a notification or reminder if you prefer, in Excel, using VBA.

Project #5: How to Create Notifications-Reminders using VBA Code
04:08
How to create an Excel Animated Chart using VBA Code
08:46
Saving a Workbook before Closing
Saving a Workbook before Closing
02:32
Closing All Workbooks at Once
Closing All Workbooks at Once
01:13
+ BONUS SECTION
4 lectures 54:50
Excel 2019 Tutorial for Beginners
13:31

Table of Contents

----------------------------------

1. SORTING COLUMNS WITH BLANK CELLS 0:56

2. MAKING THE ROWS COLUMNS AND THE COLUMNS ROWS 3:20

3. HIDE A WORKSHEET - VERY HIDDEN PROPERTY 4:20

4. BLOCKING A USER TO INTERACT OUTSIDE A SPECIFIC RANGE 6:00

5. HOW TO FREEZE TITLES AND SPLIT SCREENS 6:56

6. HOW TO ADD TEXT TO A NUMBER 9:00

7. CREATE A CONDITIONAL FORMAT BASED ON A VALUE 10:00

8. FORMULA ERROR CHECKING - TRACE ERROR 11:45

9. LOCKING AND HIDING FORMULA CELLS 13:04

10. GET RID OF UNWANTED SPACES 15:01

11. USE AUTOCORRECT TO ENTER DATA FAST 16:30

12. THE PASTE SPECIAL FEATURE 17:50

13. USE FILL HANDLE TO ENTER SEQUENCES OF VALUES 19:21

14. HOW TO GET RID OF DUPLICATE RECORDS 20:56

15. HIGHLIGHT FORMULA CELLS USING CONDITIONAL FORMATTING 22:20

16. ADD COMMENTS INSIDE FORMULAS 24:15

17. HOW TO USE FLASHFILL TO FILL VALUES IN A RANGE RAPIDLY 25:10

18. CHANGING VALUES WITHOUT FORMULAS 26:26

19. HIDING SCROLLBARS IN A WORKSHEET 27:46

20. HOW TO PROTECT WORKBOOKS, WORKSHEETS & CELLS 28:55

Top 20 Excel Tips and Tricks
34:43
Excel 2019 Useful Keyboard Shortcuts and Tips
05:47

Great discounts for my other courses!

Amazing discount for my other courses!
00:49