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

@madhavsuneja5968

3 жыл бұрын

Hey i was watching first video can you please tell me how can i downlod simple macro?

@SuperLickshit

3 жыл бұрын

@@madhavsuneja5968 in the description of the video, contains a link called exercise files, dl that file and search for simple macros

@caoainguyenang1007

2 жыл бұрын

I ve just finished the first two, now I start the third.

@amasingrawat7712

2 жыл бұрын

Mooin

@weipiao8547

Жыл бұрын

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

@LearnitTraining

3 жыл бұрын

You're so welcome!

@Arbitraritorian

2 жыл бұрын

​@@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

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

25 күн бұрын

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

@Tara_Sutar

25 күн бұрын

@@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.

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

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

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 !

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.....!!!

@LearnitTraining

Ай бұрын

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.

@LearnitTraining

2 жыл бұрын

Thank you for the tip, Lou! Also thank you for your support!

@xinyuli3144

2 жыл бұрын

Thank you so much for the tip!! this had confused me a lot

Thanks Chelsea Its really nice way to explaining each and every points in VBA . Learn a lot from these videos .

I love the way you Teach and speak. awesome Ms. Chelsea. Kudos

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!

@LearnitTraining

3 жыл бұрын

You are so welcome!

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!

@LearnitTraining

3 жыл бұрын

Glad you like them!

Thanks a lot for this course. Your clarity and level of confidence is outstanding

Congratulation for teaching and developing such a beautiful course. it was a pleasure learning with you. learned a lot !!

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!

@LearnitTraining

4 жыл бұрын

Great to hear!

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

@LearnitTraining

Жыл бұрын

We think Chelsea is great too!

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 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.

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!

@LearnitTraining

Жыл бұрын

Thank you for watching! We are glad you learned so much!

Thanks Chelsea the 3 videos has made me feel like a fully fledged programmer. God bless you very much

@LearnitTraining

3 жыл бұрын

Glad it was helpful!

The three videos will be so useful! Many thanks Chelsea for your explanations! I can't wait to create my own macros!

@LearnitTraining

3 жыл бұрын

You're so welcome!

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!

@LearnitTraining

3 жыл бұрын

Thank you so much Maria and an extra thank you for subscribing! It helps so much!

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.

@LearnitTraining

2 жыл бұрын

Thank you for the kind words Luki!

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

@LearnitTraining

5 ай бұрын

You're so welcome!

Thank you for this excellent piece of artwork!

Thanks for the VBA tutorial series!

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

@LearnitTraining

Жыл бұрын

Thank you for the kind words!

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!!

@LearnitTraining

Жыл бұрын

Thank you for the kind words!~

The three tutorials were perfect. Learned a lot. Much appreciated!

@LearnitTraining

2 жыл бұрын

Glad you like them!

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

@LearnitTraining

2 жыл бұрын

You are welcome!

Thanks so much, finished them all, really easy to understand. I've already can write my own macro for my work.

@LearnitTraining

3 жыл бұрын

Thank you for watching Ngoc! We are glad you learned so much!

Really appreciate the team and your effort in making these awesome videos!

@LearnitTraining

3 жыл бұрын

Our pleasure!

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.

@LearnitTraining

Жыл бұрын

Thank you for watching Paula!

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.

@LearnitTraining

Ай бұрын

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.

@LearnitTraining

Жыл бұрын

You're very welcome!

Great and outstanding performance, outstanding and complete materials; presentation, documnets and Exercise Files.Thanks

@LearnitTraining

11 күн бұрын

You are welcome!

From Egypt,, thanks alot, you really added alot for me :)

I feel more confident after going thru 3 video's. Excellent. Thanks a lot.

@LearnitTraining

2 жыл бұрын

Excellent!

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.

@LearnitTraining

Жыл бұрын

You're very welcome!

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 KZread - 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

@comb-overcowboy1817

4 жыл бұрын

I couldn't agree more Jay! I am very grateful as well!

All parts of this tutorial are great. Thanks guys for sharing it with us!

@LearnitTraining

2 жыл бұрын

Our pleasure!

Many thanks Chelsea - the three videos were excellent!

@LearnitTraining

3 жыл бұрын

You're very 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.

@LearnitTraining

7 ай бұрын

You are most welcome!

Just Amazing how much you learn from these 3 video parts. Well done.

@LearnitTraining

3 жыл бұрын

Glad you like them!

These videos are definitely useful and timeless. Thank you so much for the recap, you’re such a coherent and understandable tutor ☺️

@LearnitTraining

Жыл бұрын

You are very welcome! 😊

Thank you very much for putting together these free tutorials. Really really helpful!!!

@LearnitTraining

2 жыл бұрын

You're very welcome!

Sorryfor gettting your name wrong - Chelsea Dohmann You are a fantastic teacher Hats off to you Long may you continue this work Chao

Amazing video series, I've learned so much for this channel, I appreciate all the material and guidence!

@LearnitTraining

7 ай бұрын

You are welcome!

Fantastic course, i've already finished all 3 level courses. It was a great journey. Thank you :)

@LearnitTraining

6 ай бұрын

You are very 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.

Really appreciate your efforts in making these amazing tutorials, thank you LearnIt Team!

@LearnitTraining

Жыл бұрын

Glad you like them!

Absolutely magnificent tutorials! And I'm definately subscribing to your channel because your content is amazing.

