Intro to Excel Macros Part 2

Course details

In this course Excel expert David Ringstrom, CPA, builds on the Macro Recorder concepts he introduced in part 1. David shows how to create a macro that can automatically remove unwanted rows and columns from an accounting report.

David shows how to create a macro that can automatically remove unwanted rows and columns from an accounting report. He discusses nuances involved in saving workbooks that contain macros, and explains some of the risks of macros. He then uses a couple of simple macros to explain issues related to recording to macros that frustrate Excel users just starting out with the Macro Recorder.

Topics covered:

• Decipher and manage Excel's macro security prompts.
• Discover how to use Excel's Personal Macro Workbook.
• Learn what a macro is in Excel, along with the risks and benefits.
• 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.

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.

Although each course ay be taken individually, this is part 2 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