Introduction to Excel Macros Part 1 (Completed)

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

In this session Excel expert David Ringstrom, CPA introduces you to a powerful, but often under utilized feature in Excel known as macros. David will take you from a two-word macro that solves a frustrating issue that surfaces with some Excel worksheets, and then introduces Excel's Macro Recorder. You'll then see how to automate simple repetitive tasks, such as cleaning up lists of phone numbers and reformatting reports. The session will close with a brief discussion of macro security issues in Excel.

Publication Date: 2013

Who Should Attend
All practitioners who may benefit from automating simple repetitive tasks in Excel, or anyone wishing to gain a basic understanding of macros.

Topics Covered

• Learn what a macro is in Excel, along with the risks and benefits.
• Use a two-word macro to fix an annoying problem in Excel where the used range of Excel expands beyond your actual work area.
• Discover an alternative to merged cells in Excel, which you can in turn automate with a macro.
• See how to use Excel's Macro Recorder to create simple macros without any programming knowledge required.
• Learn how to add clickable icons for macros that you record on to Excel's Quick Access toolbar.
• Discover how to use Excel's Personal Macro Workbook.
• Enable a hidden button on Excel's Status Bar that makes it much easier to record macros.
• Learn how to play back macros that you've recorded so as to automate repetitive or tedious tasks.
• Avoid retyping data or clunky formulas by way of Excel's Text to Columns command
• Save time by using Excel's Text to Columns Wizard to separate text into multiple columns.
• Learn the nuances of Macro-Enabled workbooks in Excel 2007 and later.

Learning Objectives

• Become familiar with Visual Basic for Applications.

Level
Intermediate

Instructional Method
Group: Internet-based

NASBA Field of Study
Specialized Knowledge and Applications (2 hours)

Program Prerequisites
A basic understanding of Excel.

Advance Preparation
None