Who Should Attend
In order to automate functionality in Excel, it is important for students to first have a solid understanding of what Excel is and is not capable of. For this reason, this Power Hour is not recommended for beginners. However, creating macros requires very little to no experience writing formulas and manipulating data, so less experienced users can still benefit from the power and efficiency that macros allow.
Course Objectives
The goal of this Power Hour is to introduce students to the concept of creating macros and teach them how to use macros efficiently. Students will also receive a brief introduction to VBA. By the end of this course, you will be able to create macros for a variety of purposes and will be ready to start exploring VBA in more depth.
Agenda
1 - Lessons
- * Creating a Macro - Learn how to enable macros in Excel and access the tools to record a macro.
- * Recording a Macro to Automate Formatting - Learn how to reuse formatting across sheets and workbooks by recording formatting features.
- * Running a Macro - Learn how to run saved macros from the Macros window or by creating a button on a worksheet or on the Quick Access Toolbar.
- * Exploring the VBA Environment - Learn how to navigate the Visual Basic Editor and edit the code that makes macros tick.