🤖 Learn even more about macros, including setting up if statements, loops, and much more in under one hour with this free tutorial video: ua-cam.com/video/IJQHMFLXk_c/v-deo.html 🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Hi Kevin, actually when I opened this link it opened for PowerPoint. Can you please check. And thanks for this wonderful short video for introduction to Macros. Definitely, would like to learn more
@@KevinStratvert I tried opening but it displays playlist of powerpoint tips and tricks. And I am talking about the one which you've mentioned in comments for pivot tables and other stuffs. Anyways I have subscribed your channel so any playlist I can watch at anytime.:)
Thank you for filling this gap in my knowledge. I graduated with a bachelor's degree and a lot of us senior year came back from our internships and asked our professors to start including this in our curriculum because our competition had this knowledge and we felt behind.
First I thought macros is something so difficult to learn, your video helped me to understand this under 10 mins... Thanks a lot ... Keep up the good work. :)
Coded macros are often just copy pasted and adjusted to your needs. Only very complex macros are hard and difficult to make. But even chatGPT or other AI are great at writing them for you.
With respect, this is magical because it has been pre-prepared. It may be useful to explain potential pitfalls that don't require a PhD in Computer Science to understand the VBA coding. I consider myself a pretty advanced Excel user and simply cannot get the relative reference to work in a simple sorting procedure with multiple sets of similar columns. The results are utterly incomprehensible.
I just told an interviewer that I don't know what macro is, although I told her I can learn it within a Day. I just stepped out, and googled it. Boom 💥, I saw your video and I learnt it within 10 mins. I don't know what are your heart desires. May GOD BE With YOU
Thanks for a great video. If MS isn’t sponsoring these, they should. I learned more in watching a few of your videos than I learned in over 20 years of using the products. These videos make the products so much more valuable to me. These short videos are a big improvement over the complicated tutorials of the past. Nice easy and methodical instruction that shows all the little nuances that you never got from the manuals and previous workshops. You’re an awesome teacher. Keep it up.
I’m taking an engineer class for my computer science degree and it involves excel. It’s been incredibly easy so far so I looked up what might be hard on excel, it said “macros” but this is super simple too. Compared to complex coding in my CS classes this is super chill lol.
The explanation was great, following along with the visuals was easy, and the whole thing was short and compact. Great job man. You have a gift for teaching and I hope that it continues to be utilized and rewarded.
Thak you Kevin, till now i'm using individual tools for different tasks, but after found your channel now i can do same tasks with MS Office, VLC, etc. You really make my job easy.Thanks again.
Great tutorial, I start my first role since being made redundant due to Covid on Jan 4th and a big part of the job will include working on Excel so this is great! Thanks
Kevin, thanks again for a great tutorial. Learning macros for me has been a long time coming along with pivot tables. Your examples will help increase my confidence to know I can do this. 🙂
Thank you so much, really awesome, this is what I am exactly looking for.. I like the last note to tell the manager how hard the task is and get free time to relax 😂
Dude.... I was learning python to automate some repetitive "Soul Sucking" PDF form filling function at work, but after watching your videos I can do it all with MS office and Excel Macros!! Hot Diggity Dog!! Love your suggestions on how to use this new knowledge to your advantage. Personally, I'm just gonna, kick it back with some extra time with my kids. This is what UA-cam was meant for! Well at least for those who want to get ahead. Want you to know you have greatly and positively impacted another family's life with your video. Thank you!
AWESOME - AWESOME - AWESOME! Wanted an easy button. You showed me now to insert a button and assign a macro to that button. THANK YOU - THANK YOU - THANK YOU!
This was so helpful, Kevin. Many thanks. Been cracking my brains on how to edit and update my macro enabled spreadsheets , and this came along. Bless you.
Hi Kevin, I really enjoy your excel videos. Can you please teach us macros in depth. How to pull them up again and again everyday in different sheets, VBA etc
Thank you for this. You always explain things so clearly. I'm familiar with Macros but it's useful to have this overview . I'm on a Mac and have Microsoft 365 for Macs but Power Query isn't available for Macs so I'm going to focus on macros as the next best alternative and your tutorials are going to be a great help.
Thank you Kevin!! My Excel skills can just about stretch to pivot tables at the moment (LOL), however, in my new role I spend hours every morning / week pulling data from our systems into Excel and manipulating it into the format I need to present it. I really want to streamline the process and wondered if there is a way I can get the data to pull automatically, within certain parameters, from the systems we use and populate in the format I need. Happy to watch your videos if you have done one already on this :)
Thanks for the video, your channel has become my bible! QQ - I send a report to a client each week which comprises taking data from serval different workbooks into one central report, can a Macro automate this also or does it have to be in the same workbook?
Thank you very much Mr. Stratvert your way of explaining the materials is organized, clear, simple, and understandable. I am very glad to discover your great channel
Thank you so much for the tutorial. Very brave of you to use your own info as an example. I'm older and new to this. I feel better with the security knowing you have that much faith to use your own personal info. Thank you very much for the informative video!!!
Thank you Kevin, but, am advising not to select data by cursor because data range in different aspect. So, best way to select your data is by using keyboard shortcuts, Shift+Ctr+direction. This will work better in multi data issues than using cursor in selecting data... All in all, you did good job!!!
I appreciate your easy to understand explanations, the videos are digestable in small sections. Can you please create a household budget template tutorial, and how to keep it updated monthly, thank you!
You are so smart and handsome!! I hope my son can make macros for his repetitive tasks, I am trying to help him find resources and I am sending your video to him ASAP
Mr. Stratvert: I think U could use/click the View Tab To Create A Macro. On the View Ribbon on the Far Right is the Macro Button. Great Video, The Developer Tab has other useful Functions that the View Tab doesn't have.💖
Great tutorial , very much in details . Maybe a bit small size to be able to read the ribbon functions and functions , so maybe enhance that for future tutorials to help identify the functions ??? . Many thanks
Thanks a lot for this quick tutorial. It helped me in my work. Really appreciate it.👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
My dude said like the video and click the subscribe button at the end and as a person who reached the end with learned value I obeyed his instructions 😀
Thank you so much Kevin sir I also like your learning and I am Indian but I also like your learning and I subscribed your UA-cam channel thank you sir 🙏
Hi Kevin, I have a spreadsheet that I add columns to in order to track inventory and identify with comments where the inventory went. I would love to be able to run a macro every time I need to add more columns to the right. I have not been able to find a spreadsheet model that looks like what I am building manually. In these comments I can search for the serial numbers of the equipment. I am sure you would know a short cut, because as it it, I have to add columns then go to the total and manually add the columns in the format, then copy and paste down that column. I am sure there is an easier way and I know this is 2019 post but hope you see this message. Thank you for looking, and thanks for being on here with all your tips and tricks. Bravo to you!!!
🤖 Learn even more about macros, including setting up if statements, loops, and much more in under one hour with this free tutorial video: ua-cam.com/video/IJQHMFLXk_c/v-deo.html
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Hi! Can you do a tutorial of how to write more complex macros with variable numbers of samples?
@@russianmusician Yes! I need this too
Hi Kevin, actually when I opened this link it opened for PowerPoint. Can you please check. And thanks for this wonderful short video for introduction to Macros.
Definitely, would like to learn more
@@vyomapatel7131 Hmm, I just checked and it opens in Excel. Maybe try again? Thanks for the note!
@@KevinStratvert I tried opening but it displays playlist of powerpoint tips and tricks. And I am talking about the one which you've mentioned in comments for pivot tables and other stuffs. Anyways I have subscribed your channel so any playlist I can watch at anytime.:)
Thank you for filling this gap in my knowledge. I graduated with a bachelor's degree and a lot of us senior year came back from our internships and asked our professors to start including this in our curriculum because our competition had this knowledge and we felt behind.
First I thought macros is something so difficult to learn, your video helped me to understand this under 10 mins... Thanks a lot ... Keep up the good work. :)
There is coded macro, this is just recorded and it’s limited on what you can do.
Coded macros are often just copy pasted and adjusted to your needs.
Only very complex macros are hard and difficult to make. But even chatGPT or other AI are great at writing them for you.
With respect, this is magical because it has been pre-prepared. It may be useful to explain potential pitfalls that don't require a PhD in Computer Science to understand the VBA coding. I consider myself a pretty advanced Excel user and simply cannot get the relative reference to work in a simple sorting procedure with multiple sets of similar columns. The results are utterly incomprehensible.
I just told an interviewer that I don't know what macro is, although I told her I can learn it within a Day.
I just stepped out, and googled it.
Boom 💥, I saw your video and I learnt it within 10 mins.
I don't know what are your heart desires.
May GOD BE With YOU
Thanks for a great video. If MS isn’t sponsoring these, they should. I learned more in watching a few of your videos than I learned in over 20 years of using the products. These videos make the products so much more valuable to me. These short videos are a big improvement over the complicated tutorials of the past. Nice easy and methodical instruction that shows all the little nuances that you never got from the manuals and previous workshops. You’re an awesome teacher. Keep it up.
I actually thought macros was difficult to learn, after watching this video I learned how to use macros 💯...a big thanks to you 🙏
Good stuff. All I need to know if one can update one workbook with another and I'm good. This will really help me manage my burnout
This guy is unbelievable, makes ANYTHING looks easy. Thank you Kevin.
I’m taking an engineer class for my computer science degree and it involves excel. It’s been incredibly easy so far so I looked up what might be hard on excel, it said “macros” but this is super simple too. Compared to complex coding in my CS classes this is super chill lol.
Really loved your lesson. Can you go through a range of different types of macros from simple to intermediate to advanced.
The explanation was great, following along with the visuals was easy, and the whole thing was short and compact. Great job man. You have a gift for teaching and I hope that it continues to be utilized and rewarded.
Thak you Kevin, till now i'm using individual tools for different tasks, but after found your channel now i can do same tasks with MS Office, VLC, etc. You really make my job easy.Thanks again.
Great tutorial, I start my first role since being made redundant due to Covid on Jan 4th and a big part of the job will include working on Excel so this is great! Thanks
Excellent!! Explained in a such a simple way, I learned in one view..Thanks. it will ease and save my time.
Kevin, thanks again for a great tutorial. Learning macros for me has been a long time coming along with pivot tables. Your examples will help increase my confidence to know I can do this. 🙂
Your lesson was fantastic!! My favorite Excel teacher for sure!!
Thank you Kevin. I need Excel for my current job position and I have never used it that much. Your tutorials are helpful. :) Much appreciated.
5 mins into it, i was able to figure out what i needed. Great video and very , i mean VERY CLEAR instructions and content! Thank you!
Geez Louise. I was so scared that macros would be difficult. Now I feel silly for not using them sooner. Thank you!
Thank you so much, really awesome, this is what I am exactly looking for.. I like the last note to tell the manager how hard the task is and get free time to relax 😂
Dude.... I was learning python to automate some repetitive "Soul Sucking" PDF form filling function at work, but after watching your videos I can do it all with MS office and Excel Macros!!
Hot Diggity Dog!! Love your suggestions on how to use this new knowledge to your advantage. Personally, I'm just gonna, kick it back with some extra time with my kids. This is what UA-cam was meant for! Well at least for those who want to get ahead. Want you to know you have greatly and positively impacted another family's life with your video. Thank you!
Thank you. I was interviewing for some positions and this came up. Glad to see it was pretty straight forward.
AWESOME - AWESOME - AWESOME! Wanted an easy button. You showed me now to insert a button and assign a macro to that button. THANK YOU - THANK YOU - THANK YOU!
Man you are absolutely a best teacher and this was what i wanted from begining and now i found it and it was very freakin simple
I can't believe I held off learning Macros for so long. You're the best!
I think this is one of the videos that explains Macros in the simplest way! Thanks @kevin
This was so helpful, Kevin. Many thanks. Been cracking my brains on how to edit and update my macro enabled spreadsheets , and this came along. Bless you.
Thanks Kevin. Great job. Needed to revise and update my Macro skills and your inro video was perfect. 😊
Hi Kevin, I hope you can add more videos regarding Macros, please? I love your tutorial strategies because it so easy to follow.
Hi Kevin,
I really enjoy your excel videos. Can you please teach us macros in depth. How to pull them up again and again everyday in different sheets, VBA etc
Thank you for this. You always explain things so clearly. I'm familiar with Macros but it's useful to have this overview . I'm on a Mac and have Microsoft 365 for Macs but Power Query isn't available for Macs so I'm going to focus on macros as the next best alternative and your tutorials are going to be a great help.
Thank you Kevin!! My Excel skills can just about stretch to pivot tables at the moment (LOL), however, in my new role I spend hours every morning / week pulling data from our systems into Excel and manipulating it into the format I need to present it. I really want to streamline the process and wondered if there is a way I can get the data to pull automatically, within certain parameters, from the systems we use and populate in the format I need. Happy to watch your videos if you have done one already on this :)
your way is perfect man and after watching the video I learned how to edit the macro that I already have thanks man
Wow, so easy! Your videos are leading me to land my first Analyst role! Thank you, Kevin!
Always very helpful, plain and simple that any beginners can follow! Kudos!
Thanks for the video, your channel has become my bible! QQ - I send a report to a client each week which comprises taking data from serval different workbooks into one central report, can a Macro automate this also or does it have to be in the same workbook?
Try using power query and adding it to the data model
I created macro based on your video... thanks. Forgot about the use Relative reference!!! Very valuable.
Super! This is great succinct revision for me, I sort of forgot my two years ago macros knowledge as long time didn't use it. Now I'm back in action!
Thank you..the way you explain its very easy than I imagined
Easy to understand. I thought so difficult but u made it very easy. Thank you
Thanks Kevin. This is my first time. Will look up for more tutorials on Macro
Thank you very much Mr. Stratvert
your way of explaining the materials is organized, clear, simple, and understandable. I am very glad to discover your great channel
Dude you are a god for dropping this information. Thanks man, you have further educated me.
Hello Kevin... Thank you for your video tutorial... It was easy to understand the basics of macros
Thank you so much for the tutorial. Very brave of you to use your own info as an example. I'm older and new to this. I feel better with the security knowing you have that much faith to use your own personal info. Thank you very much for the informative video!!!
Made it so easy thank you! All my coworkers are Macro Experts and now I feel a little better 😂
Thanks Kevin! great video I will slow it down for about a million passes and still it is really helpful
Thanks for this. This will help me with my monthly active directory audits where i have to manipulate large amounts of data.
I just tried the tricks which was showed, and it's really worked well. Thanks for ur tutorial
Very helpful. Need a refresher in my job I am starting to look and create a macro.
Thankyou for explaining in such a easy way.. your video was really helpful for me.. god bless you..and thankyou again
I may be a little late to the game but...OMG! Thank you for the tutorial. This is going to make things so much better.
Very straightforward and helpful, thanks for the tutorial
Simple and clear explanation 👍
Kevin thank you very much for the effort and your teaching method. Really helpful.
Greetings from Athens, GR
Thank you Kevin, but, am advising not to select data by cursor because data range in different aspect. So, best way to select your data is by using keyboard shortcuts, Shift+Ctr+direction. This will work better in multi data issues than using cursor in selecting data... All in all, you did good job!!!
Best teacher, I really appreciate the way he makes things clear
thank you so much for the video as well for the attachment. I tried with the data you have given and have successfully done it.
That was super helpful ty kevin
thanks bro..i received good performance review from my manager just because creating simple macro based on your tutorial..
I appreciate your easy to understand explanations, the videos are digestable in small sections. Can you please create a household budget template tutorial, and how to keep it updated monthly, thank you!
THANK YOU! This just helped me immensely with one of my first work projects!
This is by the far the easiest tutorial to follow thank you so much !!!!
You’re awesome thank you for that information. You really help me gain more information when using an Excel.
Awesome! Love the way you instruct us in cyberspace. Thank you!
You are so smart and handsome!! I hope my son can make macros for his repetitive tasks, I am trying to help him find resources and I am sending your video to him ASAP
Very useful. Thank you!
Mr. Stratvert: I think U could use/click the View Tab To Create A Macro. On the View Ribbon on the Far Right is the Macro Button. Great Video, The Developer Tab has other useful Functions that the View Tab doesn't have.💖
your tutorials always save me , these are so fun and easy . thankyouu so much
Brilliant video and you make it so easy to understand to the none technical 🤣 btw you have amazing skin!!
Hey Kevin, That was very helpful. I am preparing a pricing tool for my company.
YOU"RE THE BEST!!!
just wanted to know how to activate Macros, life saver!
Very simple and precise. Loved the last tip that to tell manager how hard the work is lolx. Thanks for sharing your knowledge.
Hi Kevin, Thank you this really helped me a great deal and to prepare for a job interview! Keep up the great work and keep it coming Sir!
Thanks a lot Kevin. Nicely and very simple way you showed brother!!! Thanks again.
Dude you are alright, it's like going to school. Great teacher.
I really enjoy your tutorials. You make difficult sound easy
Great tutorial , very much in details . Maybe a bit small size to be able to read the ribbon functions and functions , so maybe enhance that for future tutorials to help identify the functions ??? . Many thanks
Very nice ..very good simple tutorial for beginners ..keep up 👍👍
Thanks for the video. You not only made it easy to learn but, fun as well.
Thanks for the note Vanessa! :)
@@KevinStratvert I created Macro but it shows Compile error :(
Excellent.....Wow.. A very simplified and good explanation...It is really helping my now in practicing some stuff
Thanks Kevin... Awesome video... All scenarios explained in a simplified way
You are a great teacher. I have always wanted to learn this.
That’s really helpful. I save a lot of time now when doing my reports.
Dude looks like the charisma on command guy.
Thank you for this it was really helpful.
Thanks a lot for this quick tutorial. It helped me in my work. Really appreciate it.👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
My dude said like the video and click the subscribe button at the end and as a person who reached the end with learned value I obeyed his instructions 😀
This is awesome! OMG you just saved me so much time!! Thank you!!
Hi Kevin
This session is awesome and very detailed. similarly am looking for MS Word..
THANKS YOU!This is the first time me trying macros well explained!
Thanks a lot for this video. I was really able to understand how a macro works.
Thank you so much Kevin sir I also like your learning and I am Indian but I also like your learning and I subscribed your UA-cam channel thank you sir 🙏
This is going to make my life so much easier! thanks a bunch!
Thanks so much for your teachings. I am so grateful
This video is good. But its a lot better when you have Numa, Numa playing in the background. Consider doing this for your future videos.
Thank you for the video! That's so clearly and kindly explained :)! Looking forward to explore more of your content.
Hi Kevin, I have a spreadsheet that I add columns to in order to track inventory and identify with comments where the inventory went. I would love to be able to run a macro every time I need to add more columns to the right. I have not been able to find a spreadsheet model that looks like what I am building manually. In these comments I can search for the serial numbers of the equipment. I am sure you would know a short cut, because as it it, I have to add columns then go to the total and manually add the columns in the format, then copy and paste down that column. I am sure there is an easier way and I know this is 2019 post but hope you see this message. Thank you for looking, and thanks for being on here with all your tips and tricks. Bravo to you!!!
Thank you!!! Could you cover Pivot Tables and their uses?
Thanks loved it just needed it I am in 10th grade and needed for my practicals 💛💛
Thank you for this awesome tutorial! Clear and easy to understand.