One of the things that differentiates you from the rest is that you point out the "little" but very important steps in between the "major" steps. This saves so much time when first learning, because you can get the major steps right, but if you mess up a little step it won't work ( and being new to the material, likely won't know why it's not working). Kudos for another superb tutorial!
Not being VBA fluent, I nearly always use the macro recorder to start and then clean up the code afterwards. This is a great intro-to-macros video and I wish more excel users automated their work.
I'm retired now and don't need macros, but spent a few decades using them to make my life easier sorting and analyzing data so I decided I'd watch and see what I remembered. Enjoyed the lesson and think you are a great instructor.
I'm ashamed to admit I never thought I would need macros, but your intro makes it look like something I should have mastered a long time ago. Leila, you are a star - thank you!
Great video. Your teaching style is exceptional. I’ve been using macros for almost 20 years and they have enabled me to provide better support to the teams I have worked with. Macros have also played a big part in helping our current small team to be more efficient and handle a larger workload. I’m really interested to check out your course. Since I’m mostly self taught, I’m sure there is a lot I can learn. I’m also hoping that I can get some of my coworkers to take the course as well.
I have always found your video tutorials to be exceptionally good. What I don't understand is how can a video this good be viewed over a million times but only get 20k Likes. Some of us appreciate you. Cheers Leila
Thanks Leila I realized that in order to survive the ever demanding skillset required for a job as I had literally zero knowledge in macros till now...this video is definitely a starting point and looking forward to excel in it...looking forward many more macro videos
Candidly, VBA code makes my hands and brow sweat . But yet again, Classic Leila explains it in a way that I understand (somewhat) but also in a way that makes VBA a bit less scary ... and intrigues me enough to venture forth into the dark world. Dynamic Tip: Ctrl-Shift-Down and Ctrl Shift-Right ... I had no idea ... love that tip and can use immediately. Again ... thank you ... thank you ... thank you ... and to state what everyone thinks, 'You are the best ...'.
Thank you for this video! Lots of Data Analyst job postings in the UK ask for Advanced Excel (including Macros) and this video makes the process easily digestible, while remaining thorough. Much appreciated!
Dear Seth, Absolutely her tutorials are fantastic. You can also take time to visit our channel for Excel VBA tutorial. Straight forward and to the point tutorials. Please do subscribe and let us know what help you need on Macros. th-cam.com/video/RKA5vE7x-3w/w-d-xo.html
VBA Macros are my life! The ability to code absolutely anything you want into Excel is probably what makes it the greatest software ever written. You can even write code that integrates with other MS products, for example, create some code to create a dynamic Outlook email from your excel file. If you get really creative you can code Excel to work with a barcode scanner for data entry! I have a 270+ page document of all the code that I have used or written over the last ten years, coz there is just too much stuff to remember... I use it almost every day, and it is very popular amongst my work colleagues. I have two sayings about Excel: 1. =vlookup, it will change your life! 2. When I die, bury me with a copy of Excel, I want to take it into the afterlife!
Your courses are just amazing and detailed, which helps in easy understanding, in fact I have even shared your link with a couple of people within my office who work on Data. Thanks again.
All of your videos are clearly defined yet so simple and direct in the steps. You always point out the small details that make a huge difference. Thanks again.
Thanks Leila. Like many others, I find macros challenging. I don't use them enough to warrant spending a bunch if time "deep diving" into them, but tips like these are helpful. Thanks for the video.
First learned about macros at the University 14 years ago, I was terrified of macros and vba... fast forward to now I feel I've progressed 1% creating macros, I still get stuck at times and fear messing up a file trying to edit the code in via, it can be frustrating, but explain it very simple and well! You make me wanna keep trying to get better at it thanks Leila!
"fear messing up a file trying to edit the code" Copy the code to a TXT file-eg into Notepad, Save As MyCode.txt: then you can always paste that back into VBA editor if you mess up.
Hi Leila. Today i completed your Excel VBA and Macros Tutorials Playlist and it was wonderful experience. Got to know many new things. Thanks for this awesome content. Really Appreciate it.👌👌👌👌
Macro explanation was great, though VBA part went over my head. I have got to see again this and do practice. In a nut shell great video. Helpful information. Many ways I got it.
Subscribed after this video. There were many things at work back then that would have been easier if I took time to study this. Will start now. Thank you.
Thank you for this wonderful tutorial AND all your other videos. I plan on taking your course. I went on a job interview on Friday and you were highly recommended by the interviewer for me to be best prepared for the job! Looking forward to catching up on all you offer!
Ok, First time subscriber. Also, first time Excel user, after being a computer tech for over 20yrs! I have always installed but never needed to use Excel. I sold my business last year & I am now in a work force job where I need to use VB and Excel and this is all over whelming for the most part. I need to learn VB and Excel and I plan on using your TH-cam Videos to get me through this trial. Thank you for your video. I am glad I have the chance to go back because you do talk fast.................Sooooooooooo Fast! lol. That is ok though. When you know something well you will give out the information and it will go over the persons head. Data in Data Out.
Your videos are very useful for me. One consider insight your explanation is very fast. If you reduce the speed it will be easy to follow your explanation.
Grab the file I used in the video from here 👉 pages.xelplus.com/macros-intro-file
One of the things that differentiates you from the rest is that you point out the "little" but very important steps in between the "major" steps. This saves so much time when first learning, because you can get the major steps right, but if you mess up a little step it won't work ( and being new to the material, likely won't know why it's not working). Kudos for another superb tutorial!
Hi Mike just
I agree, it's the details that you mention that makes the video understandable
There are A LOT of steps Leila didn't mention to turn this in to an acceptable macro. Even chatGPT does a much better job 🙂
Leila is the 'baddest' Excel ninja on the planet. Period!
You're the best thing to ever happen to TH-cam. Thank you so much Leila. Love from South Africa ❤️🇿🇦
Not being VBA fluent, I nearly always use the macro recorder to start and then clean up the code afterwards. This is a great intro-to-macros video and I wish more excel users automated their work.
Dear Richard, You can also view our TH-cam channel for VBA learning from scratch. A sample video for you.
th-cam.com/video/RKA5vE7x-3w/w-d-xo.html
What a great example of how macros work, and how they are powered by VBA.
Glad you like it!
Watching this video helped me learn macros in ten minutes. So from now on, I can learn macros in a single click.
I'm retired now and don't need macros, but spent a few decades using them to make my life easier sorting and analyzing data so I decided I'd watch and see what I remembered.
Enjoyed the lesson and think you are a great instructor.
Thank you!
I'm ashamed to admit I never thought I would need macros, but your intro makes it look like something I should have mastered a long time ago. Leila, you are a star - thank you!
I can't tell how much I love you! You're are awesome in revealing new secrets about excel, keep doing that! We love you!
I used VBA and macros some years back. I am back to update my sklls and your videos are really helping alot... thans Leila :)
Best excel tutor on TH-cam and it’s not even close.
Great video. Your teaching style is exceptional. I’ve been using macros for almost 20 years and they have enabled me to provide better support to the teams I have worked with. Macros have also played a big part in helping our current small team to be more efficient and handle a larger workload. I’m really interested to check out your course. Since I’m mostly self taught, I’m sure there is a lot I can learn. I’m also hoping that I can get some of my coworkers to take the course as well.
I have always found your video tutorials to be exceptionally good. What I don't understand is how can a video this good be viewed over a million times but only get 20k Likes. Some of us appreciate you. Cheers Leila
Thanks Leila I realized that in order to survive the ever demanding skillset required for a job as I had literally zero knowledge in macros till now...this video is definitely a starting point and looking forward to excel in it...looking forward many more macro videos
I love how she pronounces the word "developer". Her excel tutorials are so clear, practical, and useful.
I cringe every time she says it 😂
Thank you for all the video tutorials made, you explain them so well that even a "Tarzan" like me can understand them.
Well said
Candidly, VBA code makes my hands and brow sweat . But yet again, Classic Leila explains it in a way that I understand (somewhat) but also in a way that makes VBA a bit less scary ... and intrigues me enough to venture forth into the dark world.
Dynamic Tip: Ctrl-Shift-Down and Ctrl Shift-Right ... I had no idea ... love that tip and can use immediately.
Again ... thank you ... thank you ... thank you ... and to state what everyone thinks, 'You are the best ...'.
Thank you for the kind words! I'm happy I could make VBA a bit less scary 😊
just use CTRL+A => select whole table... and DO NOT assign that to a macro LOL
I am so glad to see her on this platform. She is a great teacher. 💯
Leila, you are gifted in making the hardest things look easy :) , Thanks a million!
My pleasure 😊
Thank you for this video! Lots of Data Analyst job postings in the UK ask for Advanced Excel (including Macros) and this video makes the process easily digestible, while remaining thorough.
Much appreciated!
Glad it was helpful!
These videos you make are fantastic. I appreciate the clear understanding and thought process when presenting. Much Respect
Glad you like them!
Dear Seth,
Absolutely her tutorials are fantastic.
You can also take time to visit our channel for Excel VBA tutorial. Straight forward and to the point tutorials. Please do subscribe and let us know what help you need on Macros.
th-cam.com/video/RKA5vE7x-3w/w-d-xo.html
VBA Macros are my life!
The ability to code absolutely anything you want into Excel is probably what makes it the greatest software ever written. You can even write code that integrates with other MS products, for example, create some code to create a dynamic Outlook email from your excel file. If you get really creative you can code Excel to work with a barcode scanner for data entry!
I have a 270+ page document of all the code that I have used or written over the last ten years, coz there is just too much stuff to remember... I use it almost every day, and it is very popular amongst my work colleagues.
I have two sayings about Excel:
1. =vlookup, it will change your life!
2. When I die, bury me with a copy of Excel, I want to take it into the afterlife!
Thank you so much for this, I’ve struggled with macros and never found such a clear, concise guide, very grateful.
You're very welcome, Peter!
this channel is so underrated.
easily deserves 10 million subs
She got over 2M subs. How is underrated?
My favorite teacher. Instructions are so easy to understand and follow.
Thank you! 😃
Your courses are just amazing and detailed, which helps in easy understanding, in fact I have even shared your link with a couple of people within my office who work on Data. Thanks again.
Just bought your VBA course. Thanks for your amazing videos.
This is by far the most informative demonstration for macro.... better then a course I attended. Thank you!
Wow, thanks!
Woow!! Thanks Alot........... for such a Precise points on how to learn and use Macros, have been desiring to apply it, but finally, it's now ease!
Hi ma'am,
Good job, spread your knowledge all in the world 🌎.
I love the way that you explained the concepts in this video!
Wow. Fantastic trainer! You make heavy loads seem very light!
All of your videos are clearly defined yet so simple and direct in the steps. You always point out the small details that make a huge difference. Thanks again.
I appreciate that!
one fo the best videos for macros learning in 10 minutes
I really love your videos, greetings for Syria 🇸🇾
thanks. it was really helpful and well done for avoiding extra explanations. You are a teacher of eloquence.
Thanks Leila. Like many others, I find macros challenging. I don't use them enough to warrant spending a bunch if time "deep diving" into them, but tips like these are helpful. Thanks for the video.
Glad it was helpful, Matt! It just takes some practice.
First learned about macros at the University 14 years ago, I was terrified of macros and vba... fast forward to now I feel I've progressed 1% creating macros, I still get stuck at times and fear messing up a file trying to edit the code in via, it can be frustrating, but explain it very simple and well! You make me wanna keep trying to get better at it thanks Leila!
"fear messing up a file trying to edit the code"
Copy the code to a TXT file-eg into Notepad, Save As MyCode.txt: then you can always paste that back into VBA editor if you mess up.
@@silversolver7809 hey that's a good tip! thank you!
I had no Idea how to do Dynamic macros until now! Thank you :)
Hi Leila. Today i completed your Excel VBA and Macros Tutorials Playlist and it was wonderful experience. Got to know many new things. Thanks for this awesome content.
Really Appreciate it.👌👌👌👌
You are welcome!
Lot of misinformation i had about macros.
Things are more clear now.
Thank s &best wishes
This is the best video I've seen for macros creation, it wasn't overloaded with information and to the point
Thank you for inspiring me to want to learn Visual Basic !
Dear ,
You can also visit our channel to learn ms Excel and macros for free .
th-cam.com/video/5n4vaY8XjrE/w-d-xo.html
The Excel Goddess drops the mic 😁👍
Macro explanation was great, though VBA part went over my head. I have got to see again this and do practice. In a nut shell great video. Helpful information. Many ways I got it.
Love from India, Thank you for this wonderful tutorial AND all your other videos.
I can’t resist myself to learn along with listening the soothing voice of this beauty
A thank you isn't enough. You have help me skyrocket my Excel skills
Thank you Ma'am
Very good demonstration Leila. I use VBA code in almost all my projects. I can't do without it anymore as it really unlocks the power of Excel.
That's great to hear!
Explained nicely and clearly 😊
Thank you so much ma'am. You're such a great help to me. Hope you continue sharing and please don't stop. Shout out!
Amazing lesson... How you teach in an eaay way... You are brilliant
Dear thanks, I found your video very helpful than some other videos
I shall check out the course. I badly need it. 🙏🏿
You ma'am are certainly the best... I've also struggled with macros
You're such a genius teacher!!! you blew my mind awaaay
Thank you! 😃
Nice work! This is a great basic overview, thank you😎😎
So superb teaching guide line.. God bless you always Leila
Neat!! learnt something new again,Ctrl-Shift+Right and Ctrl+Shift+Down in recording macro add a bit of dynamic range.
Thx once again.
You're welcome!
Your excel VBA course is amazing Leila, I really learnt a lot & even designed some VBA macros for my company... a big thank you !!
how much the course bro
OMG you are by far the goddes of Excel!
NEVER FORGET .............YOU ARE THE BEST !
Thank you for sharing. Extremely informative.
This is great. I've always limited my macro usage because I was unaware of the "dynamic" option...my life will now change, thank you!
You're so welcome!
Thanks a lot Leila Jan for sharing your knowledge! It's really easy to understand and follow! I'm glad I found your channel!
Glad to have you aboard!
Subscribed after this video. There were many things at work back then that would have been easier if I took time to study this. Will start now. Thank you.
Welcome aboard!
Thank you for this wonderful tutorial AND all your other videos.
I plan on taking your course.
I went on a job interview on Friday and you were highly recommended by the interviewer for me to be best prepared for the job!
Looking forward to catching up on all you offer!
Very through video. I was having an issue saving and your instruction in the end resolved that for me. Thank you!
Nice basic lesson on recorder. Great starting point into the world of VBA. Thanks Leila.
My pleasure :)
Thanks to the video. A tip: Better shortcut to select all table is SHIFT+CTRL+SPACEBAR
shorter: Ctrl+ (* numpad)
@@lgvdbroek awsome, thanks.
You're my excel guru 🙂
This was new to me and brilliant 👏 thanks Laila.
Thank you so much, Leila. You certainly solved a mystery for me (as an amateur), and am so glad I stumbled across this superb tutorial.
Thanks
Thank you!
I worry that you posted this on 1st April... but your teaching is seriously brilliant. Many thanks.
Than you so much. Best tutorial I’ve ever seen.
Wow, thanks!
Excellent way of teaching 👏 👌 👏
Thank you! 😃
well explained, and a little taste of VBA without it scaring newbies. Great job.
Very good videos… I’ve learnt a lot from your short videos.
Dear,
You can also visit our channel to learn ms Excel and macros for free.
th-cam.com/video/5n4vaY8XjrE/w-d-xo.html
Ok, First time subscriber. Also, first time Excel user, after being a computer tech for over 20yrs! I have always installed but never needed to use Excel. I sold my business last year & I am now in a work force job where I need to use VB and Excel and this is all over whelming for the most part. I need to learn VB and Excel and I plan on using your TH-cam Videos to get me through this trial. Thank you for your video. I am glad I have the chance to go back because you do talk fast.................Sooooooooooo Fast! lol. That is ok though. When you know something well you will give out the information and it will go over the persons head. Data in Data Out.
Happy to have you aboard! No worries, you'll be up and running in Excel in no time 👍
Leila always enlightening us! Thank you very much. You have helped me a lot and my team (all accountants ;-)...)
Happy to hear that, Garry!
She so good. If only I could subscribe multiple times... There is always something useful for every video...
Wow, thank you!
Your videos are great. Thanks for sharing your knowledge. Best wishes from Panama, Central America.
Thanks for watching, Joaquin!
This is incredible! Thank you so much :)
Thanks for this one, macros have always been kinda problematic for me. You make them seem easier.
Your videos are very useful for me. One consider insight your explanation is very fast. If you reduce the speed it will be easy to follow your explanation.
Thanks Leila. That was of great help. : )
For macro beginners this is very good video as lesson 1
You're always so precise and understandable - I feel smart when I have you as an instructor! :-)
That's how it should be 😁
you are such a great instructor. i have learnt a lot.
I appreciate that!
خیلی عالی یاد میدید برقرار باشید🌷🌷🌷
Leila, you are doing an amazing job! Thank you!
Thank you so much!
I lovvvvvve you leila , Thanks for making it this simple
You're welcome 😊
Great video, Leila 😊
Superb explanation and demonstration! 💯
Much appreciated!
Leila. It's quite challenging but this is something I have to learn.
Thank you Leila. You're Amazing
Just want to commend you...You're so smooth! Keep it up.
I learned a lot! Thank you Leila! God bless!