Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Excel Macros & VBA - Tutorial for Beginners. and this video is uploaded by Kevin Stratvert at 2021-09-22T00:00:09-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [IJQHMFLXk_c]
| Name | Excel Macros & VBA - Tutorial for Beginners |
| Video Uploader | Video From Kevin Stratvert |
| Upload Date | This Video Uploaded At 22-09-2021 07:00:09 |
| Video Discription | 🔥 Learn Excel in just 2 hours: https://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: 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 - Learn the fundamentals of Excel in just 2 hours: https://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: 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 [IJQHMFLXk_c] |
| Category | Science & Technology |
| Tags | kevin stratvert | excel | macro | macros | vba | visual basic | excel macros | excel macro | record macro | excel vba | visual basic for applications | record | run | test | personal macro workbook | workbook | worksheet | spreadsheet | xls | xlsm | automate | loop | for loop | do while | do until | if statement | if | else if | macro tutorial | tutorial | beginners | beginner | introduction | intro | full course | course | programming | program | code | vba programming | macros for beginners | macro beginner | how to code | learn | how to |
