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 ;-)