Macros, VBA and Advanced Formulas in Excel Tutorials - How to Use Macros in Excel: Excel Macros for Dummies & Basic VBA

4.0 (2)

16 learners

What you'll learn

This course includes

4.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

vba macros macro excel vba excel macros excel vba tutorial for beginners excel vba tutorial vba excel macros in excel excel macros vba tutorial excel vba basics excel macro

Full Transcript

✅ Download the free course files to follow along ➡️https://www.simonsezit.com/article/macros-and-vba-recorded-webinar/ In this Macros and VBA Excel tutorial, we looked at how you create and edit a basic Macro in Excel. This is a recording from a live session available to members at Simon Sez IT. This Macros tutorial is aimed at users that are brand-new to Macros and VBA in Excel. We look at what a Macro can do and take you through a number of real-life examples where you might use a macro to automate tasks in Excel. We've even included the downloadable course file so you can follow along with this course. This will help you put what you are learning into practice and master MS Excel. ✅ https://www.simonsezit.com/article/macros-and-vba-recorded-webinar/ 📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! 0:00:00 - Introduction 0:03:16 - What are Macros? 0:04:25 - Examples of Macros 0:08:49 - Excel VBA Explained 0:14:56 - Recording, Saving and Running a Macro 0:25:50 - Recording a Macro with Relative Referencing 0:29:28 - Complex Macros 0:45:11 - Exploring VBA Editor Windows 0:50:08 - Understanding how VBA Code is Built 0:57:08 - Editing VBA Macro Code 1:01:59 - Assigning a Macro as Shortcuts 🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/ 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU ✅ Check out our free video playlist for Excel beginners 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z ✅ Excel 2021 Tutorials for Intermediate Users here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3 ✅ Microsoft Excel Tips and Tricks 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc ✅ Microsoft Office 2021 and Office 365 Training here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j 💬Stay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn: https://www.linkedin.com/company/simon-sez-it/ FaceBook: https://www.facebook.com/SimonSezIT 🔔 Subscribe to our channel: https://www.youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)