Excel VBA Beginner Tutorial

  Рет қаралды 5,104,939

Learnit Training

Learnit Training

Күн бұрын

Excel VBA Beginner 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 class:
bit.ly/3I4q5Yh
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
What is VBA? 1:44
Object Oriented Programming Languages 5:59
Turning on the Developer Tab 10:17
The Macro Recorder 13:40
Using Relative References 20:39
Recording Simple Macros 27:51
Multi-Step Macro Recording 39:25
Sort and Filter Macro Recording 45:26
Protecting and Formatting Sheets with the Macro Recorder 51:35
VBA Interface Setup 55:09
Recorder Code vs. Manual Code 1:01:11
Introduction to Editing Macros 1:12:28
Debugging Macros 1:16:53
Grammar in VBA 1:28:00
Macro Scripting Basics 1:33:04
Range 1:40:41
Selection & Color 1:47:14
Value and Clear 1:52:16
ActiveSheet, Sheets, and Name 1:54:01
CurrentRegion 1:56:40
Practice 1:58:08
#ExcelVBA
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

Пікірлер: 2 800
@LearnitTraining
@LearnitTraining 2 жыл бұрын
The link to the exercise files is in the video description
@abnerkamps1669
@abnerkamps1669 2 жыл бұрын
subbed*** I could not find the file with the phone numbers.... the one used at 27:51
@abnerkamps1669
@abnerkamps1669 2 жыл бұрын
Just kidding @ JugglingMike saved the day
@pkushanth5526
@pkushanth5526 2 жыл бұрын
@@abnerkamps1669 hey! Could you help me with the simple macros file?
@abnerkamps1669
@abnerkamps1669 2 жыл бұрын
@@pkushanth5526 after you download the exercise files (link in the video description) the file discussed at 28:20 showed up as "VBA Simple Macros", not "Simple Macros" in the exercise files.
@wijesiriwardaneus
@wijesiriwardaneus 2 жыл бұрын
Hi i ran in to run time error '1004' autofilter method of range class failed when i click the reset filters button. did it several times the same error. kindly explain why this error appearing. thanks
@RedDogByrd
@RedDogByrd Жыл бұрын
I'm a 79 year old retired software developer who has taken many classes and courses over the years. This lady, bar none, has done one of the best teaching jobs I have ever experienced. Congratulations on an outstanding performance!
@LearnitTraining
@LearnitTraining Жыл бұрын
Thank you so much for the kind words Jim!
@anh4bap426
@anh4bap426 Жыл бұрын
Totally agreed. She is great.
@Ooko.
@Ooko. Жыл бұрын
@@LearnitTraining It's true! very helpfull, thank you!
@hedhtr4
@hedhtr4 Жыл бұрын
I agree
@tamarsimonishvili4236
@tamarsimonishvili4236 Жыл бұрын
could not agree more.
@paristmo
@paristmo Ай бұрын
No music and overly excited speech, just direct and straight-to-the-point detailed guidance; all tutorial should be like this.
@LearnitTraining
@LearnitTraining 28 күн бұрын
We think so too!
@PaulRhee-gp8zu
@PaulRhee-gp8zu 22 күн бұрын
RIght? getting to the core of how to understand VBA instead of just giving specific situations.
@ecashmarketing
@ecashmarketing 3 жыл бұрын
I am jobless and learning VBA for a job interview. Just want to thank you for your service.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Good luck on the interview!
@ahanapal4055
@ahanapal4055 3 жыл бұрын
All the best for your career ahead!
@157abhishekkumar5
@157abhishekkumar5 2 ай бұрын
Did you get job buddy?
@ranjitjojo
@ranjitjojo 17 күн бұрын
I have seen so many videos on VBA... but this one is the best..... no jass... no unwanted irritating music.... straight to the point.... thanks a ton to the trainer...
@LearnitTraining
@LearnitTraining 8 күн бұрын
Thanks!
@hellopsp180
@hellopsp180 4 жыл бұрын
Is it just me or is the audio really pleasant to the ears?
@douglasveltz3518
@douglasveltz3518 4 жыл бұрын
I thought it was just me!
@regal_7877
@regal_7877 4 жыл бұрын
Damn I'm not alone
@MrROFLKNIFE
@MrROFLKNIFE 4 жыл бұрын
VBA ASMR 10 hours
@ansalc
@ansalc 4 жыл бұрын
I fully agree. She has a very crisp and pleasant-to-hear English.
@rariscool4548
@rariscool4548 4 жыл бұрын
IT IS LOUD
@dixiwu2174
@dixiwu2174 2 ай бұрын
so happy to find a tutorial with a female teacher. all my IT teachers are male, online and offline. A big step for female power. big support
@LearnitTraining
@LearnitTraining 2 ай бұрын
We try to have a wide and diverse variety of instructors!
@griffinmaree6605
@griffinmaree6605 Жыл бұрын
Few people nowdays truely understand how to teach. You clearly have empathy for your audience and understand their perspective. This is a really well put together tutorial.
@LearnitTraining
@LearnitTraining Жыл бұрын
Thank you so much!
@artifaxiom
@artifaxiom 2 жыл бұрын
Just in case someone's confused: the file discussed at 28:20 showed up as "VBA Simple Macros", not "Simple Macros" in the exercise files. Thus far: fantastic tutorial! I feel like an Excel superhero!
@andrewmathew8220
@andrewmathew8220 2 жыл бұрын
not all heros wear a cape, ty
@kamol901
@kamol901 2 жыл бұрын
Can you please share the download link?
@artifaxiom
@artifaxiom 2 жыл бұрын
@@kamol901 it's in the description
@kamol901
@kamol901 2 жыл бұрын
I saw the exercise file link to a zip file, when I unzip I do no see the excel file. Thanks
@artifaxiom
@artifaxiom 2 жыл бұрын
​@@kamol901 , when you click the link it should take you to a sharepoint site. On the upper left, there is a down arrow to download the files. Once you download the zipped file, unzip it. I had a strange experience where, when I unzipped it, it showed another zipped file. When I unzipped the second one, it worked for me. If that doesn't work, can you tell me what step isn't working for you?
@vijayendrashenoypadav2370
@vijayendrashenoypadav2370 4 жыл бұрын
This was a brilliant 2+ hour of session! Clear communication, organised content and specific information. I am glad I came across this. My Sunday well spent learning something great.
@lesnyk255
@lesnyk255 4 жыл бұрын
I taught myself some VBA by back-engineering macros I'd recorded, but there's SOOO much more to it that I've never understood. I'm 25 minutes into this and I've already learned several tricks that will make life easier! Taking a break now, but I will be back for more. This is a godsend.
@bronteparker1321
@bronteparker1321 2 жыл бұрын
This class was truly amazing! It was so easy to follow along with the exercises due to the instructor always verbalizing what she was doing (typing, clicking on, ect.), allowing me to look at my excel sheet and complete the steps simultaneously. I went from not knowing what VBA/Macros were at all to feeling like I can say I have a beginner level understanding. Thank you Learnit!
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You are very welcome Bronte! We are happy to hear you learned so much!
@iClone316
@iClone316 2 жыл бұрын
Isn't it crazy what difference it makes when someone actually explains their actions? Other people just speed through it. You should see some of the VBA courses on Udemy, such a joke (except one instructor, as far as I'm concerned).
@MidoCounters
@MidoCounters Жыл бұрын
I'm barely an hour in and it's already changing the way I'll work from now on. Love the tutorial! Everything is explained beautifully and easy to follow through and understand.
@LearnitTraining
@LearnitTraining Жыл бұрын
We are glad you are learning so much!
@stevegerol5839
@stevegerol5839 3 жыл бұрын
Best training video I've ever watched. Chelsea’s voice is intoxicating. Her delivery is exceptional. She doesn’t seem to be reading a script, her delivery is conversational. The big red arrow is extremely helpful as are the exercises. Just a wonderful experience.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Wow, thank you!
@patricdaniel5601
@patricdaniel5601 4 жыл бұрын
I wanted to learn VBA for the last so many years. Finally found what I was looking for. Excellent presentation and oh ! the audio -the great motivator :). Thank you.
@alexinivai08
@alexinivai08 2 жыл бұрын
This has got to be the best beginner's course I've had. Well-made, easy to comprehend. Please never stop creating content.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Thanks, will do!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
If you want to learn more about its video editing capabilities, including tutorials, and features, go follow: ►DemoCreator Facebook Group here: bit.ly/2XqGL6S ►Get Wondershare DemoCreator 7-day License to Start Your Video Trip: bit.ly/3oCEPDA
@cedkize7608
@cedkize7608 3 жыл бұрын
How did you downloaded your simple macros on your desktop. I can't download it and I don't know where to get it. Thanks in advance for the help.
@ivanaivi4ka
@ivanaivi4ka 3 жыл бұрын
@@cedkize7608 I would really appreciate an answer on that!
@tatarioz1161
@tatarioz1161 3 жыл бұрын
xD thanks mis
@oPerdigaz
@oPerdigaz 3 жыл бұрын
@@cedkize7608 In the Exercise Files is the "VBA Simple Macros"
@gulerenbingol8609
@gulerenbingol8609 3 жыл бұрын
GjIəJJ
@maldighaithir
@maldighaithir 4 жыл бұрын
Ok, I got to say this, the instructor is doing a fantastic job explaining the basics, but what i have to say is, she has a marvelously soothing voice that can be heard for hours XD
@Pioneer_Inspire_Empower
@Pioneer_Inspire_Empower 4 жыл бұрын
Chelsea, your tutorials are quite simply outstanding. Your preparation and delivery of the content is superb!
@SteelStrung
@SteelStrung 2 жыл бұрын
You did a great job breaking down and making easy to understand something that can be pretty daunting for most people who haven't worked with macros before. I had a lot of trouble trying to share my knowledge/train others on VBA and this video was easy to understand and well organized. Thanks!
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Glad you enjoyed it!
@anitaadiki4573
@anitaadiki4573 3 жыл бұрын
I don't usually write comments but for this one I HAD to. This video was so helpful omg. I've learnt more in 2 hours from here than from a whole semester in University. Definitely going to watch the remaining 2 videos!!!!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you for the kind words Anita Adiki! We are glad the videos are so helpful!
@justinlife922
@justinlife922 3 жыл бұрын
​@@LearnitTraining Hi, I'm at the 'Sort and Filter Macro' part of the lesson, and I'm struggling to find the excel worksheet that goes with that particular section from the exercise files I downloaded off of here. What name are they under? Thanks
@JamesGirardi69
@JamesGirardi69 4 жыл бұрын
90% of my KZbin watching are tutorial videos. This one tops them all when it comes to explaining it, examples, variations, testing, etc. And yes, the audio was pleasant too :)
@64mustangfan
@64mustangfan 4 жыл бұрын
Fabulous! You became my lockdown tutor, with a clear, smooth and pleasant voice, well paced and delivered. In particular, you explain the smallest things, - you must have dropped 100 Excel tips in passing, and even though I use Excel frequently I'd unlearned some useful basics I don't always use, like a double click to auto fill. This is a standard of how great tutorials should be done, thank you :-)
@tysamuels
@tysamuels Жыл бұрын
This VBA training series is absolutely phenomenal. Thank you very much, Chelsea!
@LearnitTraining
@LearnitTraining Жыл бұрын
You're so welcome! Chelsea will be back on 9/21 covering Loop Structures
@ahmedamr7508
@ahmedamr7508 4 жыл бұрын
This tutorial is by far one of the best tutorials ever, the methodology is very good, even if used with any other topic especially programming. Instead of spending 10+ lessons learning how to print silly message on the screen and doing loops and conditional formatting, you start doing some useful examples and get your hands on with real, yet simple scenarios. I would really recommend your channel for anyone who want to learn anything, not just Excel. Please it going :)
@sridharsockalingam7031
@sridharsockalingam7031 4 жыл бұрын
This course was the best among several I tried out recently. It assumes that you do not know anything or very little about Macros and VBA and walks you thru them step by step. Absolutely great teaching method. Very well paced and with clear explanations and examples. The downloadable files make it so easy to practice as well. Thank you for the excellent course!!
@sagarn6481
@sagarn6481 2 жыл бұрын
Please teach me how to download this practice file
@MotoMadV4
@MotoMadV4 3 жыл бұрын
I've only just started listening to this (earphones) and the presentation in terms of audio is fully engaging and exciting. You will have me for over 2 hours
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you for watching!
@Kershekm
@Kershekm 3 жыл бұрын
One of the best tutorials I've seen -- just because the lecturer makes it so understandable in her structure of instruction. But more importantly, she has a great personality for teaching... which is an intangible characteristic that is 100x more valuable than the actual content of the instruction. The company who employs her is very lucky.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Wow, thank you!
@mohamedtalaat2470
@mohamedtalaat2470 4 жыл бұрын
From Egypt, It's really an excellent video, I loved your way so much, will go to the next level, Thank you!
@zipperman4558
@zipperman4558 4 жыл бұрын
Although I am not professionally using Excel, I started to use Macro’s after watching your 2 hours course. I greatly benefited and appreciate your support. Your explanations were very clear to me. Thanks very much 😀😀 You are really a great teacher. If you have some other posts I would like to know about them.
@masummahdy8241
@masummahdy8241 Жыл бұрын
This video is just awesome. I am a writer (of Excel-related content) in a company and lead a team but had weakness in VBA. So I came to here. This lady is just awesome. I am speechless. I am going to finish the rest two videos and going to find if there is anymore videos of this lady.
@LostAlienOnEarth
@LostAlienOnEarth 3 жыл бұрын
Best Excel teacher ever. I've programming in VBA for Excel for a couple of years now, but I wish I had a teacher like that in the beginning.
@fosiebear
@fosiebear 3 жыл бұрын
Thanks so much Eduardo! I'll bet you could teach this yourself by now :)
@jkmung2009
@jkmung2009 4 жыл бұрын
I have tried several courses recently but couldn't anywhere. But with this one, it was just excellent in terms of the method - and the voice was wow!
@jloo1900
@jloo1900 4 жыл бұрын
Best VBA lesson I have take so far. I bought many books but lost interest on the complexity. Thanks for making it so simple and interestingly. God bless you, Dan and team in this channel
@melroseali762
@melroseali762 3 жыл бұрын
the COMPLEXITY WHY:-)
@jessicatisdale9332
@jessicatisdale9332 2 жыл бұрын
Wow, this has got to be one of the best coding videos of all time. What a wonderful teacher! If my CS teacher at University was half as skilled or as passionate as this instructor, I probably would have gone into programming as a profession (or at least a hobby). When my kids are old enough, I'll make sure that they are exposed to this video. If they were meant to code, I'm sure that this video would be their power-on switch. Thank you for this incredible video Learnit!!! Where can I find more courses by this instructor?
@faruqhsj
@faruqhsj 3 жыл бұрын
Thank you dear teams of Learnit Training. I am very impressed by the careful illustrations and lovely instructions by Chelsea Dohemann ! May the Scientific-Almighty ( all-knowing Almighty) bless her all the best of health, safety and peaceful progress in life !
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you for the kind words Faruqhsj!
@millertime6
@millertime6 4 жыл бұрын
This is how you teach! I like when they consider the learner first when instructing.
@nkehli
@nkehli 4 жыл бұрын
I am loving this course. Thank you for sharing your knowledge with us all, and in such a clear manner too.
@lillianw83
@lillianw83 Жыл бұрын
Girl, your enthusiasm, vibrancy and way of explaining this is BEAUTIFUL! It makes it energetic and fun! Thank you!
@LearnitTraining
@LearnitTraining Жыл бұрын
You are so welcome!
@iskandar_356bc6
@iskandar_356bc6 3 жыл бұрын
she has a marvelously soothing voice that can be heard for hours 🙌 ✨
@baohannguyen9994
@baohannguyen9994 4 жыл бұрын
I'm a newbie in VBA Excel. Thank God that I found this invaluable video. Thank u.
@pravinshingadia7337
@pravinshingadia7337 4 жыл бұрын
Really excellent video. I've been using Excel for years and still learnt a lot of new things. The tutorial is really well prepared and presented.
@sadflame8400
@sadflame8400 3 жыл бұрын
really excel-lent video for sure
@user-wt7nw2mc2e
@user-wt7nw2mc2e Жыл бұрын
I just started to learn the VBA concept recently and this tutorial is really helpful. I watch it for around 10mins every day to let myself have proper time to digest the steps and understand the logic behind them. Thanks a lot for your efforts!
@LearnitTraining
@LearnitTraining 11 ай бұрын
You're very welcome!
@jdbrookins
@jdbrookins Жыл бұрын
This is by far the best beginner VBA training I've ever come across. The teacher is hands down one of the best too. Give her a raise.
@LearnitTraining
@LearnitTraining Жыл бұрын
Thank you for the kind words! We think Chelsea is great as well!
@alanf5615
@alanf5615 4 жыл бұрын
Best tutorial I have seen in years The voice work and arrow and mini reviews for each step are exceptional. I will use these techniques when I return to teaching and will recvomend your channel to my students Thank you
@fosiebear
@fosiebear 3 жыл бұрын
Thanks so much Alan :) Learnit's channel is a goldmine!
@alanf5615
@alanf5615 3 жыл бұрын
@@fosiebear really couldn't agree more I wish they would just use these videos in college instead of outdated professors teaching things that worked in 1999
@bohdantashak6312
@bohdantashak6312 4 жыл бұрын
Amazing dedication to teaching the subject matter at hand, and getting the lesson across. Thank you! will watch more educational videos from you.
@DrRiq
@DrRiq 3 жыл бұрын
I listened to this on 2x speed. Her voice is clear and pleasant, and her little tips and hints really make watching the whole thing worthwhile rather than just skipping bits. Really great tutorial.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Wow, thank you!
@andrewlim5048
@andrewlim5048 3 жыл бұрын
If only all my ex-teachers have such beautiful voices ...
@fibonnaxsolomon8824
@fibonnaxsolomon8824 2 жыл бұрын
Now I'm trying to imagine Mr. Thornton, my 5'5" 240lbs Chemistry teacher with that voice .... nope ...
@ravitandon07
@ravitandon07 3 жыл бұрын
I have searched unlimited videos around VBA and even purchased a course via Udemy but was still not able to understand the details as I didn't have any technical/ coding experience. But after going through this videos i am very happy as I am able to understand the basic stuff and the way you have explained each topic is simply awesome. I would love to go through more of your videos :)
@pilifracchia
@pilifracchia 4 жыл бұрын
Thank you so much for this tutorial. Super clear!! I was able to go through the exercises without problems or doubts. Great teacher and great content. Thanks again!
@denisesimon5703
@denisesimon5703 3 жыл бұрын
What a great tutorial. I am retired from a computer company with knowledge of programming but not visual basic. I do scoring for a golf league and set up templates/spreadsheets for the different formats of play. I have been adding formulas to the spreadsheets and changing the values manually for the formulas. I can now create macros to make this so much easier. Thank you.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Glad it was helpful!
@deninsrmic4165
@deninsrmic4165 2 жыл бұрын
This was brilliant tutorial, very well explained and to the point with concise explanations as examples. It took me couple of days to go through entire two hours with exercising and pondering beyond what was presented within tutorial. I was also keen to learn basics of Macro recording as I am working on a project that has many repetitive task but didn't know much about Macro Recording as VBA Script. Now I want to learn more to make my life easier in Excel. Not being versed before in VBA Script this tutorial and some of the books I am using I am more confident to embrace second level of VBA Tutorial. Many thanks for presenting VBA knowledge to us.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Thank you so much for watching Denin! We are glad you learned so much!
@cpino1
@cpino1 4 жыл бұрын
One thing I can tell... Chelsea Dohemann is a great teacher... will love to see more learning from her...
@randyhaimila6476
@randyhaimila6476 3 жыл бұрын
Agreed. I enjoyed listening to her. She knows what she's talking about, and presents it clearly and organized.
@douglasveltz3518
@douglasveltz3518 4 жыл бұрын
I set out to leave this comment thinking I would wow you with a compliment about your uniquely amazing and pleasant voice, only to find that nearly everyone noticed it and mentioned it. It is more than a great voice...it is the "perfect teaching voice") ...a concept I thought I had just invented until I saw others below use this same term. Don't let all this fuss about your voice take anything away from the other aspects of this tutorial. You are well-organized and your presentation is flawless. Someone below said you should do ALL of the KZbin tutorials. While I wholeheartedly agree with him...there is part of me that thinks you should be teaching teachers how to speak. It would be a smarter world. Amazing job, Chelsea!!!
@Lantze47
@Lantze47 2 жыл бұрын
Well paced lecture, “interactive” exercises, excellent course. Great job in putting the material together. Highly recommend this course!!! You will learn a lot and appreciate VBA.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Much appreciated!
@tlc1795
@tlc1795 3 жыл бұрын
This is the best basic VBA tutorial I have found and I have spent hours searching. Very much worth every second. I’m so excited to use the skills and watch the advanced. Seriously, thank you so much!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You're very welcome!
@SkyRanger999
@SkyRanger999 4 жыл бұрын
Your voice is so clear. I love it. Thank you for delivering this tutorial!
@khadeerhussain
@khadeerhussain 4 жыл бұрын
So well explained. Brilliant, thank you ✌️
@pinoydataanalyst1705
@pinoydataanalyst1705 10 ай бұрын
I think this is the best VBA tutorial I have seen. it is so comprehensive I am not having the feeling of just executing fancy or prepared codes but instead really understanding the core of VBA. Thank you for the lessons.
@LearnitTraining
@LearnitTraining 10 ай бұрын
You are very welcome!
@venkatiyer7459
@venkatiyer7459 Жыл бұрын
Extremely useful course and the way in which it is taught is absolutely outstanding. I'll be honest in saying that now I'll be confident enough to write VBA / understand the script written by others. Thank you very much.
@LearnitTraining
@LearnitTraining Жыл бұрын
Thank you so much for watching!
@leviretanan8496
@leviretanan8496 4 жыл бұрын
You are an amazing teacher. I learned a lot from this video . The flow of the delivery of the content is excellent. Thank you so much.
@souravkar5321
@souravkar5321 4 жыл бұрын
It's better than the beginner level Excel VBA courses in paid platforms like Udemy. Thank you so much for helping so many people.
@johnessien2167
@johnessien2167 Жыл бұрын
I'm close to finishing the first part of this course and I thought it would not be fair to wait till I finish the 3-part course before singing the praise of the quality and clarity of this course. I have read in my research about VBA that it is a fairly difficult language but this tutor makes it feel like cutting through butter with a hot knife. I guess I'm fortunate that unlike many people here who had to wade through much less intuitive courses before finding this one, I found this as my introduction to VBA. This is a very very well put together material. Thank you so much to the instructor and her soothing voice, and also a big thank you to the people who have put this course together. Y'all are the real MVPs!!!!
@LearnitTraining
@LearnitTraining Жыл бұрын
Happy to help!
@mssimonewilson
@mssimonewilson 3 жыл бұрын
OMGoodness Thank you for this Video I love how you get straight to the point no jargon or fluff and just teach us. This is awesome, I will be doing the Advance VBA Next. WooHoo!!!
@Mahesh-nu4hi
@Mahesh-nu4hi 4 жыл бұрын
Your voice is clear,crisp, attractive and examples are much interesting...
@kensimba7868
@kensimba7868 3 жыл бұрын
The best by far VBA tutorials one can ever get. I knew nothing about VBA but now I feel there's no challenge I can't solve with VBA. God bless you mightily ma'am Chelsea
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you for the kind words Ken!
@MrEagle19081978
@MrEagle19081978 2 ай бұрын
I just love how this class is taught. I have sat in different classes in the past and have not completed the KZbin sessions. However, this class and how this person explains is outstanding. Thank you for posting here.
@LearnitTraining
@LearnitTraining Ай бұрын
Wow, thank you!
@verica6408
@verica6408 4 жыл бұрын
You know she is a great instructor when playing the video in 1.5 speed and still understand her perfectly. Thank for this helpful tutorial.
@rajata2819
@rajata2819 4 жыл бұрын
after listening your voice just for one min i am in comment section giving you compliment about it. but i am not sure it's a robot voice or a real person voice. it just so pleasant. I wish my teacher would have that pleasant voice
@frankmueller25
@frankmueller25 3 жыл бұрын
Doubt a robot could come up with all the appropriate tone changes she has. Yes, she is a good narrator, and probably a charming person to talk to.
@geoffstilwell4124
@geoffstilwell4124 3 жыл бұрын
I love the way you use 'real-life' examples rather than examples that show the code working but not why you might use it. Thank you!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Glad it was helpful!
@rahuldey6369
@rahuldey6369 2 жыл бұрын
No course can teach you Excel VBA better than this. Kudos to the instructor and feel blessed that these materials are available for free
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Wow, thank you!
@dbmonsales
@dbmonsales 4 жыл бұрын
Not just great audio, also well explained. Highly recommended.
@alirazzaq1541
@alirazzaq1541 4 жыл бұрын
Thanks a lot. I just completed the first video and practiced all the assignments. I heard about Macros in my college days but due to non-programming background always avoided them. Now after taking this course, with the pleasant voice of the instructor, I am feeling confident and want to master Macros. Gonna share this with all my friends. Love from Pakistan.
@sandunthilina8478
@sandunthilina8478 Жыл бұрын
One of the best tutorial I ve taken. I knew nothing abour macros. Now I feel, I can do it. Thanks Chelsea and team.
@LearnitTraining
@LearnitTraining Жыл бұрын
Our pleasure!
@brunocaruso1082
@brunocaruso1082 Жыл бұрын
This tutorial and the Teacher is the best I have ever found on the tube. Not boring at all, quick, clear, easy to follow, extremely detailed and fun all at the same time. Watched twice the first video of this series and I am going to start advanced one. Basically I didn't know anything about VBA with only 1 hour I got lots of information and I can even code simple procedures myself. The perfection for a tutorial
@LearnitTraining
@LearnitTraining Жыл бұрын
Thank you Bruno for the kind words!
@brino7168
@brino7168 4 жыл бұрын
I am sure VBA is complex the more you delve into it BUT your approach deals perfectly with this awe one might have at the start of the journey. Thank you veru much indeed. Well, one can't forget about commenting on the voice either :)
@navjotsingh2251
@navjotsingh2251 3 жыл бұрын
I think the main complex things with vba is memory management and regular expressions. At least these are very hard for me.
@Vishy106
@Vishy106 3 жыл бұрын
She is doing a great job with her style of teaching and her pleasant voice. Keep it up!
@idegwuagejiageji7461
@idegwuagejiageji7461 13 күн бұрын
I love how you sound… you make it easy to understand. my brain does not feel stressed or behind when I’m learning from you.. you are an amazing teacher.
@LearnitTraining
@LearnitTraining 8 күн бұрын
Thanks!
@danttswestsac5269
@danttswestsac5269 4 ай бұрын
I've just started this tutorial, but I'm already very impressed with this lady instructor. She's amazing and has a captivating voice that motivates me to pay attention and participate. Thank you!!
@LearnitTraining
@LearnitTraining 4 ай бұрын
Thank you so much Dantts! We hope you learn everything you wanted about VBA! Also thank you for being a member!
@umanggarg970
@umanggarg970 4 жыл бұрын
Wowwww! you're a superb communicator!
@janetuchlinski6421
@janetuchlinski6421 3 жыл бұрын
The best video tutorial EVER!! Been intimidated by VBA for years and now, thanks to you, it's suddenly not so scary anymore! Kudos!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you for watching Jane! We are glad we were able help!
@loosethread8754
@loosethread8754 2 жыл бұрын
The pace of the way you talk is just perfect. Most of the times when I watch tutorials is I go 1.5x, even 1.75x sometimes. But here, 1x is just 👌
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Thank you for the kind words Ludwig!
@cynthiadurrett2853
@cynthiadurrett2853 2 жыл бұрын
This tutorial is a great hands-on introduction to Excel macros and VBA. The course builds on itself and gives plenty of opportunity to practice what is presented. I will definitely look for other training from Learnit.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You're very welcome!
@oscaralfonsohermelo2572
@oscaralfonsohermelo2572 4 жыл бұрын
Great video, well explained. Hope you keep making tutorials for Excel. Would like to see something about Power Pivot, Power Query or User forms. Just an idea...
@mayavia75
@mayavia75 4 жыл бұрын
Hi Chelsea, your tutorials are excellent I like it very much and it's very helpful. Keep doing things like this. Thank you very much !!
@lornagalea6035
@lornagalea6035 3 жыл бұрын
I have learnt so much. From knowing nothing about coding or Macros or VBA, I have a huge understanding of it now. Needing to create a document and wanting it to be interactive lead me to watch this. Very well presented and easy to understand. It was great to practice along the way also. Thank you very much (Australia)
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You are very welcome Lorna! Thank you for watching!
@LCastejon
@LCastejon 6 ай бұрын
I have done a pretty good job over the years of being able to find the code I needed online and tweaking for my needs. I’m at the point in my career where I want to UNDERSTAND what I’m doing and be able to write a script from scratch. After many, many videos, I am so glad I found this one! Other instructors just tell you what to type! This is the only video that actually explains objects/methods/properties as well as debugging tips. I’ve had so many aha moments and it so less overwhelming to me now than it was this morning. You are fantastic, thank you so much. .
@LearnitTraining
@LearnitTraining 6 ай бұрын
Thank you so much for the kind words! We are glad you had so many aha moments and learned so much!
@dagranaresh
@dagranaresh 4 жыл бұрын
Teaching and explanation level is really great.
@carmcam1
@carmcam1 3 жыл бұрын
internet is such a nice place if use properly, i want to learn vba..this lockdown sure gave us a lot of free time.
@siddharthc6364
@siddharthc6364 2 жыл бұрын
Definitely the best course on youtube for begineer macros. Tried more than 10+ vids and giving this conclusion. Thank you for the content.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Hi Siddharth C! Thank you for the kind words and an extra big thank you for subscribing!
@user-uf8bk6lk2o
@user-uf8bk6lk2o Жыл бұрын
I just started the course, and I love this instructor, clear and concise.
@LearnitTraining
@LearnitTraining Жыл бұрын
Thank you for watching!
@dioncadiz
@dioncadiz 4 жыл бұрын
2 minutes in and I already like the video just because of the speaker. Just one of those pleasant voices you'd really listen to.
@bernsdomingo337
@bernsdomingo337 4 жыл бұрын
I'm trying to learn VBA Macro while in Lockdown. This is a really great video!
@shahrinm2640
@shahrinm2640 4 жыл бұрын
same here :)
@marymitchell5053
@marymitchell5053 4 жыл бұрын
Me too!
@jennifer476
@jennifer476 4 жыл бұрын
Same here
@jagmeetsond6075
@jagmeetsond6075 4 жыл бұрын
me too hopefully l am going to start
@lakshmideenuru4538
@lakshmideenuru4538 4 жыл бұрын
try for tutorial point its helping us nicely i am taking classes from that video free.
@WiliamBennettwildarbennett
@WiliamBennettwildarbennett Жыл бұрын
Well Im a bit slow for 2 hour class, so 16 hours later and 8 notebook pages later, I've learned more than I ever did out a book Thank You. This Lady is 1 of the best instructors I've ever had.
@LearnitTraining
@LearnitTraining Жыл бұрын
Chelsea is an amazing instructor!
@carissacassano681
@carissacassano681 3 жыл бұрын
With the help of your videos I was able to fix my first VBA bug today for an employer. Great feeling! Thank you so much!! PS. I agree with others, you have a very nice voice and demeanor.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Hi CassaRissa that is great to hear!
@chandrakantbhosle
@chandrakantbhosle 4 жыл бұрын
Excellent presentation and content of the tutorial ... thanks for helping others
@LearnitTraining
@LearnitTraining 4 жыл бұрын
Thank you for the kind words Chandrakant!
@vasanthviswa7295
@vasanthviswa7295 4 жыл бұрын
I am Loving it, Great Tutor! Hats off to you:)
@drben3224
@drben3224 Жыл бұрын
Thank you Chelsea Dohemann for presenting such a wonderful Excel VBA class. You presented this course using basic adult learning theory principles. Your voice was very pleasing, easy to understand, and clear. I was able to follow along with you during the course with ease. The content material was what I needed for my Excel projects. I look forward to other courses presented by you. Thank you again for your time and energy in producing this class!!!
@LearnitTraining
@LearnitTraining Жыл бұрын
Thank so much for the kind words Dr. Ben!
@drben3224
@drben3224 Жыл бұрын
You are most welcome. Please keep up the good work!
@arunshinde1507
@arunshinde1507 3 жыл бұрын
This is an extremely well designed course for beginners in scripting vb macros. The course materials allow you to demonstrate simultaneously on your desktop and feel the things happening as you proceed with the trainer. Appreciate the efforts put forth to create this module and release it on youtube.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you again Arun! You are our favorite viewer!
@shirleykyburz25
@shirleykyburz25 3 жыл бұрын
The most pleasant experience I've had learning an application. Will continue with Learnit.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Great to hear!
Excel VBA Advanced Tutorial
1:57:23
Learnit Training
Рет қаралды 1 МЛН
Excel 2021 VBA Advanced Tutorial
1:35:59
Learnit Training
Рет қаралды 27 М.
Is it Cake or Fake ? 🍰
00:53
A4
Рет қаралды 19 МЛН
⬅️🤔➡️
00:31
Celine Dept
Рет қаралды 40 МЛН
IS THIS REAL FOOD OR NOT?🤔 PIKACHU AND SONIC CONFUSE THE CAT! 😺🍫
00:41
Excel Macros & VBA - Tutorial for Beginners
50:20
Kevin Stratvert
Рет қаралды 1,1 МЛН
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 190 М.
Excel Power User Tutorial
2:30:50
Learnit Training
Рет қаралды 7 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 438 М.
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 67 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 291 М.
High-Income Excel Skills Worth Learning in 2024 (Free File)
29:19
MyOnlineTrainingHub
Рет қаралды 311 М.
50 Ultimate Excel Tips and Tricks for 2020
50:17
Sele Training
Рет қаралды 1,8 МЛН
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 234 М.
Is it Cake or Fake ? 🍰
00:53
A4
Рет қаралды 19 МЛН