Excel VBA Beginner Tutorial

Excel VBA Beginner Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel.

What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel.

What you'll learn: In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions.

For ad free training and certificates please join Learnit Anytime:

Enroll in our live, instructor-led Excel VBA class:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:03
What is VBA? 1:44
Object Oriented Programming Languages 5:59
Turning on the Developer Tab 10:17
The Macro Recorder 13:40
Using Relative References 20:39
Recording Simple Macros 27:51
Multi-Step Macro Recording 39:25
Sort and Filter Macro Recording 45:26
Protecting and Formatting Sheets with the Macro Recorder 51:35
VBA Interface Setup 55:09
Recorder Code vs. Manual Code 1:01:11
Introduction to Editing Macros 1:12:28
Debugging Macros 1:16:53
Grammar in VBA 1:28:00
Macro Scripting Basics 1:33:04
Range 1:40:41
Selection & Color 1:47:14
Value and Clear 1:52:16
ActiveSheet, Sheets, and Name 1:54:01
CurrentRegion 1:56:40
Practice 1:58:08

#ExcelVBA

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[LearnitTraining]

The link to the exercise files is in the video description

[RedDogByrd]

I'm a 79 year old retired software developer who has taken many classes and courses over the years. This lady, bar none, has done one of the best teaching jobs I have ever experienced. Congratulations on an outstanding performance!

[paristmo]

No music and overly excited speech, just direct and straight-to-the-point detailed guidance; all tutorial should be like this.

[ecashmarketing]

I am jobless and learning VBA for a job interview. Just want to thank you for your service.

[bronteparker]

This class was truly amazing! It was so easy to follow along with the exercises due to the instructor always verbalizing what she was doing (typing, clicking on, ect.), allowing me to look at my excel sheet and complete the steps simultaneously. I went from not knowing what VBA/Macros were at all to feeling like I can say I have a beginner level understanding. Thank you Learnit!

[vijayendrashenoypadav]

This was a brilliant 2+ hour of session! Clear communication, organised content and specific information. I am glad I came across this. My Sunday well spent learning something great.

[Pioneer_Inspire_Empower]

Chelsea, your tutorials are quite simply outstanding. Your preparation and delivery of the content is superb!

[alexinivai]

This has got to be the best beginner's course I've had. Well-made, easy to comprehend. Please never stop creating content.

[SteelStrung]

You did a great job breaking down and making easy to understand something that can be pretty daunting for most people who haven't worked with macros before. I had a lot of trouble trying to share my knowledge/train others on VBA and this video was easy to understand and well organized. Thanks!

[lesnyk]

I taught myself some VBA by back-engineering macros I'd recorded, but there's SOOO much more to it that I've never understood. I'm 25 minutes into this and I've already learned several tricks that will make life easier! Taking a break now, but I will be back for more. This is a godsend.

[patricdaniel]

I wanted to learn VBA for the last so many years. Finally found what I was looking for. Excellent presentation and oh ! the audio -the great motivator :). Thank you.

[ranjitjojo]

I have seen so many videos on VBA... but this one is the no jass... no unwanted irritating music.... straight to the point.... thanks a ton to the trainer...

[griffinmaree]

Few people nowdays truely understand how to teach. You clearly have empathy for your audience and understand their perspective. This is a really well put together tutorial.

[JamesGirardi]

90% of my YouTube watching are tutorial videos. This one tops them all when it comes to explaining it, examples, variations, testing, etc. And yes, the audio was pleasant too :)

[ahmedamr]

This tutorial is by far one of the best tutorials ever, the methodology is very good, even if used with any other topic especially programming.
Instead of spending 10+ lessons learning how to print silly message on the screen and doing loops and conditional formatting, you start doing some useful examples and get your hands on with real, yet simple scenarios.
I would really recommend your channel for anyone who want to learn anything, not just Excel.
Please it going :)

[MidoCounters]

I'm barely an hour in and it's already changing the way I'll work from now on. Love the tutorial! Everything is explained beautifully and easy to follow through and understand.

[MotoMadV]

I've only just started listening to this (earphones) and the presentation in terms of audio is fully engaging and exciting. You will have me for over 2 hours

[maldighaithir]

Ok, I got to say this, the instructor is doing a fantastic job explaining the basics, but what i have to say is, she has a marvelously soothing voice that can be heard for hours XD

[sridharsockalingam]

This course was the best among several I tried out recently. It assumes that you do not know anything or very little about Macros and VBA and walks you thru them step by step. Absolutely great teaching method. Very well paced and with clear explanations and examples. The downloadable files make it so easy to practice as well. Thank you for the excellent course!!

[dixiwu]

so happy to find a tutorial with a female teacher. all my IT teachers are male, online and offline. A big step for female power. big support