Excel VBA Expert Tutorial

Excel VBA Expert 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 classes:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Worksheets Methods 0:03
DateSerial and Format 3:28
Sheet Template Generator 13:32
Move 20:21
PrintOut and PrintPreview 23:40
Practice (Part 1) 25:51
Practice (Part 2) 34:20
Practice (Part 3) 35:54
Practice (Part 4) 37:38
Practice (Part 5) 41:11
Practice (Part 6) 51:48
Custom Functions (Part 1) 54:18
Custom Functions (Part 2) 1:01:01
Custom Functions (Part 3) 1:04:32
Wrapping Up 1:14:07

#ExcelVBA

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

[nilemg]

Finished all the three videos, I just want to send a huge thanks to all of you, I have learned a LOT

[matthewoh]

These tutorials were excellent! Much appreciated Chelsea! Given the huge drop in views from Beginner to Expert video, I think everyone who finished all the way through deserves a round of applause too

[Tara_Sutar]

Okay! When I started searching for excel vba courses on you tube I found videos of 10+ hours and some of just 3 hours. I avoided 3 hours video because I thought more topics would not be covered. The comments were good for all of them, then I found this video, approximately 7+ hours. I was like, how much can this lady cover in only 7 hours, but, since I had less time, I chose this you tube video. And I'm very much happy and impressed. All the topics which I wanted are covered and the lady has a very sweet voice. I learned a lot, used it to improve my daily work. Sorry for doubting you. My manager is happy, my team is happy, I'm also happy. Thank you so much for such great lessons.

[alarafat]

I've also watched other tutorials from LearniIT, but Chelsea has done a great job. Her speech is clear and to the point. She is a great instructor

[louwalker]

Firstly Loving the courses so thank you !!!
I had a issue with my Macro not changing data to Long date. For anyone else having issues at 13:21 this is how I fixed it (nothing was wrong with the code)
The date formats including Long date is controlled by your pc settings.
For Windows 10 go to Control Panel > Clock and Region
Click Change date, time or number formats
Then change Long date to dddd, dd MMMM yyyy (for the UK I guess it would be dddd, MMMM dd yyyy in the US)

Below you will see examples of the formats you currently have selected.
If you are happy with the changes click ok and your data should display in Excel as expected.
It worked for me so hope this helps.

[Coco-sqqo]

I have finally completed the entire course. This is one of the best courses I've taken so far. Your voice and teaching style definitely helps me in getting through the entire course more pleasurable. Thank you so much Chelsea!!

[nickmabuza]

Wow you magic!!! I have become a VBA expert in one day! I began this morning and finished this evening. Now I am working on a complicated project with colleagues overseas and its amazing I am leading the discussions!!!! You are

[ricardovideira]

Just finished all the 3 videos, and I must send a huge thanks to all of you.
The tutorials are very well explained and organized.
Thanks a lot!

[joelbello]

Chelsea, I want to thank you for your time and the resource you have put in here. This has been really useful to get the VBA fundamentals going for me

[joshuamutama]

Before these videos, I had no Idea that Excel could do so much. I'm losing my mind. Thank you for sharing.

[EduardoRodriguez-bkcc]

For a while it had been a pending issue for me . Now, thanks to you I can finally achieve this goal. It is so easy to understand, you have a nice voice and rythm. There are no words to demonstrate how benefically you have impacted my life. Thanks Chelsea!

[iisurgeon]

I have tried many VBA courses .It may be that I was already primed But I found this 3 courses to be the best . Clare you are a fantastic teacher able to convey / communicate complex concepts consisely and precisely. Your course should be monetised but I am not complaining. This world is a better place because of such acts of altruism . Cant beleive that this is free on Youtube - only in this era of progressive democratisation . You wont believe how many people benfit from such great courses. Keep up the good work - Priceless resource free amazing

[Mady]

I just finished the 3 videos and I learned a lot. I will explore VBA on my own now that I have better tools to do it. Thank you very much Chelsea!

[hengkiamriroza]

Finished my VBA Tutorial (Beginner, Advanced & Expert)... many thanks for Chelsea and Learnit. Jazakamullahu khairan

[pavankumarreddy]

I couldn't stop myself until completing all three videos. Fantastic style of teaching.

[alirazzaq]

I just Finished all three videos. Thanks a lot. Learning VBA is so cool.

[Hokiebird]

While this series certainly doesn’t cover everything about VBA, it gave me enough information to now understand what the heck is going on in other more advanced VBA tutorial videos. Thank you so much for making this series!

[ranjanamitra]

All three courses are very good. These helped me a lot to learn VBA from basics to advanced topics. Thanks a lot to Learnit for giving this excel VBA course for free.

[daliborivanovic]

Thank you. And thanks again. For me, as a non-native English speaker, your explanation and way of speaking was fantastically understandable. Now I want to follow you and watch all your other videos, whatever they are about. So far the best tutorial for me, in my opinion.

[stephenardy]

Thank you Chelsea for the courses! Your teaching style is also great and easy to follow along with. Much appreciated.