Excel Macros 2024-25

Available for 1 year after purchase date

**OnDemand**

2.0 Credits

Member Price $69.00

Non-Member Price $89.00

The item(s) you are attempting to remove has already been removed from your cart.

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

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