Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Excel Macros 4173135B
Register View Registrations Tell a Friend About This EventTell a Friend
 

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, 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 popular Excel function.

 Export to Your Calendar 10/27/2017
When: 9:30 AM to 11:30 AM
Where: Webinar/Webcast
United States
Presenter: Jeff S. Lenning, CPA, CITP
Contact: April Deneault
801-466-10479


Online registration is available until: 10/27/2017
« Go to Upcoming Event List  

Curriculums:   Computers and Technology,Financial Leadership Forum

NASBA Credit Category:  Computer Software and Applications

CPE Hours:  2

Description

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, 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 popular Excel function. Also, discover 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.

Materials are provided as an ebook.



Major Subjects

  • Macro recorder
  • Visual basic editor
  • Quick access toolbar

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.

Level:  Overview

Designed For

Accountants using Excel for Windows.

Advanced Prep:

None.

Prerequisite

None.

Membership Management Software Powered by YourMembership  ::  Legal