Excel Macros & VBA for Beginners
4.4 (93 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.
561 students enrolled
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.4 (93 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.
561 students enrolled
Last updated 3/2017
English
English
Current price: $15 Original price: $50 Discount: 70% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 6 Articles
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
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

*** 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
Curriculum For This Course
Expand All 48 Lectures Collapse All 48 Lectures 01:58:06
+
Introduction
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!
00:54

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

Download the Excel Project Files + Course Study Tracker
00:21

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

Let’s get started by answering the most common questions
01:39

I need your help!
01:02
+
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
02:09

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

Rules regarding Naming Macros
Rules regarding Naming Macros
00:09

There are many ways to start recording a macro.

Learn the most important.

Ways of Recording a Macro
02:58

Running a Macro using the Ribbon

Run a Macro using the Ribbon
01:00

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

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
04:31

Running a Macro using Buttons or Graphics
Run a Macro using Buttons or Graphics
02:45

Quiz 1: The Basics of Macros
4 questions

How can I help you?

How can I help you?
00:26
+
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
01:04

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

Macro Recorder vs VBA
01:33

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

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

Quiz 2: Enter the world of VBA
3 questions
+
Get in-depth with Macros
6 Lectures 15:26

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

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 (NEW 3/2017)
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
+
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!
03:40

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
02:36

In this lecture I wonna talk about With End With statement

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

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

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

Learn how to use Range and Cells properties

Range and Cells properties
01:42

Variables are extremely powerful when we create Visual Basic applications
Variables
02:13

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

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

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)
04:08

Saving a Workbook before Closing
Saving a Workbook before Closing
02:32

Closing All Workbooks at Once
Closing All Workbooks at Once
01:13

My Final Thoughts & Thank you!
00:44
+
BONUS SECTION
1 Lecture 01:29

Great discounts for my other courses!

Amazing discount for my other courses!
01:29
About the Instructor
Andreas Exadaktylos
4.5 Average rating
883 Reviews
11,275 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.