Excel Macros & VBA - Tutorial for Beginners

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step overview, learn how you can eliminate repetitive and boring tasks in Microsoft Excel using something called macros and VBA, or Visual Basic for Applications. With macros, you can automate your work in Excel, which will help you save time and effort. Macros are an extremely powerful tool that will take your usage of Excel to the next level.
In this video, we'll start with how to:
• Record a basic macro
• How to run your macro
• How to test your macro
• How to access your macro in any spreadsheet
• And even how to add if statements and loops, and we'll look at multiple types of loops
👋 Additional resources
- Sample spreadsheet to follow along: 1drv.ms/x/s!AmxrofZZlZ-whM1lH...
- Excel shortcut keys: support.microsoft.com/en-us/o...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
0:55 What is a macro & when should you create one?
3:28 Record basic macro
6:47 Run your macro
9:55 Save macro enabled workbook
10:30 Open macro workbook
11:12 Absolute vs. relative references
13:18 Edit the VBA code that powers your macro
18:32 Turn on developer tab
19:32 Personal macro workbook for anywhere access
22:11 View VBA code while recording
24:02 If statement
26:57 For loop
30:50 Input box
33:00 Do while & do until loops
35:57 Bring it all together example
47:01 Combine macros into one
48:33 Turn off screen updating
49:23 No undo for macros
49:42 Wrap up
📃 Watch related playlists
- Playlist with all my videos on Excel: • ❎ How to use Excel
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🔔 Subscribe to my KZbin channel
kzbin.info?...
🎬 Want to watch again? Navigate back to my KZbin channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert

[@KevinStratvert]

🏫 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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@thegossiploverz]

Can you make solver run in loop for all the rows in excel? Looking forward. TIA!

[@muletowndumpsters]

Finally, someone my brain can grasp. Looping has had me hostage for years. Thanks a bunch.

[@rashidhublikar9707]

##

[@zacharykrawczyk1218]

As someone with ADHD I really appreciate your speaking style, the pacing between words is just right! Everything spoken has meaning and is very clearly said. A+ tutorial!

[@rebeccadoll-suppes832]

Yes! This is the "secret sauce" to this video - sets it above the rest for that reason alone.

[@qrsimon]

Coowl

[@nguyen3276]

Him: *pauses* My brain: we can totally apply this to….. oh wait there’s more, write that down!!!

[@mala3167]

Everybody be diagnosing themselves with ADHD these days :(

[@_DinoHat_]

Omg is that a thing?, is that why when someone says three sentences without a break i cant keep track?

[@tocodelray]

I subscribed because of how clear and useful this was. No distractions, no jokes, just an hour of solid information. I hope every educational youtuber follows this formula. I struggle to pay attention and your style kept me on track the whole video.

[@saumitrad]

You, Kevin, are a fantastic teacher. Unlike most of these youtube tutorial - you do not waste much time on expounding, you do not miss any beat / important step. You are exceptionally intuitive & exhaustive - any question that I had, you were on it just a second away. Keep up the great work.

[@omarad]

Simply AMAZING! The way you structure your videos by starting with basics and then adding up topics one by one is GREAT! Thank you Kevin!

[@enerialufan]

I recently started my data analysis journey and I have been waiting for this video for forever. Thanks Kevin!

[@mvc9871]

You, Kevin, are awesome! I wish every one of my teachers could communicate information as easily as you do. You are gifted, and you have made me love Excel. Thank you!

[@chiomakamalu2890]

I'm glad I found this KZbin channel. Kevin does not miss anything and keeps it on point with relevant information.

[@alvixtan1617]

It's difficult to have one video in KZbin with no dislikes. You deserve this.

[@hollyrace3998]

I have watched, and rewatched, so many of your videos. I love your playful tone and fun sample sheets to help viewers to learn by watching and doing, whatever works best for them. Your video on SQL literally helped me get a promotion. I am constantly sending links to others who want to learn more.

[@ricardoluizmarcello]

Kevin, I appreciate a lot the way you bring us all this information! I have no words to thank you. I wish you all the success you deserve

[@SavageGothamChess]

The Legend is back with more Excel videos!!!! 0:00 Can feel the excitement when you said today. Usually when making long videos at around the last couple of minutes you wouldn't understand anything because the person who records starts to get frustrated and tired. But on Kevin's Videos it is the opposite. Well explained video. And yes I am still not a wizard in Excel but I am nearly there thanks to you. You are not on the way to a million, you are sooo close to 1 million subscribers. Always here to support you!!!

[@KevinStratvert]

😁

[@Gaboch8719]

What a professional video made by a genuine professional! Congratulations and thanks a lot Kevin!

[@NZDLo]

This was fantastic - I've used Excel since inception, but have never really gotten into macros. Love your teaching style - will go look for more of your videos now!

[@morgannweke7771]

This was super helpful, Kevin! Thank you for taking the time to share quality content.

[@jamesstreeter43]

I have been using Excel for over 20 years and I have learned so much from this video. Your teaching style really works for me, thank you.

[@cpt.benfox]

Great job Kevin! As always each video is informative and extensively educational.

[@hanzelpalacio3756]

I am so thankful that I stumbled upon your video, Sir Kevin. You make complicated applications easier to understand. There is obviously the most important ingredient in the way you present, patience. Truly, your way of teaching is so God-like. Thank you to the highest level.

[@jamesarchieodena4107]

This is one of the three Excel vloggers that I always watch together with lyka and kenji because of its pacing and very informative and real life based scenarios. ❤❤❤

[@HarjeevanSingh-Tech]

Amazing video Kevin and it's really great to see you again! 😁😁 Macros are really awesome because it can make a repetitive task extremely easy 😎

[@TylerStanczak]

Such a helpful tutorial. None of us enjoy doing those repetitive tasks. Thanks Kevin :)

