Join the Online Excel VBA JETPACK Course

Does it feel like your life is confined to the cells in Excel?  Here is how I could breakfree and why I learned VBA

Excel VBA is for you if:

  • hand-o-right
    ​You want to automate common tasks so that these can be done by others with a click of a button
    You want to automate common tasks so that these can be done by others with a click of a button
  • hand-o-right
    ​You regularly refresh reports/dashboards - and it eats up a lot of your time
    You regularly refresh reports/dashboards - and it eats up a lot of your time
  • hand-o-right
    You want to acquire an in-demand skill that will supercharge your career growth
    You want to acquire an in-demand skill that will supercharge your career growth

INTRODUCING THE EXCEL VBA COURSE

VBA is an easy-to-learn Excel back-end language that has saved time & energy for many data warriors! Excel VBA course is a power-packed, self-paced course that will start benefiting you right away. It is full of practical examples and has already helped 300+ students.

Did You Know?

Repetitive tasks are costing you a lot of money


Whenever you spend time on tasks such as data formatting, data cleaning, copy-pasting, or creating summaries/charts/pivot tables - YOU LOSE MONEY!

Let me put this in perspective.

Assuming you spend an average of 30 minutes a day doing these repetitive tasks, that sums up to 100 hours in a year (considering 200 working days in a year).

Considering your time is worth $20 an hour (a very conservative estimate), that’s $2000 worth of your time WASTED every year.

​It doesn't have to be this way!

In this Excel VBA course, you can learn how to get rid of these boring repetitive tasks so that you can focus on things that really matter.

Your VBA course is fabulous. I have listened to your videos twice up to Assignment 1. Since starting, I've improved my thinking about VBA coding. I have written some custom code for my work. I felt powerful and I'm only at Assignment 1.

Your course is SO AWESOME!!! I can't wait to get to the end.

Elizabeth R
United States

VBA - The Crazy Time Saving Machine

Automate Once - Reuse Forever


In my last job as a Financial Analyst, I was THE Excel guy. My work included creating dashboards and reports that were used by high-level executives to make decisions.

I loved it, but it also drove me crazy that I was spending a major chunk of my time cleaning and copy pasting data before I could use it for any meaningful analysis.

And then, as I started learning VBA, I was able to automate these tasks.

As a result, I was spending a fraction of my time on these not-so-important tasks and could focus on improving the Dashboards and Reports. That benefitted me (a promotion, salary hike, client appreciations) as well as my company.

Before I knew it, I was creating macros and applications for my team as well as the other teams that led to savings of hundreds of thousands of dollars worth of man hours.

I have seen the power of VBA and that’s why I call it - The Crazy Time Saving Machine.

Apart from the benefit of saving time, VBA is also one of the highly coveted skills in the job market. Once you have it, you’re better suited for all the goodness in life - be it for a better rating, a quick promotion, a good increment, and a lot of appreciation from your clients and bosses.

I am going through your VBA course and it's super helpful.

Despite being a beginner, I am totally following the videos and I've already started automating some of the things I have to do daily. Now I am getting a lot more done in less time. Thank You!

Garima Pareek
India

MEET THE INSTRUCTOR

I am Sumit Bansal, your VBA instructor for this course. I have been an Excel trainer for 10 years now and have been honored with the Microsoft Excel MVP status for my expertise in Excel.

Sumit Bansal Excel MVP Trump Excel

When I started learning VBA on my own, I had to take the long and painful route.

I relied on big boring books, random blog articles, and Microsoft Help (arghhh!). It involved a lot of trial and error which made the learning experience difficult and less fruitful.

Drawing from my experience, in the Excel VBA course, I have made sure you get to learn everything in a structured way without getting overwhelmed.

I focus on making VBA learning easy for you.

In this course, I wouldn't overwhelm you by teaching everything under the sun. Rather I will teach you the best ways to get stuff done.

The lessons are designed in a way that you can start implementing these from Day 1 and see the benefits instantly.

Hey Sumit - I like this course as I am not getting bogged down in the theory - just the practical application. I'm enjoying it and it's getting my VBA juices flowing again!

Michael Diamond
United States

Here's What's Included

This Excel VBA course is a 100% online video course where you get access to all the lessons and example files as soon as you register. The lessons are short and full of practical examples that will help you apply these in your work from Day 1 itself.

The course is packed into 7 modules that will take you from a beginner level and make you an advanced VBA user

MODULE 1: Excel VBA Introduction & Basics

Excel VBA Training - Introduction

This module gets you started with the VBA learning. It covers:

  • Introduction to VBA Language and the VB Editor
  • Recording/Decoding Macros in Excel
  • Running Macros in Excel
  • Writing Your First VBA Code
  • Understanding Errors in VBA

MODULE 2: Excel VBA Nuts & Bolts

Once you have a good understanding of VBA, VB Editor, and recording/running macros, this module will expose you to the building blocks.

  • Working with Cells and Ranges using VBA
  • Working with Worksheets/Workbooks using VBA
  • Using Variables in VBA
  • Using Object Variables in VBA
  • Using Message Boxes in VBA
Excel VBA Course - Nuts & Bolts

MODULE 3: LOOP Statements in VBA

Excel VBA Training - Looping

In this module, you'll learn all about using Loops in Excel VBA

  • With Statement Loop
  • If Then Else Loop
  • Select Case Loop
  • Do While/Until Loop
  • For Next Loop
  • For Each Loop

MODULE 4: Advanced Excel VBA Elements

In this module, you'll deep dive into some advanced VBA concepts:

  • Creating Custom Functions in VBA
  • Error Error Everywhere - How to Handle it
  • Using Event Procedures to run macros
  • Userform - Basics + Deep Dive
  • Using Array in VBA
  • Working with Charts using VBA
Advanced VBA Module _ Excel VBA Training

MODULE 5: Practical Examples

Excel VB Training - Practical Examples

In this module, you'll see some practical examples to apply the concepts you have learned so far:

  • Show and Hide Elements using VBA
  • Update Charts/Dashboards with a Single Click
  • Creating Mouse Rollover Effect using VBA
  • Creating Chart Animations using VBA

MODULE 6: Creating Add-ins and Applications

In this module, you'll learn how to create Add-ins and Applications using Excel VBA. These add-ins/applications can easily be shared with your colleagues and clients so you don't have to do the same thing over and over again for them.

  • Creating Add-ins using VBA
  • Creating an Application using VBA
introduction-to-vba-module-image

BONUS MODULE: Looking Outside of Excel

Bonus Module Excel Course

In this bonus module, you'll learn how to work with other applications using VBA:

  • Working with Files and Folders
  • Generating Word Reports using VBA
  • Generating PDF Reports using VBA

Assignments + Solutions

A course wouldn't be complete without some assignments.

There are three video assignments in this course in three different modules. Each assignment is based on the concepts you have covered in that module.

Once you have attempted the assignment, you can go through the solution video where you'll learn how to solve a given problem.

Online Excel VBA Course - Assignment and Solutions