✅ Download the free course files to follow along
➡️[ Ссылка ]
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.
✅ [ Ссылка ]
📝 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 ⏩ [ Ссылка ]
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ [ Ссылка ]
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
[ Ссылка ]
✅ Check out our free video playlist for Excel beginners 👉[ Ссылка ]
✅ Excel 2021 Tutorials for Intermediate Users here 👉[ Ссылка ]
✅ Microsoft Excel Tips and Tricks 👉[ Ссылка ]
✅ Microsoft Office 2021 and Office 365 Training here 👉[ Ссылка ]
💬Stay in touch!
SimonSezIT.com: [ Ссылка ]
LinkedIn: [ Ссылка ]
FaceBook: [ Ссылка ]
🔔 Subscribe to our channel:
[ Ссылка ]
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Ещё видео!