[@TruthofDilly]

Really like the way you teach, your vids have taught me so much…you are someone that is truly intelligent as you can make complex things simple, not msn7 excel teachers do this, your on of the very few do thank you, I’m so grateful to you.

[@proudlycanadian3023]

I am so amazed and astounded of how impeccably flawless/immaculate of my knowledge if Visual Basic is! It is of absolute perfection! Thank you for the perfect lesson!

[@makarand1985]

Kevin you are the BEST teacher I come across till date GOD BLESS YOU !!!

[@579maheshreddy4]

This is the best course that I have ever seen on KZbin for excel vba, Thank you so much my man for helping me to understand the macros 😊😊

[@alihameed5389]

An excellent educator, thanks for all the work you are doing man!

[@adelle1441]

So far one of the BEST tutorial video and Trainer in KZbin. Very informative and well explained with the right pace and level of enthusiasm.

[@FTSociety]

Thank you! I've been reluctant to learn VBA because it looked complex, but your explanation was very clear and easy to follow, now I want to learn more, thank you!

[@mariamarrero6611]

One of the best and well explained videos teaching VBA! thumbs up!

[@TheSuperEmpoleon]

This is probably the best tutorial video I’ve ever watched. Thanks!

[@rotethongvanit]

Thanks Kevin for the step by step tutorial.

[@elsietang7039]

Thanks Kevin. You are really a great teacher. I really like watching your video. Very informative and no non-sense at all. Very clear. 👍

[@SheikhMuhammadNawaz]

The way you explain is awesome..... I really like your way of teaching and making us understand.... Thank you!

[@johndn9238]

This is really brilliant for macro novice like me and going to save me tons of time! Thank you very much indeed.

[@aveerajsharma]

Wow!!👌 Great to hear this voice again By the way thanks for sending that post in which you informed us that you are currently spending some time with your family, else I was worried a bit

[@hankgrimes1806]

Hello, Kevin. I've watched many videos promising to "teach" macros and VBA, and I have to say that yours are some of the very best! Do you have any courses planned where you offer a deeper dive into VBA? I'd be happy to sign up for a full course if you were to offer any!! Thank you, and I hope to see more

[@maximilianosalibe1710]

I really loved this video, Kevin! It's specially helpful to understand and take profit of the advantages of using Excel!

[@glengreen8]

❤ really valuable lesson. Macros are awesome and you are great teacher. Much respect.

[@lawmontgreen8860]

What an amazing tutorial. I’m learning so much. Thank you.

[@arlenedahlcm7169]

This is very informative and certainly well organized. It offers some excellent tips, too. Keep it up!

[@bencecserkuti7110]

The number of times I am watching you, I am considering you for the Employee of Year award even though you are not working here.

[@OrientalMelodies2010]

Your way of explaining the subject is outstanding, many thanks for the awesome tutorial :)

[@vramarathnam]

Thank You Very muck Kevin. Excellent teaching gradually increasing the syllabus ! i am an xl user at a surface level . Thanks to your video i did macros yesterday and happy to see it working. Thank You once again

[@colinracheljustpootling7468]

Wow! Just brilliant and so well explained. Thank you

[@johnsamte830]

Great video Kevin. Thank you!

[@sairaj6875]

Thank you so much, Kevin. This is so helpful.

[@kwakupoku3719]

God richly bless you. You make these scary excel tools really easy. Here I am on my computer easily doing pivot table, xlookup and macros with ease. This is the course I took in college but rate my excel experience as intermediate. Thank you and thank you again.

[@sameertawfiq3420]

Thank you so much!! I learn a lot through your videos even things I thought I already know.

[@mick3yes]

Great video Kevin, you are such a good teacher! Thanks again!

[@akashsharma4746]

Time well spent 🔥, learned a lot about Marcos !

[@HusamJamal]

One of the best videos that explain such topic. Thank you!

[@diwakarmishra2241]

Thanks man. This is a good video to start with basics.

[@YeungKaHung]

Extremely useful Excel tutorial. Great thanks!

[@9102010]

Hi Kevin, Thank you very much for the good explanation. It was very easy to follow, very knowledgeable, and above all a good voice and the right speed for me. PERFECT!

