Excel: Macros in Depth

Course details

This course provides comprehensive instruction on automating tasks in Microsoft Excel through the creation and implementation of macros. The course begins with recording basic macros in stages, then advances to sharing macros between workbooks and setting up keyboard shortcuts for efficient execution. Learn the fundamentals of Visual Basic for Applications (VBA) to code sophisticated macros that extend beyond recording capabilities, opening up new possibilities for Excel automation. Throughout the course, practical tips for enhancing personal productivity are presented alongside essential troubleshooting techniques for resolving common errors and bugs. Practice challenges at the end of each section reinforce learning and help you apply new skills immediately, ensuring you can confidently implement macros in your own Excel projects to save time and reduce repetitive work.

Learning objectives
Record multi-stage macros to automate complex tasks.
Share macros between workbooks for consistent functionality.
Configure keyboard shortcuts for quick macro execution.
Write and edit VBA code to create advanced macros.
Troubleshoot and resolve common macro errors and bugs.
Apply macro techniques to real-world Excel scenarios.

Concepts

0. Introduction

01 - Automate your work with Excel macros

1. Getting Started with Excel Macros

02 - Understanding VBA code created by macros
03 - Secure your Excel macros with best practices
04 - Using code from Copilot in existing macros
05 - Using Copilot to understand VBA and macros

2. Automate Tasks with Excel Macro Loops and Logic

06 - VBA procedures and message boxes
07 - Automate Excel with ForNext loops and Copilot
08 - Using Do While or Do Until loops
09 - Calling macros to run in sequence
10 - Capture input for macros
11 - Automate sheet styling with ForNext loops
12 - Challenge - Building a macro that asks for user input
13 - Solution - Building a macro that asks for user input

3. Using VBA

14 - Automate Excel tasks with the Personal Macro Workbook
15 - Understanding when to use absolute or relative references
16 - Using logic in macros
17 - Creating a custom Ribbon tab for macros
18 - Leveraging the Quick Access Toolbar for macros
19 - Challenge - Adding a remove rows macro to every file
20 - Solution - Adding a remove rows macro to every file

4. Creating Shortcuts and Buttons for Macros

21 - Assigning macros to buttons
22 - Create a shortcut for your macro
23 - Challenge - Completing the navigation
24 - Solution - Completing the navigation

5. Troubleshooting and Debugging

25 - How to debug code
26 - How to step through and add breakpoints
27 - Using Copilot to troubleshoot code

Conclusion

28 - Where to learn more about Excel

Excel: Macros in Depth

Authors

Robin Hunt