VBA Masterclass:
The Best Way to Learn VBA Online (Guaranteed)

VBA is extremely hard to learn.

Why?

Because VBA is a HUGE (complicated) topic!

That’s why I created the course “VBA Masterclass”.

In VBA Masterclass you learn exactly how VBA works – in just 20 hours.

So, if you want to:

  • Work more productively on your daily VBA tasks
  • Get new and better career opportunities
  • Upgrade your professional skills

Keep reading…

Spreadsheeto's course platform

Or scroll down to read more…

Here’s what you get in “VBA Masterclass”

VBA Masterclass offers a lot.

Here are the 3 most important things about the course.

1: 20 hours of actionable VBA training

VBA Masterclass gives you access to:

128 video lessons (19 modules), 13 assignment-files, +70 project files, and 14 quizzes.

It takes you ~20 hours to complete the training.

Here’s a quick ~1-minute video of what you learn.

Below is the entire overview of VBA Masterclass’ 13 modules and 128 lessons.

  • Welcome
  • The big picture of VBA programming
  • What you learn from this course
  • How to practice: Quizzes, project files, and assignments
  • About your instructor
  • Your setup
  • Your Excel version
  • What is a macro?
  • Record a macro
  • Play a macro
  • Behind the scene of a recording
  • Edit the code
  • Quiz
  • What is VBA?
  • The VB editor
  • Write your own code – part 1: Hello, World
  • Write your own code – part 2: Something useful
  • Write your own code – part 3: Recording missing parts
  • Structure your code with comments
  • The developer tab
  • Save Excel files with macros
  • Macro security
  • Personal macros
  • Quiz
  • Assignments
  • Object-Oriented Programming
  • Using Object-Oriented Programming in VBA
  • Quiz
  • Manipulating cells – part 1
  • Manipulating cells – part 2
  • Copy and paste
  • Moving from cells
  • Sheets
  • Deleting
  • CASE: John’s Fitness – part 1
  • CASE: John’s Fitness – part 2
  • Workbooks
  • Quiz
  • Assignments
  • What are variables?
  • How to use variables in VBA
  • Declaring variables: How and why
  • Data types
  • Declaring variables: An example
  • Naming variables
  • Case: M&A Reporting Tool
  • Case: John’s Fitness
  • Quiz
  • Assignments
  • Quick recap
  • Big assignment
  • Big assignment – solution
  • What are IF statements?
  • How to use IF statements
  • AND / OR in VBA
  • ElseIf
  • Select Case
  • CASE: Reports for Project Management
  • Quiz
  • Assignments
  • What is a loop?
  • For Loop
  • Do While / Do Until
  • For Each
  • Loop within loop
  • Reverse loop
  • Quiz
  • Assignments
  • IF statements inside loops
  • CASE: Production and Proposal Tool – part 1
  • CASE: Production and Proposal Tool – part 2
  • Quiz
  • Big assignment
  • Big assignment – solution
  • Interacting with the user
  • MsgBox – Talking TO the user
  • InputBox – Talking WITH the user
  • Get the user to select files and folders
  • Send emails through Outlook from Excel
  • CASE: Time Logging Application
  • Quiz
  • Assignments
  • How to begin developing an application
  • The user
  • The MVC framework
  • CASE: John’s Cosmetics
  • Quiz
  • Make your code faster
  • Screen updating and manual calculation
  • Use fewer lines of code
  • With statements
  • Quiz
  • Assignments
  • What error handling is all about
  • On Error Resume Next
  • On Error GoTo handler
  • On Error GoTo 0
  • CASE: John’s Sports – Finances
  • Quiz
  • Assignments
  • Quick recap
  • Big assignment
  • Big assignment – solution
  • CASE: M&A Reporting Tool – Manipulating strings
  • User Defined Functions
  • Filters
  • Find and replace
  • Save as PDF
  • Running other macros from within a macro
  • Userforms
  • Your unlimited code-bank
  • Arrays – part 1
  • Arrays – part 2
  • Quiz
  • What are events?
  • Run macro when file is saved
  • Run macro when file is opened/closed
  • Run macro when something changes
  • CASE: Reports for Project Management
  • Quiz
  • Assignments
  • Build an application that joins data
  • A brief summary
  • What to do now?

This was a very well thought out approach to VBA training. The curriculum flows very well through all of the training modules. Kasper keeps the information moving which keeps you engaged. I would highly recommend this training if you have any interest in learning how to write VBA code in Excel.

Steven Gustafson

2: Quick support to answer your questions within 24 hours

If you become a student of VBA Masterclass, we view it as the beginning of getting to know you.

As a VBA Masterclass, you have first priority in my inbox.

That means I answer all your questions within 24 hours.

I have found this training to be far superior to any other that is on the market. Spreadsheeto responds to emailed questions – within 24 hours. Spreadsheeto is always available to assist with any challenges that you may encounter.

Patrick O'Connell
Quick email support

2: Quick support to answer your questions within 24 hours

Quick email support

If you become a student of VBA Masterclass, we view it as the beginning of getting to know you.

As a VBA Masterclass, you have first priority in my inbox.

That means I answer all your questions within 24 hours.

