Introduction to Excel Macros: Part 1 (Completed)

Excel expert David Ringstrom, CPA, helps you get started using one of Excel’s most powerful features in this valuable presentation. He introduces you to the concept of Excel macros as well as to the Visual Basic for Applications (VBA) macro. In addition, David shows you how to use Excel’s Macro Recorder to automate repetitive tasks, such as cleaning up reports exported from an accounting package, scrubbing data, and creating your own keyboard shortcuts for Excel features. After participating is this webcast, you’ll be prepared to begin utilizing macros immediately.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He’ll draw to your attention any differences in Excel 2013, 2010, or 2007 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.

Who Should Attend
Practitioners seeking to understand the concept of macros, as well as anyone looking for experience using Excel’s VBA macro and the Macro Recorder.

Topics Covered

• How macros are used in Excel, along with the risks and benefits associated with them
• Deciphering and managing Excel's macro security prompts
• Use Excel's Record Macro feature to create simple macros, without having any knowledge of programming
• Converting .XLS workbooks to the up-to-date .XLSX format with just two keystrokes
• Discovering how to use Excel's Personal Macro Workbook

Learning Objectives

• Identify how to prevent macros from being discarded from workbooks when saving
• Apply the Unhide command to locate and manage Excel's Personal Macro Workbook
• Define how to create general-use macros with the Relative Reference setting for Excel's Macro Recorder

Level
Basic

Instructional Method
Group: Internet-based

NASBA Field of Study
Computer Science (2 hours)

Program Prerequisites
A basic understanding of Excel.

Advance Preparation
None