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, 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
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.
Designed For
Accountants using Excel for Windows.
Course Pricing
WYOCPA Member Fee
$69.00
Non-Member Fee
$89.00
Your Price
$89.00
Upcoming Courses
-
The Best Individual Income Tax Update Course by Surgent
October 31, 2024
-
Surgent's Industry Accountant Key Performance Metrics
October 31, 2024
-
Advanced Excel: Hidden Secrets and Gems
October 31, 2024
View all upcoming courses