Back to Search

Excel Macros Webinar

CPE

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

CPE Credits
2-Other

Details

 Pricing

PICPA Member: $79 | Nonmember: $104


 More Information

Course No.
4193135B
Level
Overview
Prerequisites
None.

Description

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



Speaker(s)


You May Also Like

2019 Leadership Conference
Sept. 19 | Harrisburg
...
Google Location Intelligence Tools for Accountants Webinar
Aug. 26 | Webinar
This course provides a concise overview of Google’s suite of location intelligence tools. These applications can be used by accountants to prepare geographic visualizations, create collaborative maps, derive insights ...
Excel Budgeting Ideas Webinar
Aug. 26 | Webinar
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match ...