Excel Macros Webinar

Aug 16
11:00 - 1:00 p.m.

Online

2-Other
CPE Credits

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

Highlights

What does one do when a setting, shortcut or command is not available in Excel? Create a macro, of course. Macros allow Excel users to extend the capabilities of Excel and create shortcuts and commands.

Become familiar with the recorder to create a macro that applies a built-in format setting. Then, write a macro in the Visual Basic editor to provide a shortcut to a favorite Excel function. Also, discover how to add macros to the Quick Access Toolbar to easily execute them in the future.

This course demonstrates exercises using Excel for Windows.

Note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web.

Materials are provided as an ebook.

Registration

PICPA Member: $79
Nonmember: $104

More Information

Course No. 4193135B Level: Overview

Prerequisites: None.

Speaker(s)

Jeff Lenning