Excel Macros ON DEMAND

Overview

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.)

Highlights

Macro recorder. Visual basic editor. Quick access toolbar.

Prerequisites

None.

Designed For

Accountants using Excel for Windows.

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.

Preparation

None.

Notice

None.