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

Make Reporting 10x Faster

Automate all of your repetitive work with Excel Macros and VBA, get rid of tedious low value tasks and become indispensable to your clients and organization

Join Now

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

“”

VBA isn’t just about saving time. It’s about taking back control of your workday.

Inside Excel VBA Course, you'll gain access to:

Over 10 Hours of High-Quality Video Content
Speed up your learning with ready-made VBA code templates.
Engage in hands-on projects that guide you through real-world VBA challenges.
Enjoy lifetime access to all course content with free updates as new features are added to improve the course based on students' needs.

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
  FREE PREVIEW
3. Compatibility & Macros Security
  FREE PREVIEW
4. Why a macro and not regular Excel?
  FREE PREVIEW
5. IMPORTANT: Opening macro-enabled workbooks
6. For Mac users
7. Download the PDF File: 200+ Excel Shortcuts for PC & Mac
1. Introduction
  FREE PREVIEW
2. How to Record a Macro
  FREE PREVIEW
3. How to Run a Macro and Assign it to an Icon or a Button
4. Personal Macro Workbook
5. Watch An Excel Macro Write Your VBA Code
6. Absolute vs. Relative Referencing during Macro Recording
7. Rules regarding Naming Macros
8. EXERCISE: Record a Macro
9. ❓QUIZ 1: The Basics of Macros
1. Introduction
  FREE PREVIEW
2. A Detailed Example of how we Record a Macro
3. Inserting a Data Entry Form into a Database Automatically
4. Clean the Format of a Data Table using Macros
5. Absolute vs. Relative Referencing during Macro Recording
6. Writing Effective Macros
7. DEMO: Use Navigation Buttons to Change Chart Type
8. Assignment 1
9. ❓QUIZ 2: Get in-depth with Macros
1. Introduction
2. A tour of the Developer Tab
3. Overview of procedures in VBA
4. Referring to Ranges
5. Different Ways to Refer to a Range in VBA
6. Dynamic Ranges (& Intro to Variables)
7. Copying Data using VBA Code (& Intro to Objects)
8. Copying Data to the Bottom of a Range
9. Finding Data with VBA
10. Replacing Data Quickly
11. Using Special Cells to Remove Blank Rows
12. Why use Option Explicit?
13. How to troubleshoot when your code is not working properly
14. Excel VBA Indentation
15. ❓QUIZ 3: Starting Excel VBA Programming
1. Introduction
2. VBA Data Types
3. VBA Syntax and Expression Entry PART:1
4. VBA Syntax and Expression Entry PART:2
5. Sub Procedures
6. Sub Procedure Examples
7. Variables
8. Manage Variable Scope
9. Define Static Variables and Constants
10. Define object variables
11. Strings and Dates
12. Assignment Statements
13. Constants
14. Arrays
15. Activity: Define variables, constants, and calculations
16. SOLUTION of Activity : Define variables, constants, and calculations
17. PROJECT: Using Relative or Absolute Reference
18. ❓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 create a Function in VBA
3. How to make your own user-defined (UDF) function (Custom Functions)
4. How to convert a user-defined function to an Excel Add-In
5. Custom Function Examples
6. How to borrow functions from Excel
7. Message Box and Built-In Functions EXAMPLES
8. Using Worksheet Functions in VBA
9. ❓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. Putting it all together: Example 1
12. Putting it all together: Example 2
13. Putting it all together: Example 3
14. ❓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. Manage Errors using On Error Statements
2. Step through a Subroutine or Function
3. Set Breakpoints in your Code
4. Verify output using the Immediate Window
5. Watch a Value in a Routine
6. ❓QUIZ 9: Debugging your VBA Code
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
9. VBA Tutorial (PDF)
10. Will Office Scripts replace VBA?

About this course:

$29.99
122 lessons
10 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 you sign up, the course is yours forever. Think of it like buying an app that never expires—you can use it anytime. If you get busy, it's still there when you're ready. You can revisit lessons anytime, whether it's next week, next month, or next year. Plus, you'll get all future updates for free!
Do I need to have Excel experience to start?

You don’t need any prior business or technical knowledge. All you need is a computer with Excel and some familiarity with Excel. If you’re completely new to Excel, this may be too advanced, as we focus specifically on VBA and automation techniques.
What version of Excel do I need?

I recommend Excel 2016 or newer, or a Microsoft 365 subscription for full compatibility with the features used in this course. However, the course content will still work with older versions of Excel, as the fundamentals of VBA have not changed significantly since earlier versions.
Do you support Excel for Mac?

If you use Mac Excel, this course may not be ideal for you, as it was filmed using Windows Excel. The interface and shortcuts are sometimes different on a Mac. That said, some of our students have successfully used Mac Excel with this course. The VBA language is the same on both Windows and Mac Excel, and most lessons will work, although about 20% of the content differs.
What do I get after completing the course?

When you finish the course, you'll get a certificate of completion. You can put it on your resume or show your boss. You can even upload it to LinkedIn. Or just add it to your own personal library of learning achievements.
What if I am unhappy with the course?

I would never want you to be unhappy! If you enroll in the course and decide it’s not right for you, contact me within 30 days for a full refund. My goal is to make sure you’re excited about learning and getting the help you need to master Excel VBA.

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