🤖 Excel Macros & VBA - Tutorial for Beginners
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: https://1drv.ms/x/s!AmxrofZZlZ-whM1lHtL2ouO72To4TQ?e=X7qHPp
- Excel shortcut keys: https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f
⌚ 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: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://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
Видео 🤖 Excel Macros & VBA - Tutorial for Beginners канала Kevin Stratvert
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: https://1drv.ms/x/s!AmxrofZZlZ-whM1lHtL2ouO72To4TQ?e=X7qHPp
- Excel shortcut keys: https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f
⌚ 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: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://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
Видео 🤖 Excel Macros & VBA - Tutorial for Beginners канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
📊 How to Build Excel Interactive Dashboards10 Best & Most Useful Websites in 2022Excel Visual Basic (VBA) for Beginners - Part 1 of 4: Buttons and MacrosMaster Excel MACROS & VBA in ONLY 1 HOUR!Do You Need to SWITCH from Excel VBA Macros to Office Scripts?How to Create & Use Excel Macros (Real world example)Excel VBA Beginner TutorialTop 50 Microsoft Excel Shortcut KeysExcel for Accounting - 10 Excel Functions You NEED to KNOW!Best FREE Software for PC in 2022Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)Top 20 Microsoft Excel Tips & TricksExcel LAMBDA TutorialLearn Macros in 7 Minutes (Microsoft Excel)How to Import Email to Excel using Power AutomateHow to Create Macros in Excel Tutorial(1/30) Excel VBA Absolute Beginner Course (30 For 30)🧙♂️ Pivot Table Excel Tips & TricksExcel Macro Class 1 - Getting Started Programming Macros