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.
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'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!
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 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
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.
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.
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. ruclips.net/video/RKA5vE7x-3w/видео.html
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!
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 ...'.
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.
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!
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.
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.
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.👌👌👌👌
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!
In Excel I need to write number over than 15 digits, and I need to keep them as number I don't want to change them to text... Excel changes all digits after 15 to zeros. I want to keep the number as it is and to be able to sum it to other numbers they might be more than 15 digits too. Any suggestions?
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.
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.
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 RUclips 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.
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 🙂
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 RUclips channel for VBA learning from scratch. A sample video for you.
ruclips.net/video/RKA5vE7x-3w/видео.html
You're the best thing to ever happen to RUclips. Thank you so much Leila. Love from South Africa ❤️🇿🇦
Leila is the 'baddest' Excel ninja on the planet. Period!
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!
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.
Watching this video helped me learn macros in ten minutes. So from now on, I can learn macros in a single click.
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!
What a great example of how macros work, and how they are powered by VBA.
Glad you like it!
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
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!
I love how she pronounces the word "developer". Her excel tutorials are so clear, practical, and useful.
I cringe every time she says it 😂
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!
Thank you for all the video tutorials made, you explain them so well that even a "Tarzan" like me can understand them.
Well said
I used VBA and macros some years back. I am back to update my sklls and your videos are really helping alot... thans Leila :)
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
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!
I am so glad to see her on this platform. She is a great teacher. 💯
I love the way that you explained the concepts in this 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.
@@silversolver7809 hey that's a good tip! thank you!
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.
ruclips.net/video/RKA5vE7x-3w/видео.html
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!
This is the best video I've seen for macros creation, it wasn't overloaded with information and to the point
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
Leila, you are gifted in making the hardest things look easy :) , Thanks a million!
My pleasure 😊
Best excel tutor on RUclips and it’s not even close.
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.
This is by far the most informative demonstration for macro.... better then a course I attended. Thank you!
Wow, thanks!
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!
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.
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.
this channel is so underrated.
easily deserves 10 million subs
She got over 2M subs. How is underrated?
one fo the best videos for macros learning in 10 minutes
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.
I had no Idea how to do Dynamic macros until now! Thank you :)
Wow. Fantastic trainer! You make heavy loads seem very light!
You're always so precise and understandable - I feel smart when I have you as an instructor! :-)
That's how it should be 😁
Just bought your VBA course. Thanks for your amazing videos.
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 .
ruclips.net/video/5n4vaY8XjrE/видео.html
I shall check out the course. I badly need it. 🙏🏿
Hi ma'am,
Good job, spread your knowledge all in the world 🌎.
A thank you isn't enough. You have help me skyrocket my Excel skills
Thank you Ma'am
Lot of misinformation i had about macros.
Things are more clear now.
Thank s &best wishes
I can’t resist myself to learn along with listening the soothing voice of this beauty
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!
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!
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!
Love from India, Thank you for this wonderful tutorial AND all your other videos.
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
Nice basic lesson on recorder. Great starting point into the world of VBA. Thanks Leila.
My pleasure :)
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!
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!
Dear thanks, I found your video very helpful than some other videos
Very through video. I was having an issue saving and your instruction in the end resolved that for me. Thank you!
Thanks for this one, macros have always been kinda problematic for me. You make them seem easier.
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!
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.
ruclips.net/video/5n4vaY8XjrE/видео.html
Thanks to the video. A tip: Better shortcut to select all table is SHIFT+CTRL+SPACEBAR
shorter: Ctrl+ (* numpad)
@@lgvdbroek awsome, thanks.
Dear Leila, I believe in you , and I think you are able to answer my question. it is tough one! Are you ready?
In Excel I need to write number over than 15 digits, and I need to keep them as number I don't want to change them to text...
Excel changes all digits after 15 to zeros.
I want to keep the number as it is and to be able to sum it to other numbers they might be more than 15 digits too. Any suggestions?
I really love your videos, greetings for Syria 🇸🇾
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!
Amazing lesson... How you teach in an eaay way... You are brilliant
Explained nicely and clearly 😊
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.
You ma'am are certainly the best... I've also struggled with macros
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!
well explained, and a little taste of VBA without it scaring newbies. Great job.
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!
So superb teaching guide line.. God bless you always Leila
Nice work! This is a great basic overview, thank you😎😎
The Excel Goddess drops the mic 😁👍
I worry that you posted this on 1st April... but your teaching is seriously brilliant. Many thanks.
Leila always enlightening us! Thank you very much. You have helped me a lot and my team (all accountants ;-)...)
Happy to hear that, Garry!
Leila. It's quite challenging but this is something I have to learn.
Thank you for sharing. Extremely informative.
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 was new to me and brilliant 👏 thanks Laila.
For macro beginners this is very good video as lesson 1
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 RUclips 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 👍
you are such a great instructor. i have learnt a lot.
I appreciate that!
Thank you as always for explaining so well. I love your channel.
You are so welcome!
You're such a genius teacher!!! you blew my mind awaaay
Thank you! 😃
This is incredible! Thank you so much :)
NEVER FORGET .............YOU ARE THE BEST !
Fantastic. Smooth move with recording the Ctrl-Shift down and to the right.
👍
Leila, you are doing an amazing job! Thank you!
Thank you so much!
Than you so much. Best tutorial I’ve ever seen.
Wow, thanks!
Thanks Leila. That was of great help. : )
I lovvvvvve you leila , Thanks for making it this simple
You're welcome 😊
thanks for the tutorial that you're uploaded, it's really helpful
Glad to hear that!
Great tips explained so clearly, for beginners like me, to get started using macros. Love you Leila.
Glad it was helpful, Gerry!
This is what I have been looking for long time
Glad you like it.
thank you for helping me to automate my work to some extent..
its incredible lesson thank you, i hope gradually i will handle it
You can do it!
Please more tutorials like this on macros !!
Well organized each an every video