Excel Macros & Excel VBA Programming for Beginners

Become a proficient Excel Macros and Excel VBA Programmer in a very short time. Excel 2019 Macros & VBA Examples included.

Buy $29.99 Free Preview

What you’ll learn

Overview

This course will teach you how to become a proficient Excel Macros and Excel VBA Programmer in very short time.

Top companies offer this course to their employees

What our students say:

“The instructor is AMAZING!! Using EXCEL on a Mac is slightly different from using Windows and makes following along difficult at times. Fortunately, Andreas acknowledges these differences and takes the time to walk Mac users through them. Mr. Andreas, you're the prime example of a phenomenal teacher!”

Scott L.

“Explained the concepts well in an easier to understand way for someone just beginning VBA, the ideal introduction course!”

Liza B.

“It is a very well-laid-out course. It gives a lot of insight with regard to Microsoft Excel VBA and Macros”

Ferano R.

“This course exceeded my expectations! I've used Excel for years but haven't had any sort of training with macro and VBA. I really liked how lessons were broken down into short, easy to understand videos.”

Camil

“”

This course includes:

Automate Your Day With Excel VBA

Over 8 hours of video content
Downloadable Workbooks and Templatesload
Complete VBA Projects for real-life application
Exercises & Quizzes to test your skills

Automate The Boring Stuff

Automate ANYTHING you need done in Excel with VBA and Excel macros

Why not automate those borings Excel tasks so you can spend more time on what you enjoy? Things like discovering new Excel features, analyzing data, and creating dashboards. Excel VBA is an extremely valuable skill to put on your resume.

Get Access for $69

Course curriculum

1. Introduction
  FREE PREVIEW
2. Course Resources
3. Compatibility & Macros Security
4. Why a macro and not regular Excel?
5. For Mac users
1. How to Record a Macro
2. How to Run a Macro and Assign it to an Icon or a Button
3. Personal Macro Workbook
4. Watch An Excel Macro Write Your VBA Code
5. Absolute vs. Relative Referencing during Macro Recording
6. Rules regarding Naming Macros
7. Assignment 1
8. EXERCISE: Record a Macro
9. ❓QUIZ 1: The Basics of Macros
1. A Detailed Example of how we Record a Macro
2. Inserting a Data Entry Form into a Database Automatically
3. Clean Data with Macros
4. DEMO: Use Navigation Buttons to Change Chart Type
5. Tips for running your Macros fast
6. ❓QUIZ 2: Get in-depth with Macros
1. Introduction
2. A tour of the Developer Tab
3. The Makeup of a Macro
4. Referring to Ranges
5. Different Ways to Refer to a Range in VBA
6. Dynamic Ranges
7. Copying Data in VBA
8. Copying Data to the Bottom of a Range
9. Finding Data with VBA
10. Replacing Data Quickly
11. Special Cells
12. How to troubleshoot when your code is not working properly
13. Excel VBA Indentation
14. ❓QUIZ 3: Starting Excel VBA Programming
1. Introduction
2. VBA Syntax and Expression Entry
3. Sub Procedures
4. Sub Procedure Examples
5. Variables
6. Strings and Dates
7. Assignment Statements
8. Why use Option Explicit?
9. Constants
10. Arrays
11. Using Relative or Absolute Reference
12. ❓QUIZ 4: VBA Language Elements in Detail
1. Introduction to Objects, Properties, Methods, and Events
2. RANGE Property
3. CELLS Property
4. OFFSET Property
5. VALUE, TEXT, COUNT, COLUMN, ROWS & ADRRESS Properties
6. SELECT, CLEAR & DELETE Methods
7. Subroutine Examples - Part:1
8. Subroutine Examples - Part:2
9. Subroutine Examples - Part:3
10. How to handle Basic User Error in your Subroutines
11. ❓QUIZ 5: Common Objects, Properties & Methods
1. Introduction
2. Sorting with VBA – Part: 1
3. Sorting with VBA – Part: 2
4. Sorting with VBA – Part: 3
5. Filtering with VBA – Part: 1
6. Filtering with VBA – Part: 2
1. Introduction
2. How to borrow functions from Excel
3. Using Built-In VBA Functions
4. Using Worksheet Functions in VBA
5. How to make your own user-defined (UDF) function (Custom Functions)
6. How to convert a user-defined function to an Excel Add-In
7. Custom Function Examples
8. ❓QUIZ 6: Using VBA and Worksheet Functions
1. Introduction
2. The If-Then Structure
3. For-Next loops
4. Applications of Looping Methodologies - Part:1
5. Applications of Looping Methodologies - Part:2
6. Applications of Looping Methodologies - Part:3
7. Iterating through a Selection vs. a Range
8. Using the For Each... Next statement
9. DEMO: Using IF..ELSE Statements with Macros
10. DEMO: Using FOR…NEXT Statements with Macros
11. ❓QUIZ 7: IF and FOR Looping Statements
1. Do...Loops
2. Validating user input using a Do...Loop
3. Creating a guessing game using a Do...Loop
4. Assignment 2: Do-While loop and Do-Until loop
5. The GoTo Statement
6. Combining Macro Recording and VBA Statements
7. How to join 2 different Macros
8. ❓QUIZ 8: Variable iteration loops
1. PROJECT: Transfer Data From one Excel Worksheet to another
2. PROJECT: Create an Interactive Map using VBA & Macros
3. PROJECT: Add a confirmation dialog box with VBA IF statements
4. PROJECT: Prompting a user to select a worksheet and run a macro
5. PROJECT: How to Create Notifications-Reminders using VBA Code
6. PROJECT: How to create an Excel Animated Chart using VBA Code
7. PROJECT: Saving a Workbook before Closing
8. PROJECT: Closing All Workbooks at Once

About this course

$29.99
98 lessons
8 hours of video content

Who Is This Course For?

New to VBA

You’re starting from scratch. You don’t know a loop from a macro. You want to learn VBA, but you need baby steps.
Some Experience With VBA

You’ve dipped your toe into VBA. Nothing too crazy. You know there are better methods to what you’ve been doing.
VBA Power User

You use VBA every day. Given your foundation, why not get the most mileage out of your experience? You’ll pick up new tools and methods faster than beginners.

Frequently Asked Questions

How long do I have access to the course?

After enrolling, you have unlimited access to this course for as long as you like – across any and all devices you own.
What are the pre-requisites for this Excel VBA course?

You don’t need any prior business or technical knowledge. All you need is a computer with Excel
What level of Excel VBA do I need?

You Don’t Need A Programming Background To Learn VBA. In fact, if you’ve been interested in getting into programming, this is a good place to start.
When does the course start and finish?

Hi, I'm Andreas Exadaktylos

I have a Master's Degree in Computer Science and a Degree in Electronic Engineering. I have over 20 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.

Andreas Exadaktylos

[email protected]

Hi, I am Andreas and I'm a Best Selling Teacher. I really love learning and teaching whenever I can. I have a Master's Degree in Computer Science and a Degree in Electronic Engineering. I have over 20 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 Learning School. 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 20 years. I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family, my two kids and my lovely dog. Travel, forex trading, and reading books are my favorite hobbies.

Discover your potential, starting today

Enroll today