@LearnitTraining

2 жыл бұрын

Thank you so much Dušan Terek ml! It helps us to continue to make videos for everyone!

I'm in the last video. I want to say Thank you for a job well done.

@LearnitTraining

3 ай бұрын

You are very welcome!

THank you for the training! Living in FL from the Chico/Paradise area.

@LearnitTraining

3 жыл бұрын

Our pleasure!

Thank you! This video is really clear and very organized! It makes me feel confident about VBA now~

@LearnitTraining

3 ай бұрын

Glad it was helpful!

madam please upload more vba tutorial I am learning by watching your videos. I am from India.great thanks to you.

Chelsea thank you for your time and the resource you have put in here. i learned a lot from you. thank you

@LearnitTraining

2 жыл бұрын

You're so welcome!

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

@LearnitTraining

2 жыл бұрын

You're very welcome!

I would like to thank you for creating this amazing tutorial. I have completed the complete course/ Now, I am very confident.

@LearnitTraining

5 ай бұрын

Great to hear!

Thank you. I finally finished the previous two videos.

@LearnitTraining

10 ай бұрын

You are welcome!

Thank you so much. Its been one of the best courses I have taken.

@LearnitTraining

5 ай бұрын

You are very welcome!

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.

@LearnitTraining

Жыл бұрын

Thank you so much for the kind words! Also thank you so much for the great tip!

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.)

@CountTo10

Жыл бұрын

you probably meant QuarterSelect = (QuarterSelect*3) - 3 + y

Best KZread Channel, Keep the Good Work !!!

@LearnitTraining

2 жыл бұрын

We will and thank you for watching Makarand!

I enjoyed every single bit of this training program

@LearnitTraining

Жыл бұрын

Thank you so much for watching!

Thanks for the free course finished all 3 videos and I really appreciate your teaching God bless @chelsea Dohemann and learnIt

Thankyou for the VBA training, excellent teaching and materials! Hoping for the next VBA tutorial ..

@LearnitTraining

3 жыл бұрын

Thank you for watching Yosafat!

Thanks! All three lessons helped me a lot!

@LearnitTraining

3 жыл бұрын

You're very welcome!

Thank you so much for this tutorial! It taught me a lot!

@LearnitTraining

3 жыл бұрын

You're very welcome!

Easy to follow. Nice voice. Great instructor. Thank you very much.

@LearnitTraining

2 жыл бұрын

Glad it was helpful!

Completed! Thank you :)

You are appreciated for this excellent delivery.

@LearnitTraining

2 жыл бұрын

We appreciate that!

Thank you so much for your help and your time!

@LearnitTraining

3 жыл бұрын

Hi Leon! Thank you for watching and an extra big thank you for subscribing!

Extremely well explained. Thanks a ton

@LearnitTraining

2 жыл бұрын

Glad it was helpful!

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

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.

Seriously recommended, nice work. Keep it up.

@LearnitTraining

3 жыл бұрын

Thanks, will do!

Great course. Totally recommended!

@LearnitTraining

3 жыл бұрын

Glad you like it!

thank you very much Chelsea! you are awesome!

@LearnitTraining

10 ай бұрын

You're so welcome!

Chelsea! You are the best..Lots of love..Thanks

@LearnitTraining

2 жыл бұрын

You're so welcome!

Wanted to say thanks a lot to the team and Chelsea.

@LearnitTraining

3 жыл бұрын

Thank you Aswin for watching!

Thanks for this great tutorial. all the best!

@LearnitTraining

2 жыл бұрын

Thank for your continued support mohamad!

Awesome work by Chelsea

@LearnitTraining

3 жыл бұрын

Thank for the kind words Bobby!

Thank you Easy to follow and understand

Thanks a lot for making Excel VBA tutorials

@LearnitTraining

2 жыл бұрын

You are most welcome!

Thank you so much Chelsea

Hi. Thank you so much for these tutorial videos. I watched all three of it and now trying to make my macro commands. I learned a lot too like all others who watched this. :D By the way, I run to a "Run Time Error 1004" while running my commands and wondering what should I do.. Thank you in advanced.

Great content!!! I just finished going through each of the three videos while doing the exercises too. Chelsea u sure know ur stuff

@LearnitTraining

3 жыл бұрын

Awesome! Thank you!

Amazing stuff, thank you so much!

@LearnitTraining

3 жыл бұрын

Glad you enjoyed it!

Thank You Chelsea ...It Is so Amazing

@LearnitTraining

3 жыл бұрын

Thank you for watching The Peaceful!

Thank you, this is very valuable free content

@LearnitTraining

3 жыл бұрын

You're very welcome!

I love your videos, thank you so much, please if you can add more advanced. also for word. thsnk you so much

*GREAT* *Thank you for sharing*

Just Awesome. You are just a wonderful Tutor. Thanks.

@LearnitTraining

Жыл бұрын

You are welcome!

Thanks a lot to learnit for giving such an tremendous excel VBA course for free specially thanks to @Chelsea Dohemann.Takes Love.

@LearnitTraining

10 ай бұрын

You're very welcome!

Hola Chelsea. Me encantaron tus tres videos de Excel Vba ¿Cuándo tendrás tres más? MIl gracias

Thank you. Very useful.

Great content and advanced teaching skills. Thanks Madam.

@LearnitTraining

Жыл бұрын

It's our pleasure!