Excel: Macros in Depth (2023)

Course details

Learn how to use macros to automate tasks in Microsoft Excel, and start creating simple macros of your own. In this course, join developer and educator Robin Hunt as she shows you how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. Along the way, Robin offers tips for enhancing your personal productivity and troubleshooting and resolving common errors and bugs. Be sure to test out your new macros skills as you progress through the course in the practice challenges at the end of each section.

Concepts

0. Introduction

01 - Automating your work with Excel macros

1. Getting Started

02 - Applying basic programming with macros
03 - Understanding VBA code created by macros
04 - Security settings
05 - Recording a macro that formats
06 - Running existing macros

2. Creating Routines with Macros and VBA Code

07 - The VBA window and VBA components
08 - Using For and For Next statements
09 - Using Do While and Do Until statements
10 - Capturing input for macros
11 - Leveraging macros for the VBA code
12 - Calling macros to run in sequence
13 - Leveraging row counts for formatting
14 - Challenge - Adding an input box
15 - Solution - Adding an input box

3. Using Macros and VBA for Personal Productivity

16 - Saving to the personal macro workbook
17 - Understanding when to use absolute or relative references
18 - Using logic in macros
19 - Creating a custom Ribbon tab for macros
20 - Leveraging the Quick Access Toolbar for macros
21 - Challenge - Adding a remove rows macro to every file
22 - Solution - Adding a remove rows macro to every file

4. Running a Macro

23 - Creating a shortcut for your macro
24 - Planning and creating macros for navigation
25 - Challenge - Adding a help button for information
26 - Solution - Adding a help button for information

5. Troubleshooting and Debugging

27 - Debugging code with stepping through
28 - Setting a breakpoint and blocking comments
29 - Challenge - Troubleshooting broken macros
30 - Solution - Troubleshooting broken macros

Conclusion

31 - Applying macro and coding concepts
32 - Extending your capabilities with macros

Excel: Macros in Depth (2023)

Authors

Robin Hunt