Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel Macros & VBA for Beginners to your Wishlist.

Add to Wishlist

Excel Macros & VBA for Beginners

Become a proficient Excel Macro Programmer in very short time + Excel VBA for beginners. Excel 2016 Templates included.
4.5 (66 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
461 students enrolled
Last updated 2/2017
English English
$10 $50 80% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 6 Articles
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Create and Modify Macros in Excel
Become a proficient Excel Macro Programmer in a very short time
Know the difference between Macros and VBA
Understand VBA and create your first piece of code
Choose the right Loop for each task
Learn Automation secrets in Excel VBA
The course is full of code examples that you can use straight away
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
View Curriculum
  • 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

*** Completely up-to-date for November 2016 ***

*** This course is fully subtitled in English! ***

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

Excel Macros are 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 quiz after section so to prove that you have learned the material.
  • You will learn the most current version of Microsoft Excel (2016) but the concepts are compatible with Excel 2007, Excel 2010 and Excel 2013
  • Compatible with Microsoft Office for Macintosh

Are you looking to learn practical Macro 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 2016 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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 47 Lectures Collapse All 47 Lectures 01:55:44
6 Lectures 06:46

Introduction of the course

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

Preview 02:22

The secret to success with Excel Macros and VBA is start small, break tasks down into smaller parts and of course practice and practice.

Be a great student!

Please take one minute to introduce yourself to the rest of the course
Introduce Yourself!

Download the Excel Project Files + Course Study Tracker

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

Let’s get started by answering the most common questions

I need your help!
The Basics of Macros
10 Lectures 21:31
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:55

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

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

Rules regarding Naming Macros
Rules regarding Naming Macros

There are many ways to start recording a macro.

Learn the most important.

Ways of Recording a Macro

Running a Macro using the Ribbon

Run a Macro using the Ribbon

Running a Macro using the Quick Access Toolbar
Run a Macro using the Quick Access Toolbar

Here is a list of key combinations with letters. You want to avoid associating a macro with the following combinations

Avoid these Key Combinations when associate a macro with a key shortcut

Running a Macro using Buttons or Graphics
Run a Macro using Buttons or Graphics

Quiz 1: The Basics of Macros
4 questions

How can I help you?

How can I help you?
Enter the world of VBA
5 Lectures 13:15

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:05

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

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

Macro Recorder vs VBA

Take your first look behind the curtain to explore Visual Basic Editor
The VBA Environment

Visual Basic Editor contains several windows that you can customize and make your life easier
VBA Editor Tips

Quiz 2: Enter the world of VBA
3 questions
Get in-depth with Macros
5 Lectures 13:04

Learn in detail the most important elements of VBA

Preview 01:44

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

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

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

Recording your first Macro

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

Quiz 3: Get in-depth with Macros
3 questions
How to create your First Piece of Code
7 Lectures 16:23
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
Hello World!

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
The core of VBA: Workbook, Worksheet and Range

In this lecture I wonna talk about With End With statement

With …End With : how this statement can save you time

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

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

How to read from a cell

Learn how to use Range and Cells properties

Range and Cells properties

Variables are extremely powerful when we create Visual Basic applications

Quiz 4: How to create your First Piece of Code
4 questions
Supercharge Macros and VBA with Loops
9 Lectures 36:33
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

Using Relative or Absolute Reference and the difference between them
Using Relative or Absolute Reference

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

Using DO…UNTIL Statements with Macros

Using DO…UNTIL Statements with Macros

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

Project #2: Prompting a user to select a worksheet and run a macro

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

Combining Macro Recording and VBA Statements

How to join 2 different Macros
How to join 2 different Macros

Tips for running your Macros fast

Tips for running your Macros fast

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 #3: Transfer Data From one Excel Worksheet to another (NEW 06/2016)

Quiz 5: Supercharge Macros and VBA with Loops
3 questions
Ready-to-use Excel Macros & VBA Projects
4 Lectures 08:37

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

Project #4: How to Create Notifications-Reminders using VBA Code (NEW 2/2017)

Saving a Workbook before Closing
Saving a Workbook before Closing

Closing All Workbooks at Once
Closing All Workbooks at Once

My Final Thoughts & Thank you!
1 Lecture 01:29

Great discounts for my other courses!

Amazing discount for my other courses!
About the Instructor
4.6 Average rating
710 Reviews
10,519 Students
7 Courses
Teacher|Msc Computer Scientist

Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever I can.

I have over 16 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.

I have a Master's Degree in Computer Science and a Degree in Electronic Engineering.

I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.

I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 17 years. I am a professional Forex Trader for over 5 years.

I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.

I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family and my two kids. Travel, forex trading, and reading books are my favorite hobbies.

Report Abuse