Excel Macros Webcast | 4183135A

Instructors

Date :
July 12, 2018 8:30 AM - 10:30 AM
Location :
Webcast
Facility :
Webcast Rebroadcast
Level of Difficulty :
Overview
Member Price :
70.00
Nonmember Price :
94.00
CPE Credits :
CPE 2.00
Show tabs


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.

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.

Major Subjects:

  • Macro recorder
  • Visual basic editor
  • Quick access toolbar

Advanced Prep:

None.

Misc. Information:

Join or Renew Today

Save with Discount Programs
Level of Difficulty:
Overview
Prerequisites:

None.

Designed For:

Accountants and business professionals.

Instructors

Jeff S Lenning, CPA
Jeff Lenning of Click Consulting, Inc., is a CPA and published author. He has written several articles for the Journal of Accountancy and other publications. His firm specializes in providing computer consulting services to CPA firms and their clients. Web site: http://www.clickconsulting.com
No Agenda or Materials posted.