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.
@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.
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
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.....!!!
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.
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!!
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!
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
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.
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.
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!
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 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.
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.
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.
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!
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!
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.)
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.
Excellent course. Thanks On 13:07, i tried the code and it didnt work. I added ' Range("D" & 4 + x).ClearFormats ' after the 'For x= 1 to 30' and it fixed the issue. is it because i use Excel 2016?
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
Thank you so much for these tutorials Chelsea! I cant believe such a good course is free! Do you guys perhaps offer any courses on python?Other than that great tutorials you guys!
@@LearnitTraining oh my god i cant believe it thank you so much! You guys seriously deserve a lot more subscribers!You got one more sub from me for sure!
Hi just started looking at your tutorials, i am 75 and looking to expand my understanding of excel, my problem is I wish to import live data from 5 web sites, and run them in a worksheet, so I find the lowest cost. Can you please inform me of the correct course to be viewing. thank you
Question about the sub at 51:07: If the user were to type in an invalid input (once or multiple times) and keep trying again, wouldn't 3 worksheet copies be created each time? So if you input something wrong twice and try again a third time you would have 9 copies of the worksheets since you don't break from the current sub after handling the error. Or am I misunderstanding it? On that note, even if the user says "no", they'd still have 3 copies generated correct?
at the 7:46 mark after she types dateSerial( a prompt window opens up showing you what it expects you to input. Year, Month, day.... it doesn't pop up when I type DateSerial( Does anyone know why??
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.
@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.
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!
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!
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
Thank you bro I stuck 1 hour there
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'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!
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!
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!
Before these videos, I had no Idea that Excel could do so much. I'm losing my mind. Thank you for sharing.
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!
Finished my VBA Tutorial (Beginner, Advanced & Expert)... many thanks for Chelsea and Learnit. Jazakamullahu khairan
You are welcome!
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
I couldn't stop myself until completing all three videos. Fantastic style of teaching.
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!
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
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!
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 Chelsea for the courses! Your teaching style is also great and easy to follow along with. Much appreciated.
You're so welcome!
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!
Fantastic course, i've already finished all 3 level courses. It was a great journey. Thank you :)
You are very welcome!
I'm in the last video. I want to say Thank you for a job well done.
You are very welcome!
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!
I just Finished all three videos. Thanks a lot. Learning VBA is so cool.
I have completed the entire course. This has been wonderful. Chelsea, you are an awesome teacher !
Best UA-cam Channel, Keep the Good Work !!!
We will and thank you for watching Makarand!
I love the way you Teach and speak. awesome Ms. Chelsea. Kudos
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!
Thanks Chelsea the 3 videos has made me feel like a fully fledged programmer. God bless you very much
Glad it was helpful!
The three tutorials were perfect. Learned a lot. Much appreciated!
Glad you like them!
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!
I feel more confident after going thru 3 video's. Excellent. Thanks a lot.
Excellent!
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!
Really appreciate the team and your effort in making these awesome videos!
Our pleasure!
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!
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!
Thank you so much. Its been one of the best courses I have taken.
You are very welcome!
Thanks for guiding us through the whole time (for 3 times)! I have learnt a big ton and it was so satisfying!
You are so welcome!
I enjoyed every single bit of this training program
Thank you so much for watching!
thanks for these detailed, to-the-point videos
Glad you like them!
Awesome work by Chelsea
Thank for the kind words Bobby!
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!
Amazing video series, I've learned so much for this channel, I appreciate all the material and guidence!
You are welcome!
Really appreciate your efforts in making these amazing tutorials, thank you LearnIt Team!
Glad you like them!
Sorryfor gettting your name wrong - Chelsea Dohmann You are a fantastic teacher Hats off to you Long may you continue this work Chao
Easy to follow. Nice voice. Great instructor. Thank you very much.
Glad it was helpful!
Great and outstanding performance, outstanding and complete materials; presentation, documnets and Exercise Files.Thanks
You are welcome!
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.
Thank you! This video is really clear and very organized! It makes me feel confident about VBA now~
Glad it was helpful!
Congratulation for teaching and developing such a beautiful course. it was a pleasure learning with you. learned a lot !!
Many thanks Chelsea - the three videos were excellent!
You're very welcome!
Thank you. I finally finished the previous two videos.
You are welcome!
You are appreciated for this excellent delivery.
We appreciate that!
All parts of this tutorial are great. Thanks guys for sharing it with us!
Our pleasure!
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 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 Chelsea Its really nice way to explaining each and every points in VBA . Learn a lot from these videos .
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!
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!
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!
Thankyou for the VBA training, excellent teaching and materials! Hoping for the next VBA tutorial ..
Thank you for watching Yosafat!
madam please upload more vba tutorial I am learning by watching your videos. I am from India.great thanks to you.
Wanted to say thanks a lot to the team and Chelsea.
Thank you Aswin for watching!
Thanks for the VBA tutorial series!
Chelsea! You are the best..Lots of love..Thanks
You're so welcome!
Thank you so much for these wonderful 3 videos. Please do more examples of the use of VBA in data analysis. Thank you.
You are very welcome!
Thanks a lot for this course. Your clarity and level of confidence is outstanding
Great series of videos! I really enjoyed the teaching method, and the audio was perfect!
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 for making this course!
Glad it was helpful!
Thank you for this excellent piece of artwork!
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
Great content and advanced teaching skills. Thanks Madam.
It's our pleasure!
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.
Seriously recommended, nice work. Keep it up.
Thanks, will do!
Thanks a lot for making Excel VBA tutorials
You are most welcome!
Thanks! All three lessons helped me a lot!
You're very welcome!
Excellent course. Thanks
On 13:07, i tried the code and it didnt work. I added ' Range("D" & 4 + x).ClearFormats ' after the 'For x= 1 to 30' and it fixed the issue. is it because i use Excel 2016?
Same happened to me. And "long date" returns dd-mmm-yyy format, instead of dddd,mmmm,yyyy like in the video
Thanks for this great tutorial. all the best!
Thank for your continued support mohamad!
Very good teacher!!!
Thank you! 😃
Great course. Totally recommended!
Glad you like it!
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
thank you very much Chelsea! you are awesome!
You're so welcome!
Chelsea is a badass teacher and used to drive el camino!
Hi Joseph - Thank you for the kind words!
Extremely well explained. Thanks a ton
Glad it was helpful!
Thank you for the cool lectures. They are really helpful!!!
You are very welcome!
It was really efficient to give your time here.
Thank you!
@@LearnitTraining You are always Welcome...!!
THank you for the training! Living in FL from the Chico/Paradise area.
Our pleasure!
Thank You Chelsea ...It Is so Amazing
Thank you for watching The Peaceful!
Thank you so much for this tutorial! It taught me a lot!
You're very welcome!
Thank you so much for these tutorials Chelsea! I cant believe such a good course is free! Do you guys perhaps offer any courses on python?Other than that great tutorials you guys!
Here you go! - ua-cam.com/video/7fc2MTLTX2Q/v-deo.html
@@LearnitTraining oh my god i cant believe it thank you so much! You guys seriously deserve a lot more subscribers!You got one more sub from me for sure!
I am targetting to complete all the courses designed through excel such as pivot tables and Power BI.
Thanks A Lot Maam these session are really amazing to learn
You are very welcome!
Hola Chelsea.
Me encantaron tus tres videos de Excel Vba
¿Cuándo tendrás tres más?
MIl gracias
Just Awesome. You are just a wonderful Tutor. Thanks.
You are welcome!
Hi just started looking at your tutorials, i am 75 and looking to expand my understanding of excel, my problem is I wish to import live data from 5 web sites, and run them in a worksheet, so I find the lowest cost. Can you please inform me of the correct course to be viewing. thank you
Power BI would be the program to use for that type of data visualization and we have many videos on Power BI on our channel
@@LearnitTraining Thank you for your help
Question about the sub at 51:07: If the user were to type in an invalid input (once or multiple times) and keep trying again, wouldn't 3 worksheet copies be created each time? So if you input something wrong twice and try again a third time you would have 9 copies of the worksheets since you don't break from the current sub after handling the error. Or am I misunderstanding it? On that note, even if the user says "no", they'd still have 3 copies generated correct?
Hi omuletulnou, our instructors are available to answer questions at Offsite our online community - bit.ly/2RHRbzz
at the 7:46 mark after she types dateSerial( a prompt window opens up showing you what it expects you to input. Year, Month, day.... it doesn't pop up when I type DateSerial( Does anyone know why??
Hi Stamat! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
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! 😊