[@fsaforosaforo6338]

Yet another great video on all things Excel. You are my go to guy for Excel thank you so much for producing these great videos. Flo

[@rohitjain6379]

Thank you dearest Kevin. This video was helpful and I absolutely loved it

[@SayedSquadOfficial]

I wish youtube had multiple or unlimited likes option. I really want to give this guy a million likes. Great way of Explaninig sir. Please do not stop uploading these videos. Really helpfull. Thanks a lot...

[@lovelifebrown]

Thank you so much!!!! I have subscribed and am excited about following you!@!

[@user-rt2kp1uk1u]

Thank you, Kevin. Very helpful. I learned a lot from this video.

[@georgywordrighter5662]

Cannot begin to express how impressed I am . I was given someone's spreadsheets to update and one of course was misaligned as stacked data. I was forced to cut and paste incoming additions in the stacked data (sadly not cookies)and spent hours until now. Bam.... I can do this in no time - meaning more coffee breaks for me, smiles from the boss and I wish I could send Kevin one of his choice (coffee not boss needless to say)

[@sreerajpr4124]

Kevin, you r one of the best teachers❤.... Thanks for the superb video

[@yosef-yosef9414]

thank SO MUCH for this Tutorial Video in VBA

[@ramachandranv1796]

Many thanks. Awesome content and very well structured.

[@hassanalianees5530]

Big fan of your videos. Thanks Kevin

[@javidparsa2199]

Hi Kevin, Thank you for your teaching method You speak very fluently and understandably, although I do not have a good level of English, but I easily understood you all the time teaching. I will definitely follow you and see more videos from you. Good Luck friend:)

[@tahamadani2462]

You are a great teacher. Thank you for the video

[@paladinhobbies5206]

This is super amazing!!!! A million thanks to you ser!!!

[@nilamnighot8540]

Very Nice video that I have ever seen. I had so much confusion in the macro now it is cleared. I like the way you are explaining complex topics so easily. appreciate all your efforts.

[@jerrymartinez1048]

This was very helpful. Thank you!

[@user-zp5vk2mp4c]

I can't believe how interesting you've made this. You are a god.

[@rotethongvanit]

Very clear explanation. Make it much easier, thanks.

[@chajam]

thank you so much for this! I needed some light on how to edit macros (I only knew how to create it), now it feels less intimidating.

[@jacquelinetung]

Very easy to learn & refresh, thank you, Kevin :)

[@arphdsss9817]

This was helpful I learn something everyday from you Kevin thanks 😊

[@lovethatbeach]

I feel smarter after trying my own macros with this tutorial! 😂 Thanks Kevin!!!

[@lookingforwardto]

Very informative. Thank you GURU!

[@ExcelTemplatesSolutions]

Learnt alot from you, thank you kevin

[@user-rc2ip1zb5d]

Thank you so much for this tutorial!

[@agptadmin9886]

Great video Kevin! I learned a lot. Thanks!

[@zt2820]

Great tutorial. Thank you!

[@marianethsanchez2621]

really helpful and simple, thank you!

[@oanphong61]

Thank you Kevin! Your video is amazing and well-explained. It helps me a lot

[@KevinStratvert]

Glad it was helpful!

[@missn.a.ndlovu3322]

Thanks this video helped me to understand the basics of VBA!

[@ChristopherNealBUSHIDO49ERS]

This was super-helpful! THANK YOU!!!

[@chrism9037]

Super helpful, thanks Kevin!

[@alirezasadeghifar3815]

Subscribed, your videos are fantastic!

[@olufemiomonikeolusegun8337]

You're such a great teacher. I love your method of teaching. Please are you teaching us python again. Your first tutorial for beginners has been my best ever. Thanks

[@KevinStratvert]

More to come!

[@olufemiomonikeolusegun8337]

@@KevinStratvert oceans of thanks

[@Juan-Hdez]

Very useful. Thank you!

[@JK-jm6kd]

I love your videos easy to follow

[@geo3000sa]

Thanks Kevin, very informative and learned alot 👍

[@georgem.6076]

Thank you, Kevin. I feel a little less worried about starting my new job next week.

[@wilkinsbrito5168]

Thank you for this video! I just started to properly utilize PC Apps/Software.

[@devarshnayyar3910]

A great video . I was Thinking of this and what a coincidence.

[@titomoura7014]

Congrats for the video you are a teaching wizard!

[@ryanfrancis9134]

I really enjoyed this video. Great job!

[@Missyvjd]

Thanks so much for this....I needed help to understand relative references

[@BobG-eh5fc]

Another excellent tutorial!

[@cenevspeed]

Microsoft provides so many new features in their products and thankfully we have such a wonderful teacher to explain them 😎 Thank You Kevin 🔥

[@jean-francoisregnard4889]

Thanks , Kevin ! This video is just excellent !

[@bhavanimaddela7252]

Great video Kevin. Keep up the good work