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.
PICPA Member: $79
Nonmember: $104
Course No. 4193135B Level: Overview
Prerequisites: None.