Loading...
VBA Masterclass2018-12-11T15:09:38+00:00

Learning VBA was hard.
So, I created ‘VBA Masterclass‘!


VBA is a HUGE topic.

Where to start?

Where do you end?

What should you focus on – and what should you leave out?

Truth is, learning VBA is hard… because there is was no plan for you to follow!

And that’s why I created ‘VBA Masterclass’ 🙂

VBA Masterclass is your guaranteed way to become a VBA professional.

Say goodbye to piecing together information from all around the web and hello to the ultimate VBA blueprint.

VBA Masterclass is the result of 4 months intense development, 7 years professional Excel experience, and teaching +50,000 students.

– The 3 Pillars of VBA Masterclass –

VBA Masterclass is built upon 3 foundational principles (which we’ll look more into in a minute):

1: Actionable real-life training. Learn today, execute tomorrow.

2: High-level support and feedback. Get inbox access to a VBA professional.

3: Interactive Skill-Assignments. Download the included assignments and practice to make your new skills stick.

VBA Masterclass and these pillars are created by Spreadsheeto’s instructor and co-founder, Kasper Langmann.

Let’s say ‘Hi‘ to Kasper!

Meet your instructor: Co-founder and Microsoft Office Specialist

Kasper Langmann co-founder and Excel expert

Hi there, my name is Kasper Langmann!

I’m the co-founder of Spreadsheeto and your instructor in VBA Masterclass 🙂

I’m also a certified Microsoft Office Specialist (MOS).

Before focusing 100% on teaching Excel and VBA, I worked as an Excel-consultant.

This gave me invaluable insight into how systems and processes operate throughout organizations. Most importantly, it showed me how VBA fit in all this.

I believe anyone can become a VBA professional by following the right blueprint.

Yes, VBA can be overwhelming, frustrating, and difficult…

…But, having worked with Excel and VBA for the past 7 years (and taught Excel to +50,000 students) I know you too can master VBA!

Let’s take a closer look at the 3 Pillars of VBA Masterclass…

Pillar #1: Actionable Real-Life Training

Practice trumps theory. That’s why, in VBA Masterclass, we blend theory into practical teaching.

You get access to 128 video lessons, 13 assignment-files, +70 project files, and 14 quizzes.

It takes you ~20 hours to complete the training.

Watch the 1-minute below and get a behind-the-scenes look at how our training works.

“What modules and lessons do I get access to?”

Below is the complete overview of all VBA Masterclass’ contents.

  • 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?

Pillar #2: High-level support and feedback

Most other training companies collect your money and leave you alone. We’re the complete opposite!

Right now, there’s no way to hire me as a consultant (even though I get requests every week).

But as a VBA Masterclass student, you get direct access to me for 60 days! 

So, if you have any questions about VBA, the course material, or other Excel-matters, write me an email and I’ll get back to you within 24 hours.

Sometimes, all we need is a friendly reminder to get the ball rolling.

Pillar #3: Interactive Skill-Assignments

I don’t want you to sit back and see the lessons or glance at the assignments. Why?

Because you remember the training much better if you do what I show.

I’ve included 13 interactive skill-assignments. These make you convert what you learn into action.

These are included throughout the training, always tailored to your current skill level.

Assignments aren’t supposed to confirm what you’ve just learned throughout a few lessons.

Assignments are supposed to stretch your capabilities and make your skills stick.

The included assignments do just that!

Watch the quick video below to see exactly how an assignment works.

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

 Becoming a VBA pro impacts you and your bottom-line! 

I’ve always been convinced that learning VBA is the “final frontier” for any Excel-user.

But exactly how valuable is it?

Let’s look at some numbers!

According to Payscale, a Financial Analyst has a median annual income of $58,000.

A financial analyst is a great example of an Excel superuser.

Let’s compare the Financial Analyst to a VBA developer:

Excel VBA Developer (United States)
PayScale

That’s a $34,000 salary increase!

Financial Analyst: (Excel superuser)

Annual salary: $58,000/year

VBA Developer:

Annual salary: $92,000/year

Obviously, becoming a VBA developer takes time and years of experience.

