Skip to main content

Excel Macros

Available Until

CalCPA Webcasts

Online, OK 00000

Get Directions

2.00 Credits

Member Price $69

Non-Member Price $89

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

  • Non-Member Price $89

    Member Price $69