Learn how to create and edit basic macros in Excel with this comprehensive tutorial designed for beginners. Discover what macros can do, explore real-life examples of task automation, and gain hands-on experience with recording, saving, and running macros. Dive into Excel VBA, understand relative referencing, and tackle complex macros. Explore the VBA Editor windows, learn how VBA code is built, and practice editing macro code. Master the art of assigning macros as shortcuts to streamline your Excel workflow. Follow along with downloadable instructor files to enhance your learning experience.
Overview
Syllabus
- Introduction
- What are Macros?
- Examples of Macros
- Excel VBA Explained
- Recording, Saving and Running a Macro
- Recording a Macro with Relative Referencing
- Complex Macros
- Exploring VBA Editor Windows
- Understanding how VBA Code is Built
- Editing VBA Macro Code
- Assigning a Macro as Shortcuts
Taught by
Simon Sez IT