But it goes to show how valuable a skill VBA is 🙂

Let’s see how learning Excel and VBA has improved the lives of our students!

 “Write code within a day” 

With more than 50,000 students, 300,000 plays, and 4 million visitors, I’ve been blessed to hear the most fantastic stories from our students.

Some received a pay raise, others got promoted, and some found the job of their dreams.

Learning Excel (in particular VBA) has a real-world impact on your job and life.

Below is a testimonial from our VBA Masterclass student Joshua Bienenfeld of Regent Consulting Services.

In it, he explains how he started to write his first code within a day – and is now “saving hours and hours and hours” (go, Joshua!) 🙂

It’s not just Joshua who’s killing it 🙂

Check out what Scott Swist has to say…

 “I seriously recommend this course!” – Scott, Product Manager, HP

Here are a few more of our (awesome) students:

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 Excel from Spreadsheeto. The training is excellent. I will let my friends know about Spreadsheeto when they need to learn Excel.
Linda Sun
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

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

We’re proud to have students from the most ambitious organizations in the world

Spreadsheeto students

Get instant access to ‘VBA Masterclass’ and become a VBA pro!

Super-Saver
$249
  • Lifetime access.
  • 10 hours of online training.
  • No support.
  • No assignment-files.
  • No certificate.
  • No guarantee.
All-in (most popular!)
$299
  • Lifetime access. Pay once, get access forever.
  • 20 hours of online training.
  • 30 days of unlimited email support.
  • 13 assignment-files.
  • Certificate of completion.
  • 30-day double-your-money-back guarantee.
Premium
$699
  • Lifetime access. Pay once, get access forever.
  • 20 hours of online training.
  • Unlimited email support.
  • 13 assignment-files.
  • Certificate of completion.
  • 2x30 minute Skype coaching (value $320).
  • Zero to Hero included (value $199).
  • 30-day double-your-money-back guarantee.

*All pricing in USD

Looking for a Team Solution?

Become a VBA Professional…
or DoubleYourMoneyBack!

Try VBA Masterclass 100% at my risk.

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

If you complete VBA Masterclass and don’t feel like you’re dressed to take on every challenge with VBA, I’ve failed.

That’s why I’ll pay you back DOUBLE what you paid if that should happen.

We have extensively tested the training.

We even had beta-tester go through the training, to make sure everything made sense. I know the training works.

So, try the entire training and decide if it’s right for you.

However — and this is important — this course is not simply to consume information. It’s designed for you to take action.

If you have taken action, but still are unsatisfied, I will refund you double what you paid.

Kasper Langmann, Excel expert (left). Mikkel Sciegienny, website and communication. Founders of Spreadsheeto.

On the fence?
Let’s look at 3 other ways to become a VBA pro

Not sure whether VBA Masterclass is worth it?

Let’s look at 3 alternatives to our training.

#1: Do it yourself

Another way of trying to become a VBA professional is to do it all by yourself.

For this, you need to browse the world wide web for thousands of articles and guides to do certain tasks within VBA.

This is the approach I took as there was no VBA Masterclass back then. It took me 7 years to go from Excel zero to VBA Professional.

The biggest challenge is that reading random tutorials on VBA gives you knowledge without context.
You’ll follow a blind path, without being able to see the bigger picture. That means you learn something, without getting smarter.

But yes, it can be done this way. But if you want to shave off years of VBA’s steep learning curve, you need to follow a plan (like VBA Masterclass).

#2: Buy a physical classroom course

Receiving classroom training equal to VBA Masterclass costs you ~$3,000.

Besides the high-ticket price, there’s another thing to take into consideration:

You’re going to forget most of what you’ve learned.

Experts estimate you remember 20% of a simple 20 slide PowerPoint-presentation.

Imagine how little you’re going to remember from an advanced VBA presentation?!

As VBA is a game of details, being able to review what you learn is crucial.

So, if you go with this option instead, make sure to take tons of notes!

#3: Hire a VBA professional to teach you

Your third option is to hire a VBA professional to teach you.

This will cost you at least $200 times 20 hours = $4,000!

