Introduction to Excel Macros Part 2 (Completed)

This is part 2 of 2 Introduction to Excel Macros Series.

In this session Excel expert David H. Ringstrom, CPA helps you go beyond the Macro Recorder introduced in Introduction to Macros Part 1. David will use the Macro Recorder to automate repetitive tasks using Excel's Goal Seek feature. This case study will involve expanding on recorded macros to solicit input from the user, and incorporate error handling for macros. The session will then make report macro discussed in Part 1 more interactive with a File Open prompt, error handling, file size scalability, and color coding of the amounts.

David will teach from Excel 2010, but his handouts include instructions for Excel 2003, 2007, and 2013 where applicable.

Who Should Attend
Practitioners that have some experience with macros, or that have attended David's Introduction to Excel Macros Part 1 webcast.

Topics Covered

• Discover how to use the Goal Seek feature in What If analysis.
• Record a macro that automates the Goal Seek feature.
• Create customizable prompts that gather information from a user or inform them that the macro is complete.
• Understand what can cause errors in macros, and see how to incorporate error handling for such situations.
• Learn how to store data in variables for later use in your macros.
• Go beyond recorded macros by using If and Select Case statements to make decisions on the fly in your code.
• See how to step through your macro one step at a time and watch changes occur simultaneously in Excel.
• Get recommendations on additional resources to expand your knowledge of automating tasks in Excel

Learning Objectives

• Expand your existing knowledge of Visual Basic for Applications

Level
Basic

Instructional Method
Group: Internet-based

NASBA Field of Study
Computer Science (2 hours)

Program Prerequisites
A basic understanding of Excel macros.

Advance Preparation
It is advised to have attended Macros part 1.