Excel VBA Expert Tutorial
Вставка
- Опубліковано 9 лип 2024
- Excel VBA Expert Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3kVR38Y
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:
www.learnitanytime.com
Enroll in our live, instructor-led Excel VBA classes:
bit.ly/3K6z78J
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
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.
Finished all the three videos, I just want to send a huge thanks to all of you, I have learned a LOT
Hey i was watching first video can you please tell me how can i downlod simple macro?
@@madhavsuneja5968 in the description of the video, contains a link called exercise files, dl that file and search for simple macros
I ve just finished the first two, now I start the third.
Mooin
me too
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
You're so welcome!
@@LearnitTraining Thank you so much!! One of the best tutorial series I've ever done!
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
Before these videos, I had no Idea that Excel could do so much. I'm losing my mind. Thank you for sharing.
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
We think Chelsea is great too!
I just Finished all three videos. Thanks a lot. Learning VBA is so cool.
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.
I wanted to know , will this really help.... because recently I got job in vba n my manager is super angry on me because I'm not doing well in task ..... mam said me to c videos, I saw but those were not helpful in my task.... videos were different and my task is different... Is vba is easy to learn.... even I want to make my team happy , beside I'm very poor in coding
@@renukaangolkar2026 have you watched the complete series? This series of videos is really good. Also along with Excel VBA you need to have good knowledge in excle (formula, formatting etc) to be able to use it in your work.
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 amazing.....!!!
You got this!
I couldn't stop myself until completing all three videos. Fantastic style of teaching.
Thank you for the kind words!
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!
Thank you for watching! We are glad you learned so much!
Thank you for this excellent piece of artwork!
Great series of videos! I really enjoyed the teaching method, and the audio was perfect!
I have completed the entire course. This has been wonderful. Chelsea, you are an awesome teacher !
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!
Glad you like them!
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!
Great to hear!
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.
Thank you for the tip, Lou! Also thank you for your support!
Thank you so much for the tip!! this had confused me a lot
A fun thing to do for the reorganizing sheets one is to first finish the macros started for sorting the desired region to the front. Then you can record a macro while you create buttons for them on the first sheet, then call this macro to apply the buttons to all Th sheets with one command. Super satisfying!
Thanks for the VBA tutorial series!
I love the way you Teach and speak. awesome Ms. Chelsea. Kudos
Thanks so much, finished them all, really easy to understand. I've already can write my own macro for my work.
Thank you for watching Ngoc! We are glad you learned so much!
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!!
Thank you for the kind words!~
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!
Thank you so much Maria and an extra thank you for subscribing! It helps so much!
Thanks Chelsea Its really nice way to explaining each and every points in VBA . Learn a lot from these videos .
Finished my VBA Tutorial (Beginner, Advanced & Expert)... many thanks for Chelsea and Learnit. Jazakamullahu khairan
You are welcome!
Thanks a lot for this course. Your clarity and level of confidence is outstanding
The three videos will be so useful! Many thanks Chelsea for your explanations! I can't wait to create my own macros!
You're so welcome!
From Egypt,, thanks alot, you really added alot for me :)
Hi Chelsea. Thank you SO MUCH for your amazing teaching. You took me from minimal experience to competent enough to getting employed at a new job. A much better one that I'm happy at. So thank you!
You are so welcome!
Thank you Chelsea for the courses! Your teaching style is also great and easy to follow along with. Much appreciated.
You're so welcome!
Really appreciate the team and your effort in making these awesome videos!
Our pleasure!
The three tutorials were perfect. Learned a lot. Much appreciated!
Glad you like them!
I'm in the last video. I want to say Thank you for a job well done.
You are very welcome!
Great and outstanding performance, outstanding and complete materials; presentation, documnets and Exercise Files.Thanks
You are welcome!
Congratulation for teaching and developing such a beautiful course. it was a pleasure learning with you. learned a lot !!
Really appreciate your efforts in making these amazing tutorials, thank you LearnIt Team!
Glad you like them!
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.
You are most welcome
Thanks Chelsea the 3 videos has made me feel like a fully fledged programmer. God bless you very much
Glad it was helpful!
Just finished the 3 tutorials. They were excellent specially for me that didn't even knew how to create a Macro. Chelsea is a great instructor.
Thank you for watching Paula!
Been watched all three videos in the series. Million thanks for sharing them. All stuffs are explained clearly and your voice is so pleasant to listen.
Thank you for the kind words Luki!
Many thanks Chelsea - the three videos were excellent!
You're very welcome!
THank you for the training! Living in FL from the Chico/Paradise area.
Our pleasure!
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 UA-cam - 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
I couldn't agree more Jay! I am very grateful as well!
Hi learnit! I love the Tutorials. Im from the Philippines by the way. You have a very clear way of speaking thats why i like it. I understand every words and steps! More Tutorials about vba specially creating data forms for our school.
Thank you. I finally finished the previous two videos.
You are welcome!
All parts of this tutorial are great. Thanks guys for sharing it with us!
Our pleasure!
I feel more confident after going thru 3 video's. Excellent. Thanks a lot.
Excellent!
Amazing video series, I've learned so much for this channel, I appreciate all the material and guidence!
You are welcome!
Thank you very much for putting together these free tutorials. Really really helpful!!!
You're very welcome!
Just Amazing how much you learn from these 3 video parts. Well done.
Glad you like them!
Thanks! All three lessons helped me a lot!
You're very welcome!
Chelsea thank you for your time and the resource you have put in here. i learned a lot from you. thank you
You're so welcome!
Thank you very much for this video series on Excel VBA. It was really helpful to grasp the different aspects of the subject in depth.
You are most welcome!
Completed! Thank you :)
Thank you! This video is really clear and very organized! It makes me feel confident about VBA now~
Glad it was helpful!
Thank to this course I am taken to another level in VBA. This course shows me different and broader perspective of how to use the VBA tools in practice. Thanks again for making this tutorial.
You're very welcome!
Thank you so much for your help and your time!
Hi Leon! Thank you for watching and an extra big thank you for subscribing!
Fantastic course, i've already finished all 3 level courses. It was a great journey. Thank you :)
You are very welcome!
Absolutely magnificent tutorials! And I'm definately subscribing to your channel because your content is amazing.
Thank you so much Dušan Terek ml! It helps us to continue to make videos for everyone!
Thank you so much for this tutorial! It taught me a lot!
You're very welcome!
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.
You're very welcome!
thank you very much Chelsea! you are awesome!
You're so welcome!
Thank you so much Chelsea
Thank you so much. Its been one of the best courses I have taken.
You are very welcome!
I enjoyed every single bit of this training program
Thank you so much for watching!
Thanks for this great tutorial. all the best!
Thank for your continued support mohamad!
Thank you for all the learning you gave, i am simply amazed by the things I knew before watching this video, and now after watching it. Thanks alot
You're very welcome!
Thankyou for the VBA training, excellent teaching and materials! Hoping for the next VBA tutorial ..
Thank you for watching Yosafat!
Sorryfor gettting your name wrong - Chelsea Dohmann You are a fantastic teacher Hats off to you Long may you continue this work Chao
Thank you Easy to follow and understand
madam please upload more vba tutorial I am learning by watching your videos. I am from India.great thanks to you.
These videos are definitely useful and timeless.
Thank you so much for the recap, you’re such a coherent and understandable tutor ☺️
You are very welcome! 😊
Amazing stuff, thank you so much!
Glad you enjoyed it!
*GREAT* *Thank you for sharing*
Thank you. Very useful.
Extremely well explained. Thanks a ton
Glad it was helpful!
Chelsea! You are the best..Lots of love..Thanks
You're so welcome!
Loving the videos and learning a lot. As a math guy, I chose to let QuarterSelect = QuarterSelect*3 - 2 which saved a few lines of code (though it didn't give the practice on Select Case.)
you probably meant QuarterSelect = (QuarterSelect*3) - 3 + y
I would like to thank you for creating this amazing tutorial. I have completed the complete course/ Now, I am very confident.
Great to hear!
Thanks for posting learning the VBA videos.
I'm having trouble to pop-up the function argument on UDF. I use a mac. I hit the fx button, but the display doesn't show the table and let me choose the cell for my function.
You are appreciated for this excellent delivery.
We appreciate that!
Excel VBA Expert Tutorial good in first half. Majority of the code recording has gone blurry hence gets annoyed at times. However, since codes are also available in practice files, really we don't miss anything. We expect a bit more in this expert series. Thank you for uploading and making it available to us.
Great course. Totally recommended!
Glad you like it!
Thank you very much. I ve learnt a lot.
Glad it was helpful!
I know it’s kind of late, finding this video and comment, given it’s nearly 3 years since they posted.
Watched through all 3 videos. really insightful. The video helped filled up some of my knowledge gaps, even having built some VBA projects already (mostly because I have learned Visual Basic from my studies and use Excel to solve many problem).
Great explanations of codes so I understand them much better even when I already used some of them before. Really liked how the lessons gradually introduce objects/Methods in VBA to build up solving a real-world usable scenario.
Had a thought across my mind. Around 51:03, if change the code as:
Worksheets(y + 1).Name = Format(DateSerial(1, ((QuarterSelect - 1) * 3 + y), 1), "MMMM")
The Sub can work as desired without the ‘Select Case QuarterSelect’ code block, saving a few lines of codes.
Thank you so much for the kind words! Also thank you so much for the great tip!
Thank you very much!
Best UA-cam Channel, Keep the Good Work !!!
We will and thank you for watching Makarand!
really , thank for your effort, exquisite explanation
Thank you for watching!
Seriously recommended, nice work. Keep it up.
Thanks, will do!
Wanted to say thanks a lot to the team and Chelsea.
Thank you Aswin for watching!
Thank You Chelsea ...It Is so Amazing
Thank you for watching The Peaceful!
Thanks a lot for making Excel VBA tutorials
You are most welcome!
Thanks for the free course finished all 3 videos and I really appreciate your teaching God bless @chelsea Dohemann and learnIt
One faster code to do the excercise 16.Reordering sheets is:
-Create a for loop to iterate across the worksheets and asking if left(woorksheet(i).name, 2) = "SE" then move. The left function extract the first n characters of a string
Easy to follow. Nice voice. Great instructor. Thank you very much.
Glad it was helpful!
Awesome work by Chelsea
Thank for the kind words Bobby!
Thank you, this is very valuable free content
You're very welcome!
Just Awesome. You are just a wonderful Tutor. Thanks.
You are welcome!
thank you it was super helpful and awesome sessions
You're very welcome!
Hola Chelsea.
Me encantaron tus tres videos de Excel Vba
¿Cuándo tendrás tres más?
MIl gracias
Very good teacher!!!
Thank you! 😃