Intro to Excel Macros Part 4

Course details

In this course Excel expert David Ringstrom, CPA, starts out by adding more error-handling capabilities to the Goal Seek macro he started in Part 3. The discussion then shifts to enhancing the accounting report clean-up macro introduced in Part 2 of the series. David shows how to build in yes/no prompts, allow the user to choose a specific file to process, and enhance code generated by Excel's Macro Recorder to create flexible macros that can deal with data sets of varying sizes. You also learn debugging techniques that are useful in resolving errors within both macros that you record or that you enhance with additional programming code.

David teaches from Excel 2010 but provides handouts with numbered steps that are specific to Excel 2003, Excel 2007, Excel 2010, Excel 2013, and 2016.

Topics covered:

• Add error handling features to Excel macros to compensate for unexpected or missing data entry inputs.
• By-pass the filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
• Learn the nuances of Macro-Enabled workbooks in Excel 2007 and later.
• Learn what to do next if a Debug prompt appears.
• See how to use Excel's Macro Recorder to create simple macros without any programming knowledge required.
• Use the Text to Columns feature to eliminate unwanted text without retyping, or to separate text into separate columns.

Although each course ay be taken individually, this is part 4 of 4.

1. Intro to Excel Macros Part 1

2. Intro to Excel Macros Part 2

3. Intro to Excel Macros Part 3

4. Intro to Excel Macros Part 4