Like with classroom training, it’s hard to remember every detail of what you learn. So, when you forget how to do a reverse for loop, you’re on your own 🙁

The WORST decision

I don’t want you to view this as an option.
But let’s be realistic for a minute… another thing you might do is quit.

I would hate if you did that!

Please pick any other option whether that’s VBA Masterclass or any of the 3 solutions above.

Why?

Because learning VBA is so useful for you and your career, your organization, and future.

As I showed you earlier, VBA Developers receive an average annual salary of $90,000. Let’s say you receive a generous $70k.

That’s a $30k increase!

So, if you decide to not learn VBA, you’re basically losing out on $20k/year.

Don’t let this happen, it is not that hard to become a VBA pro!

Common Questions

You’re also very welcome to contact us right here.

Is VBA Masterclass for Windows or Mac?

VBA Masterclass is recorded in Excel 2016 on Windows. If you have Excel 2010 (or later) for Windows, you’re ready to get started.

If you’re on a Mac, make sure to get the latest version of Excel for Mac (2016). This version is very affordable with an Office 365 subscription. Once you have the latest version for Mac, you’re good to go 🙂

How long does it take to complete VBA Masterclass?

If you decide to enroll, you get instant access to everything.

It’s up to you, how quick, or slow, you want to go.

You can also always go back and revisit any lesson you like. You get lifetime access to the training.

But to give you an idea: Set aside 10 hours to watch the lessons and another 10 hours to do the assignments and quizzes.

Expect ~20 hours in total.

What topics will I learn? Can I view the curriculum?

Absolutely, scroll up to “Pillar 1” and you can see the exact contents of VBA Masterclass.

Is $299 worth it?

Let me flip the question:

It took me 7 years to go from Excel zero to VBA professional. With VBA Masterclass I could’ve achieved the same skills in about 1 month.

Is it $299 worth to shave off 7 years of (struggling) to learn VBA? I’d done it in a heartbeat!

Classroom training or hiring a teacher is going to cost anywhere between $3,000 and $4,000.

VBA Masterclass is designed to be in that sweet spot: Shaving years off the steep VBA learning curve while remaining affordable.

Who’s the instructor? And why should I listen to him?

Your instructor is Spreadsheeto co-founder, Kasper Langmann. Kasper is a certified Microsoft Office Specialist.

Kasper has also worked as an Excel consultant, giving him invaluable experience in the world of Excel.

Unlike other online instructors, Kasper is creating Excel training full-time. Our training, VBA Masterclass included, isn’t created as a second-priority. Excel training is what we do, 100% of the time.

If you like to read more about Kasper, scroll up.

What if I’m unsatisfied? Do I get a refund?

VBA Masterclass is backed by our 30-day double-your-money-back guarantee.

Try out the full training for 30 days and decide if it’s something for you.

If you’re unsatisfied (I’m sure you won’t be), I will pay you back DOUBLE what you’ve paid.

That’s how certain I am you’re going to love VBA Masterclass 🙂

How do I receive the training? Is it online?

VBA Masterclass is 100% online. Right after you’ve enrolled, you’re asked to create a user to access our training platform where VBA Masterclass is waiting for you.

You get instant access to all content of VBA Masterclass, that is: 128 video lessons, 13 assignment-files, +70 project files, and 14 quizzes.

How fast, or slow, you want to go is completely up to you!

Why should I pick Spreadsheeto instead of Lynda? Or Udemy?

If you’re asking this question, go to the top of this page and read all the way through.

In short: you get access to the highest-quality and most cared for VBA training on the planet.

You get access to a Microsoft Office Specialist who answers all your questions in 24 hours (or less).

Included in the training is also assignments, specifically designed to make your new VBA skills stick.

And on and on and on…

To me, it’s like comparing a Fiat to a Ferrari.

Can they both drive you from a to b? Sure!

But what is the most fun, high-quality, and fastest?

Once you enroll in VBA Masterclass, you’ll see that this is the Ferrari 🙂

Where do I find the Terms & Conditions?

You find our super simple Terms and Conditions right here.