Maximize Excel: Intro to Macros Part 2
Presented by David H. Ringstrom, CPA
 
Event Date/Time: 12/19/25 3:00 PM Eastern
Duration: 100 minutes
 
In Part 2 of Intro to Macros, Excel expert David Ringstrom, CPA, takes you beyond the basics of Excel’s Record Macro feature and explains how to enhance the code you’ve created by adding error-handling features, interactive features, and decision-making capabilities. You’ll learn how to filter based on cell contents, simplify what-if analysis, play back recorded macros, and much more.
 
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
 
Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.
 
Who should attend:
Practitioners who would like to expand their knowledge of using Excel macros. 
 
Topics covered:
 
• Choosing the proper file workbook format to preserve macros within Excel workbooks.
 
• Discovering the array of form controls available within Excel.
 
• Enabling the hidden Developer menu in Excel to access additional functionality.
 
• Executing Excel macros one line of code at a time when needed to understand how the macro works or debug problems in the code.
 
• Exploring Excel’s Goal Seek feature, which can be used to solve for a single missing input.
 
• Providing feedback to a user by way of the MsgBox method within a macro.
 
• Triggering and then resolving compile errors within Excel macros.
 
• Understanding syntax errors within Excel macros.
 
• Viewing the programming code for recorded macros.
 
Learning objectives:
• Recall what to do if a Debug prompt appears.
• Apply Excel’s Goal Seek feature.
• Define the benefits of adding error-handling features to macros.
 
 
Level:
Intermediate
 
NASBA Field of Study:
Computer Software & Applications (2 hours)
 
Program Prerequisites:
Previous Experience with Excel Macros
 
Advance Preparation:
None