Does it feel like your life is confined to the cells in Excel? Here is how I could breakfree and why I learned VBA
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.
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.
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!
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.
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!
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
This module gets you started with the VBA learning. It covers:
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.
MODULE 3: LOOP Statements in VBA
In this module, you'll learn all about using Loops in Excel VBA
MODULE 4: Advanced Excel VBA Elements
In this module, you'll deep dive into some advanced VBA concepts:
MODULE 5: Practical Examples
In this module, you'll see some practical examples to apply the concepts you have learned so far:
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.
BONUS MODULE: Looking Outside of Excel
In this bonus module, you'll learn how to work with other applications 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.