The link to the exercise files is in the video description
@abnerkamps16693 жыл бұрын
subbed*** I could not find the file with the phone numbers.... the one used at 27:51
@abnerkamps16693 жыл бұрын
Just kidding @ JugglingMike saved the day
@pkushanth55263 жыл бұрын
@@abnerkamps1669 hey! Could you help me with the simple macros file?
@abnerkamps16693 жыл бұрын
@@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.
@wijesiriwardaneus3 жыл бұрын
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
@RedDogByrd2 жыл бұрын
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!
@LearnitTraining2 жыл бұрын
Thank you so much for the kind words Jim!
@anh4bap4262 жыл бұрын
Totally agreed. She is great.
@Ooko.2 жыл бұрын
@@LearnitTraining It's true! very helpfull, thank you!
@hedhtr4 Жыл бұрын
I agree
@tamarsimonishvili4236 Жыл бұрын
could not agree more.
@ecashmarketing3 жыл бұрын
I am jobless and learning VBA for a job interview. Just want to thank you for your service.
@LearnitTraining3 жыл бұрын
Good luck on the interview!
@ahanapal40553 жыл бұрын
All the best for your career ahead!
@157abhishekkumar59 ай бұрын
Did you get job buddy?
@cbmcbm28452 ай бұрын
Learning is a good job to begin with
@C-level-xd6mx17 күн бұрын
Did you get a job?
@paristmo7 ай бұрын
No music and overly excited speech, just direct and straight-to-the-point detailed guidance; all tutorial should be like this.
@LearnitTraining7 ай бұрын
We think so too!
@PaulRhee-gp8zu7 ай бұрын
RIght? getting to the core of how to understand VBA instead of just giving specific situations.
@Naruto-xd7fk5 ай бұрын
can you share the practice file
@HoTSp1Ke072 ай бұрын
Why would a 79 year old will watch a 5 hour long video and too of something which he is very experienced about
@adamarzate153321 күн бұрын
Facts 👏
@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 Жыл бұрын
Thank you so much!
@hellopsp1804 жыл бұрын
Is it just me or is the audio really pleasant to the ears?
@douglasveltz35184 жыл бұрын
I thought it was just me!
@regal_78774 жыл бұрын
Damn I'm not alone
@MrROFLKNIFE4 жыл бұрын
VBA ASMR 10 hours
@ansalc4 жыл бұрын
I fully agree. She has a very crisp and pleasant-to-hear English.
@rariscool45484 жыл бұрын
IT IS LOUD
@danttswestsac526911 ай бұрын
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!!
@LearnitTraining11 ай бұрын
Thank you so much Dantts! We hope you learn everything you wanted about VBA! Also thank you for being a member!
@stevegerol58394 жыл бұрын
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.
@LearnitTraining4 жыл бұрын
Wow, thank you!
@lesnyk2554 жыл бұрын
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.
@bronteparker13213 жыл бұрын
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!
@LearnitTraining3 жыл бұрын
You are very welcome Bronte! We are happy to hear you learned so much!
@iClone3162 жыл бұрын
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).
@JamesGirardi694 жыл бұрын
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 :)
@maldighaithir4 жыл бұрын
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
@johnkim32573 жыл бұрын
Super video! I applauded for $2.00 👏
@LearnitTraining3 жыл бұрын
Thank you so much John! It helps tremendously!
@sridharsockalingam70314 жыл бұрын
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!!
@sagarn64812 жыл бұрын
Please teach me how to download this practice file
@ranjitjojo7 ай бұрын
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...
@LearnitTraining6 ай бұрын
Thanks!
@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 Жыл бұрын
Chelsea is an amazing instructor!
@artifaxiom3 жыл бұрын
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!
@andrewmathew82203 жыл бұрын
not all heros wear a cape, ty
@kamol9013 жыл бұрын
Can you please share the download link?
@artifaxiom3 жыл бұрын
@@kamol901 it's in the description
@kamol9013 жыл бұрын
I saw the exercise file link to a zip file, when I unzip I do no see the excel file. Thanks
@artifaxiom3 жыл бұрын
@@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?
@alexinivai082 жыл бұрын
This has got to be the best beginner's course I've had. Well-made, easy to comprehend. Please never stop creating content.
@LearnitTraining2 жыл бұрын
Thanks, will do!
@Amitsa2993 жыл бұрын
Super video! I applauded for ₹100.00 👏👏
@LearnitTraining3 жыл бұрын
Thank you so much 😀
@ahmedamr75084 жыл бұрын
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 :)
@anitaadiki45733 жыл бұрын
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!!!!
@LearnitTraining3 жыл бұрын
Thank you for the kind words Anita Adiki! We are glad the videos are so helpful!
@justinlife9223 жыл бұрын
@@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
@nrpats3 жыл бұрын
Super video! I applauded for ₹40.00 👏
@LearnitTraining3 жыл бұрын
Thank you! 😃 It means so much!
@LostAlienOnEarth3 жыл бұрын
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.
@fosiebear3 жыл бұрын
Thanks so much Eduardo! I'll bet you could teach this yourself by now :)
@alanf56154 жыл бұрын
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
@fosiebear3 жыл бұрын
Thanks so much Alan :) Learnit's channel is a goldmine!
@alanf56153 жыл бұрын
@@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
@legendaryrababa3 ай бұрын
i am self tought programer, i got ms web certificate, i watched countless videos on udemy and youtube. this is the best teaching program I have ever experienced. I enjoyed every single second of it. good job!!!
@LearnitTraining3 ай бұрын
Wow, thank you!
@MotoMadV43 жыл бұрын
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
@LearnitTraining3 жыл бұрын
Thank you for watching!
@lillianw83 Жыл бұрын
Girl, your enthusiasm, vibrancy and way of explaining this is BEAUTIFUL! It makes it energetic and fun! Thank you!
@LearnitTraining Жыл бұрын
You are so welcome!
@Kershekm3 жыл бұрын
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.
@LearnitTraining3 жыл бұрын
Wow, thank you!
@douglasveltz35184 жыл бұрын
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!!!
@jloo19004 жыл бұрын
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
@melroseali7623 жыл бұрын
the COMPLEXITY WHY:-)
@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 Жыл бұрын
Thank you for the kind words! We think Chelsea is great as well!
@cpino14 жыл бұрын
One thing I can tell... Chelsea Dohemann is a great teacher... will love to see more learning from her...
@randyhaimila64764 жыл бұрын
Agreed. I enjoyed listening to her. She knows what she's talking about, and presents it clearly and organized.
@zipperman45584 жыл бұрын
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.
@arhanname876915 күн бұрын
The tone of your voice is mesmerizing how beautiful you look ! with just your voice I could listen to your lectures all day long
@LearnitTraining14 күн бұрын
Appreciate the compliment!
@loosethread87543 жыл бұрын
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 👌
@LearnitTraining3 жыл бұрын
Thank you for the kind words Ludwig!
@geoffstilwell41243 жыл бұрын
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!
@LearnitTraining3 жыл бұрын
Glad it was helpful!
@aminderkhungura79293 жыл бұрын
Super video! I applauded for CA$2.00 👏
@LearnitTraining3 жыл бұрын
Wow! Thank you so much Aminder! It all helps us to continue to produce new videos!
@patricdaniel56014 жыл бұрын
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.
@jkmung20094 жыл бұрын
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!
@billbunkum75872 жыл бұрын
Hands down, the best narrator I've heard in a very long time. I think you could do most anything and make it better. Well done!
@LearnitTraining2 жыл бұрын
Thank you for the kind words!
@vericamedia4 жыл бұрын
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.
@64mustangfan4 жыл бұрын
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 :-)
@Pioneer_Inspire_Empower5 жыл бұрын
Chelsea, your tutorials are quite simply outstanding. Your preparation and delivery of the content is superb!
@ravitandon074 жыл бұрын
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 :)
@ArtemTroitsky3 жыл бұрын
Super video! I applauded for RUB 200.00 👏👏👏
@LearnitTraining3 жыл бұрын
Wow, thanks! Every applause helps tremendously!
@tlc17953 жыл бұрын
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!
@LearnitTraining3 жыл бұрын
You're very welcome!
@vijayendrashenoypadav23704 жыл бұрын
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.
@muftahmohamed896329 күн бұрын
My first time to spend as much time to learn VBA, well-structured material and it is straight to the point and easily understood. Thanks, a lot.
@LearnitTraining29 күн бұрын
You are very welcome!
@souravkar53214 жыл бұрын
It's better than the beginner level Excel VBA courses in paid platforms like Udemy. Thank you so much for helping so many people.
@jiojio4 жыл бұрын
You earned a trophy! Learn VBA during Lockdown
@fosiebear3 жыл бұрын
This made me laugh out loud, Marc, I needed that :D
@johnessien21672 жыл бұрын
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!!!!
@LearnitTraining2 жыл бұрын
Happy to help!
@user-uf8bk6lk2o2 жыл бұрын
I just started the course, and I love this instructor, clear and concise.
@LearnitTraining2 жыл бұрын
Thank you for watching!
@andrewlim50483 жыл бұрын
If only all my ex-teachers have such beautiful voices ...
@fibonnaxsolomon88243 жыл бұрын
Now I'm trying to imagine Mr. Thornton, my 5'5" 240lbs Chemistry teacher with that voice .... nope ...
@cuba_rj3 жыл бұрын
I have to admit that is a lot of high quality and free content about the basics of VBA. Impressive! I salute you guys, that´s how it is done!
@LearnitTraining3 жыл бұрын
Our pleasure!
@MidoCounters2 жыл бұрын
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.
@LearnitTraining2 жыл бұрын
We are glad you are learning so much!
@iskandar_356bc63 жыл бұрын
she has a marvelously soothing voice that can be heard for hours 🙌 ✨
@rahuldey63693 жыл бұрын
No course can teach you Excel VBA better than this. Kudos to the instructor and feel blessed that these materials are available for free
@LearnitTraining3 жыл бұрын
Wow, thank you!
@hulahala40652 жыл бұрын
There is a typo at 1:56:12 where you type in Sheet(1), instead of Sheets(1). The former was giving me a "Sub or Function not defined" error.
@LearnitTraining2 жыл бұрын
Noted!
@hulahala40652 жыл бұрын
@@LearnitTraining Thanks for the very informative Tutorial!! I can't believe you guys have it here for free!!! This is the most well articulated and detailed Tut I have seen on VBA!
@Ali26922 жыл бұрын
It didn't rename Sheet2 and Sheet3. I'm confused
@Mahesh-nu4hi4 жыл бұрын
Your voice is clear,crisp, attractive and examples are much interesting...
@MrEagle190819788 ай бұрын
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.
@LearnitTraining8 ай бұрын
Wow, thank you!
@faruqhsj4 жыл бұрын
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 !
@LearnitTraining4 жыл бұрын
Thank you for the kind words Faruqhsj!
@iykkevin2 жыл бұрын
Damm, this is fantastic work. I am going to recommend this video to my professor. I am taking ME415, and this video has done most of my professor's job. Although the project is not like copying and pasting, but once you understand the VBA concept, you get 100% doesn't matter how you choose to apply it. Thank you very much.
@LearnitTraining2 жыл бұрын
Please do! We are glad you learned so much!
@pinoydataanalyst1705 Жыл бұрын
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 Жыл бұрын
You are very welcome!
@baohannguyen99945 жыл бұрын
I'm a newbie in VBA Excel. Thank God that I found this invaluable video. Thank u.
@shahbazalikhan18254 жыл бұрын
Never felt educational video this much interesting... Hats off to your work!🎓
@LearnitTraining4 жыл бұрын
Thanks a lot 😊
@carissacassano6813 жыл бұрын
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.
@LearnitTraining3 жыл бұрын
Hi CassaRissa that is great to hear!
@tysamuels2 жыл бұрын
This VBA training series is absolutely phenomenal. Thank you very much, Chelsea!
@LearnitTraining2 жыл бұрын
You're so welcome! Chelsea will be back on 9/21 covering Loop Structures
@dixiwu21748 ай бұрын
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
@LearnitTraining8 ай бұрын
We try to have a wide and diverse variety of instructors!
@narasimhadasari9828 Жыл бұрын
I want to do a project on vba and macros today, so I quickly opened youtube and searching for different channels videos, but I'm not feeling I'm learning, accidentally I clicked on this playlist, then boom, excellent work by the tutor, very easy to grasp and to follow up. Thank You, I hope I revisit this channel weekly for more content like this
@LearnitTraining Жыл бұрын
You can do it!
@RishabhGKoenigseggRegera4 жыл бұрын
Not sure why there's even a single dislike here. This video was amazingly clear, and the exercise files were all easy to use.
@LearnitTraining4 жыл бұрын
Thank you Rishabh! We hope you learned a lot!
@rajata28194 жыл бұрын
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
@frankmueller254 жыл бұрын
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.
@whetstoneguy67173 жыл бұрын
The instructor is very clear. This is an excelent video and for me is much easier than reading a book about VBA.
@LearnitTraining3 жыл бұрын
Glad it was helpful!
@leviretanan84965 жыл бұрын
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.
@bernsdomingo3374 жыл бұрын
I'm trying to learn VBA Macro while in Lockdown. This is a really great video!
@shahrinm26404 жыл бұрын
same here :)
@marymitchell50534 жыл бұрын
Me too!
@jennifer4764 жыл бұрын
Same here
@jagmeetsond60754 жыл бұрын
me too hopefully l am going to start
@lakshmideenuru45384 жыл бұрын
try for tutorial point its helping us nicely i am taking classes from that video free.
@denizceylan81203 жыл бұрын
This is one of the best Videos I have ever seen on KZbin. I am shocked that this is free available. Thank you so much ! I am learning VBA during Quarantine...
@LearnitTraining3 жыл бұрын
You're very welcome!
@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 Жыл бұрын
Thank you Bruno for the kind words!
@SteelStrung3 жыл бұрын
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!
@LearnitTraining3 жыл бұрын
Glad you enjoyed it!
@paulang82673 жыл бұрын
This is the only class i have attended without sleeping, clarity was the stimulant. Thanks!
@LearnitTraining3 жыл бұрын
Thank you for watching Paul!
@millertime64 жыл бұрын
This is how you teach! I like when they consider the learner first when instructing.
@jessicatisdale93323 жыл бұрын
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?
@MrDFJohnson3 жыл бұрын
Thank You. Excellent content and presentation. Clear, articulate, well paced and easy to understand speech. Excellent visuals. No thick accent, muffled, marbles in your mouth speech. Pleasant and engaging voice. What a RELIEF!
@LearnitTraining3 жыл бұрын
You're very welcome!
@pravinshingadia73374 жыл бұрын
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.
@sadflame84004 жыл бұрын
really excel-lent video for sure
@dde9100394 жыл бұрын
how does her voice so clear and stable like robot but at the same time so humain ...
@dm_grant4 жыл бұрын
Her name is Chelsea.
@yunlong43554 жыл бұрын
@@dm_grant What accent is this? It's beautiful!
@dm_grant4 жыл бұрын
@@yunlong4355 American?
@vinod4404 жыл бұрын
kzbin.info/www/bejne/e2Hbc2yXrtp-Y8U pls like and subscribe Learn excel and VBA fourmulas
@Paper_Trader3 жыл бұрын
Either she uses AutoTune like Demi Lovato or She has a macro code written already to make it sound this soothing.
@LCastejon Жыл бұрын
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 Жыл бұрын
Thank you so much for the kind words! We are glad you had so many aha moments and learned so much!
Idk if you will see this, but i was wondering for the SS# macro, once you finish replacing all the numbers with ***-**, how will you know what the first 5 digits are in case you need them down the line? It seems the macro replaces those values with "*", is there any way to undo or check the values? Thanks.
@deninsrmic41653 жыл бұрын
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.
@LearnitTraining3 жыл бұрын
Thank you so much for watching Denin! We are glad you learned so much!
@sebastiangillesberg29 күн бұрын
Got to say this is the best tutorial I have found on Macros and VBA and the best part is is free.
@LearnitTraining29 күн бұрын
Thank you!
@venkatiyer74592 жыл бұрын
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.
@LearnitTraining2 жыл бұрын
Thank you so much for watching!
@SkyRanger9995 жыл бұрын
Your voice is so clear. I love it. Thank you for delivering this tutorial!
@siddharthc63643 жыл бұрын
Definitely the best course on youtube for begineer macros. Tried more than 10+ vids and giving this conclusion. Thank you for the content.
@LearnitTraining3 жыл бұрын
Hi Siddharth C! Thank you for the kind words and an extra big thank you for subscribing!
@nanagreco4 жыл бұрын
The Simple Macros workbook is titled 'VBA Simple Macros' in the zip file for those of you that were unable to find it.
@guillermofeliciano12464 жыл бұрын
Thank you. I was lost trying to find it.
@shoaibmultani85874 жыл бұрын
Thank you i really help me
@nanagreco4 жыл бұрын
@@guillermofeliciano1246 You're very welcome!
@nanagreco4 жыл бұрын
@@shoaibmultani8587 You're very welcome!
@fosiebear3 жыл бұрын
Thank you so much Connie :)
@carmcam14 жыл бұрын
internet is such a nice place if use properly, i want to learn vba..this lockdown sure gave us a lot of free time.
@dassprakash91322 жыл бұрын
I thought never to study macros, the voicee.... its a heaven.... i didnt skip a single min....
@LearnitTraining2 жыл бұрын
We are glad you learned so much!
@brino71684 жыл бұрын
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 :)
@navjotsingh22513 жыл бұрын
I think the main complex things with vba is memory management and regular expressions. At least these are very hard for me.
@VishantR224 жыл бұрын
Who is this angelic voice who teaches VBA? Do you have more clear courses like this?
@kishoreyc4 жыл бұрын
Agree. Crystal Clear understanding of the topic. "Quality" Content.
@ksnaigaonkar3 жыл бұрын
After years I get the feel of actually sitting in a physical classroom with my profssor right in front of me teaching me every bit of the stuff! Just wow!
@LearnitTraining3 жыл бұрын
Thank you for the kind words Kalyani! Thank you also for watching!
@mr.a_a94074 жыл бұрын
I'm definitely, totally in love with her voice ❤️
@LearnitTraining4 жыл бұрын
Thank you for the kind words!
@spachick20004 жыл бұрын
For those of you that came to learn VBA and not record macros, start at 55:19.
@MyRockMyFortress2 жыл бұрын
Good to know. The debugging part is actually super interesting. She's very clear and concise.
@masummahdy82412 жыл бұрын
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.
@phillyboylaboy4 жыл бұрын
Chelsea Dohemann has her own channel too and am subscribed. I love her teaching.