Excel Macros Mastery & Excel VBA for Beginners

Become a proficient Excel Macro Programmer in very short time + Excel VBA for beginners. Excel 2016 Templates included.
4.5 (55 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.
376 students enrolled
$19
$95
80% off
Take This Course
  • Lectures 46
  • Length 2 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English Closed captions available

Course Description

*** 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)

What are the 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

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:22

Introduction of the course

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

00:54

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

Article
Please take one minute to introduce yourself to the rest of the course
Download the Excel Project Files + Course Study Tracker
Article
01:39

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

I need your help!
01:02
Section 2: The Basics of Macros
01:55
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.

02:09
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
03:18

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.

Article
Rules regarding Naming Macros
02:58
There are many ways to start recording a macro.

Learn the most important.

01:00

Running a Macro using the Ribbon

02:20
Running a Macro using the Quick Access Toolbar
Article

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

02:45
Running a Macro using Buttons or Graphics
Quiz 1: The Basics of Macros
4 questions
Article

How can I help you?

Section 3: Enter the world of VBA
04:05

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

01:04
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
01:33

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

04:16
Take your first look behind the curtain to explore Visual Basic Editor
02:17
Visual Basic Editor contains several windows that you can customize and make your life easier
Quiz 2: Enter the world of VBA
3 questions
Section 4: Get in-depth with Macros
01:44

Learn in detail the most important elements of VBA

02:55
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?

01:36
If you work with macros a lot, you may need to organize them based on what a macro really does
03:33

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

03:16

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

Quiz 3: Get in-depth with Macros
3 questions
Section 5: How to create your First Piece of Code
03:40
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
02:36
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
02:19

In this lecture I wonna talk about With End With statement

02:32
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
01:21

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

01:42

Learn how to use Range and Cells properties

02:13
Variables are extremely powerful when we create Visual Basic applications
Quiz 4: How to create your First Piece of Code
4 questions
Section 6: Supercharge Macros and VBA with Loops
05:19
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
03:12
Using Relative or Absolute Reference and the difference between them
05:48
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.
02:09

Using DO…UNTIL Statements with Macros

02:21

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

05:44

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

01:40
How to join 2 different Macros
02:01

Tips for running your Macros fast

08:19

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.
Quiz 5: Supercharge Macros and VBA with Loops
3 questions
Section 7: Ready-to-use Excel Macros
02:32
Saving a Workbook before Closing
01:13
Closing All Workbooks at Once
My Final Thoughts & Thank you!
00:44
Section 8: BONUS SECTION
Article

Great discounts for my other courses!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Andreas Exadaktylos, 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.

Ready to start learning?
Take This Course