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

About this course

  • $9.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

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