Excel 2019 VBA Full Course Tutorial (7+ Hours)

Excel 2019 VBA Full Course Tutorial (7+ Hours)

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.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
VBA Overview/Getting Started 2:06
Procedures and Functions 1:06:26
Expressions, Variables, and Intrinsic Functions 2:12:27
Controlling Program Execution 3:28:45
Forms and Controls 4:40:59
Pivot Tables in VBA 5:27:53
Code Debugging 6:22:25

#excel #exceltutorial #exceltips #vba #excelvba

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

[polariszsy]

You are amazing. This session is better than any other books or Tutorial I have seen!

[lexodus]

This tutorial is honestly great, I haven't seen such an in-depth tutorial on Visual Basic in Excel and it really helped me, even while I was a bit known with Visual Basic for making Applications

[SalmanKhan-vngy]

This is an amazing instructor, with very clear, creative content. Thank you 💖

[RD-wniw]

I have watched the first 1.5hrs. Really informative ans easy to follow. Well done. Thank you.

[ferozkabir]

Thanks for the long video. This is very much effective in learning VBA. However, in creating Form and PivotTable part, it could have been better. Visualizing what the codes will produce while writing those in VBE was difficult. It would have been better if the outcome was shown at the beginning, rather than coding first and getting the output last. Thanks again for this nice informative video.

[azizurrehman]

this very helpfull content on youtube especially i didn't see content like this because whenever i see content like this they are demanding charges thank you so

[kebincui]

Very clear presentation and pleasant voice, excellent presenter 👍👍🌹🌹

[UsmanGhani-vfow]

Thank you very much, U'r super teacher because u made it easy and simple

[milotxh]

thank u so much you giving something very valuble for free god bless you

[Zpinoza]

Yes, thank you very much for making a instruction video that makes me actually stay to the end.

[cordeggers]

Very good course! But:
1) One Error: Dim a, b as String gives a the type Variant, not String!
2) The indentation technique is sometimes strange.

[c.e.bingham]

Wow! This a great presentation. Comprehensive and easy to follow along. The presenter does an excellent job explaining concepts in an easy to understand manner.

[yanweideng]

This is a very detailed and helpful course. Thank you very much! I am not able to find the slides in the course description, could you share a link to downloading the slides?

[LGDOW]

Hey! The link for the exercise files is not working, could you provide a new link, please?

Edit: Made the link work, but I cant access the share point, I receive the error: "Selected user account does not exist in tenant 'Learn It, Inc' and cannot access the application in that tenant. The account needs to be added as an external user in the tenant first. Please use a different account."

[mitchelltsui]

Woah this is fresh! I just finished the 3 parts of VBA and this comes right on time. Thank you very much

[petardzopalic]

Can you please explain if I add more vehilices in Received Vehicles.xlsx file, how to add more of these vehicles in the New Vehicles sheet in file Vehicles.xlsm? It copy only till the 11 row, what if I have more then eleven rows and not manualy to correct code.

[StaticBlaster]

5:14 Yep that's idea of encapsulation in C++ i.e., manipulating the member variables via the public methods and functions. In fact, modifying the member variables directly is dangerous. You never want to program software such that a user can directly access the variables. It could cause severe errors and the entire system to crash.

[mahlonkalunga]

I cannot find the slides used in the video.

[habibb]

Google sheets has approximately 2 billion users, while excel has only 750 million. When do you intend to produce more videos for google sheets?

[piansticpeng_in]

For the first exercise GetNewVehicles, I tried to copy and paste the values as instructed, but after saving the macro and running it, it opens the Received vehicles file and asks me if I want to save this copy of the file, then after I click ok, the macro continues to run but nothing is pasted. I use MacOS. Would like some help.