Excel Macros

Description

What do you do when a setting, shortcut or command isn't available in Excel? Well, you create a macro, of course. Macros allow Excel users to extend the capabilities of Excel and create shortcuts and commands. In this session, you will use the recorder to create a macro that applies a built-in format setting. You will then write a macro in the visual basic editor to provide a shortcut to a popular Excel function. The course will also cover how to add macros to the Quick Access Toolbar so you can easily execute them in the future. Presented in Excel for Windows. Note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web. The webcast was originally broadcast on May 3, 2016. Note: There is a minimum passing rate of 70% for this course.

Highlights

• Macro recorder • Visual basic editor • Quick access toolbar

Objectives

• Identify the steps to record a macro. • Recall how to display the Developer ribbon tab. • Determine the process for adding a macro to the Quick Access Toolbar.

Designed For

Accountants using Excel for Windows.