Excel Macros & VBA - Tutorial for Beginners
1,068,919
Published 2021-09-22
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-whM1lHtL2ouO72To4TQ?e=X7qHP…
- Excel shortcut keys: support.microsoft.com/en-us/office/keyboard-shortc…
- 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: www.linkedin.com/in/kevinstratvert/
- Twitter: twitter.com/kevstrat
- Facebook: www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: www.tiktok.com/@kevinstratvert
- Instagram: www.instagram.com/kevinstratvert/
🔔 Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube 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
All Comments (21)
-
🏫 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: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzc…
-
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!
-
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.
-
I recently started my data analysis journey and I have been waiting for this video for forever. Thanks Kevin!
-
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!
-
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!
-
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.
-
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!
-
I'm glad I found this YouTube channel. Kevin does not miss anything and keeps it on point with relevant information.
-
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.
-
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.
-
Microsoft provides so many new features in their products and thankfully we have such a wonderful teacher to explain them 😎 Thank You Kevin 🔥
-
It's difficult to have one video in Youtube with no dislikes. You deserve this.
-
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
-
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.
-
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!
-
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!!!
-
Such a helpful tutorial. None of us enjoy doing those repetitive tasks. Thanks Kevin :)
-
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!
-
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.