I have found this training to be far superior to any other that is on the market. Spreadsheeto responds to emailed questions – within 24 hours. Spreadsheeto is always available to assist with any challenges that you may encounter.

Patrick O'Connell

3: 13 assignment-files and +70 project files

See how an assignment-file works.

I don’t want you to just see the lessons or look at the assignments.

I want you to do what I show you.

Imitation and repetition are the keys to accelerated learning.

That’s why I’ve included 13 assignment-files and 100s of project files for you.

This training is presented very well using great videos and excellent practice sheets. The testing is really comprehensive and also fun! I can’t wait to start on the next module!

Ken Hostetler

3: 13 assignment-files and +70 project files

See how an assignment-file works.

I don’t want you to just see the lessons or look at the assignments.

I want you to do what I show you.

Imitation and repetition are the keys to accelerated learning.

That’s why I’ve included 13 assignment-files and 100s of project files for you.

This training is presented very well using great videos and excellent practice sheets. The testing is really comprehensive and also fun! I can’t wait to start on the next module!

Ken Hostetler

“Write code within a day”

Meet VBA Masterclass student, Joshua Bienenfeld, of Regent Consulting Services.

In the video, Joshua explains how he started to write his first code on the first day of starting on VBA Masterclass.

The result? Joshua is now “saving hours and hours and hours” (go, Joshua!) 🙂

It’s not just Joshua who’s doing fantastic.

Check out what Scott Swist, product manager at HP, thinks…

 “I seriously recommend this course!”

This is by far the best software training course I’ve experienced, even compared to classroom training. Everything is explained so simply. There are things that have been mysteries to me for years, and in a two-minute video, all is revealed. The practice exercises are an invaluable piece of how you learn. Working through hands-on problems complements the watching and listening so that all senses are involved. As a former teacher and trainer myself, I know that this is the best way to reinforce learning. I highly recommend this course. Even if you’re a total novice and non-technical, you really can master this material.

Marcy Serkin
I tried many tutorials and this was the only training I was really able to absorb. By far this is the best training on the internet.
Linda Byrne

I like your training, it’s very easy to follow and I have learned a lot. I am so grateful that I have the chance to learn from Spreadsheeto.

Linda Sun

Want to become a VBA Masterclass student?

Awesome, here’s how VBA Masterclass works…

How VBA Masterclass works

Zero to Hero pricing

1: Enroll and get instant access

Everything is 100% online and immediately available.

Access the training from any device and all locations.

The training opened up a world of options for me to automate repetitive daily tasks. The training saves me a lot of time in my working day.

Dwayne Cadwallader

2: Stuck? Get help in 24 hours!

If a question comes up, send us an email.

We’ll get you unstuck in less than 24 hours.

You can contact Kasper when you have a problem. He gets back with you and is so helpful. There is no way you can’t improve your Excel skill level if you take the lessons and do the assignments. The course is so well worth it.

Diane D'Avanzo
Support
Zero to Hero module overview

3: Complete the course and get your certificate

Right after completing VBA Masterclass, your certificate unlocks.

Because you get lifetime access, you can go back and rewatch any lesson you like.

Excellent training! Clear, concise, simple to follow – 5 stars!

Tom Burton

How VBA Masterclass works

1: Enroll and get instant access

Everything is 100% online and immediately available.

Access the training from any device and all locations.

The training opened up a world of options for me to automate repetitive daily tasks. The training saves me a lot of time in my working day.

Dwayne Cadwallader
Zero to Hero pricing

2: Stuck? Get help in 24 hours!

If a question comes up, send us an email.

We’ll get you unstuck in less than 24 hours.

You can contact Kasper when you have a problem. He gets back with you and is so helpful. There is no way you can’t improve your Excel skill level if you take the lessons and do the assignments. The course is so well worth it.

Diane D'Avanzo
Support

3: Complete the course and get your certificate

Right after completing VBA Masterclass, your certificate unlocks.

Because you get lifetime access, you can go back and rewatch any lesson you like.

Excellent training! Clear, concise, simple to follow – 5 stars!

Tom Burton
Zero to Hero module overview

Get Instant Access to VBA Masterclass

POPULAR
All-in
$299
  • 20 hours of training
  • Assignments, project files, and quizzes
  • 30 days support
  • Certificate
Premium
$699
  • 20 hours of training
  • Assignments, project files, and quizzes
  • Unlimited support
  • Certificate
  • 2x30 minute coaching-call (value $199)
  • Zero to Hero included (value $199)

Finished module one and already rearing to go for the next. Had tried dummy series and YouTube but this course is the best hands on training anyone can dream of. 

Samit Ghosal

30-day double-your-money-back guarantee

If you put in the work but don’t feel like you’re making progress, it’s our fault – not yours.

We stand by this course with a 30-day double-your-money-back guarantee.

Try the entire training and decide if it’s right for you.

If you have taken action and are still unsatisfied, we will pay you back DOUBLE what you paid.

Kasper Langmann, Excel expert and instructor (left). Mikkel Sciegienny, communications. Founders of Spreadsheeto.

I am so glad I signed up for your training!

Mary E. Norris