Finally! A Foolproof Method for learning Excel Macros

Even if all your previous attempts have failed, your time is limited and Macros look like a foreign language to you

If you are a user of Microsoft Excel then you've SURELY at least considered the possibility of adding VBA Macros to your skillset by now. 

Maybe you have made some attempts and found it a frustrating experience. Maybe some or all of the following sounds familiar to you

  • You use Google for every single line of code
  • You have wasted lots of time looking at random blogs or YouTube videos
  • You have spent money on courses or books but found they didn’t teach you what you needed
  • You feel overwhelmed at the very thought of starting a VBA project
  • You find using VBA a process a slow and frustrating experience

Surely there must be a better way to learn Excel VBA! 

What if there was a proper step-by-step, paint-by-numbers guide to learning VBA?

If you were learning a language like French you would approach it in a structured step-by-step manner. You would do a lot of practice . You would reinforce your learning with exercises, assignments, quizzes and other activities.

This is how you learn most new skills such as speaking a language, playing a musical instrument or driving a car.

This is why the Duolingo language app became a smash hit. It teaches languages in  a step-by-step manner using practical exercises.

Yet, most books or courses try to teach VBA by simply dishing out information without providing any exercises or assignments. Yes, these are vital tools for learning any new skill.

Sure, some have activities but these are always very basic and are not much help when you need to create your own real-world applications.

Hi, I'm Paul Kelly founder of

I created the Excel Macro Mastery website because I know that learning VBA can be frustrating.

Trying to do it all yourself can be difficult.

Sure, maybe you can do it. But you'll probably  waste a lot of time and effort doing the wrongs things.

Having Someone Show You the Way Can Save You Countless Wasted Hours

When I started with VBA many years ago I made plenty of mistakes.

For example, when copying data I would use Select, Copy and Paste. I didn't realise that this was a really slow and inefficient way to use VBA.

I wasted countless hours on applications because of the time they took to run. I would sit waiting for it to finish so I could move onto the next task. I was blissfully unaware that there was a much faster approach.

One day when I was looking up something else I stumbled upon an article that mentioned much faster ways to copy data using VBA.

Knowing this in advance would have saved me countless hours - and not only in the time it took the code to run. I also ended up having to completely rewrite the application to use the newer method.

This is the problem with the standard ways of teaching VBA. It does not include the practicalities of the real-world. It leaves it up to the user to discover for themselves.

That is why I decided to create a completely new way to teach VBA

The entire focus of this method is to create a step-by-step paint-by-numbers guide that will provide you with real-world VBA skills. These skills will:

  • make you more valuable in your current position
  • help you  secure a higher paying and better job
  •  automate boring repetitive work and allow you to spend your valuable time on more important tasks
  • make your colleagues envious as they watch in amazement as you write proper VBA Code

So what is this  New Method of teaching VBA?


The  Excel VBA Beginners Course


  1. Automate Excel: Learn the essentials of writing practical real-world VBA Code.
  2. Practical Learning: Reinforce your learning with 42 excercises plus end of chapter assignments and quizzes. Master Excel VBA by doing.
  3. Suitable for Beginners: No VBA or programming experience is required. 
  4. Clear Explanations: Everything explained using easy to undertand language - no jargon included. 
  5. Tons of Examples: 80+ easy to follow coding examples with 20+ video demonstrations.

What People Are Saying About This Course

John OvensFinancial Analyst                 

Paul, absolutely fantastic. A great building block to start with – I am looking forward to later tutorials.

This is what most people are looking forward to learn while practice. Hope to see more practical base in later tutorial by you. Hats off sir !!!

Pradeep Majh
Business Analyst
Ray WalmerRetiree                 

Very pleased with how clearly you simplify a very complicated subject. thanks for “Dumbing it down” for us old folks.

 Course Contents 

  • tutorial 1

  • Tutorial 2

  • tutorial 3

  • tutorial 4

Mastering the Basics

What you will be able to do when you complete this tutorial:

  • Create a module.
  • Create a sub.
  • Understand the difference between a module and sub.
  • Run the code in a sub.
  • Write a value to a cell.
  • Copy a value from one cell to another.
  • Copy values from one range of cells to another.
  • Copy values between difference worksheets.
  • Test your output using the Immediate Window.
  • Write code faster using the With Statement.
  • Create and use variables.
  • Copy from a cell to a variable and vice versa.
  • Frequently Asked Questions

    Can I try it  for free?

    I have tried to Learn VBA before and failed. Will this work for me?

    What if I'm a complete beginner?

    What if I don't have much time?

    How are your tutorials different for those out there?

    I'm not a beginner, is this for me?

    Is this a complete course on Excel VBA.


    Think about it this way: How long have you been wanting to get to that next level? One year? Five? Even longer? Ouch.

    Meanwhile, other people are very successfully using VBA. Who are they? How did they do it? What do they know that you don’t? When you’re a VBA Vault member, you’ll find out.

    So here’s the thing to ask yourself right now…How much longer do you want to keep getting the same results you’ve been getting?

    Only you can answer that. If you’re ready to shake things up and gain momentum, I want to help. But YOU have to make the choice–and you can take the first step right now.