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.
- Macro recorder
- Visual basic editor
- Quick access toolbar
- 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.
Accountants and business professionals.
Registration for this course has passed.
Applicable if you are a HSCPA member in good standing.
Applicable if you are not a HSCPA member.