Objectives
• Create a macro in Excel using the Macro Recorder tool
• Manage the fundamental elements of macros in Excel, including accessing macro functionality, naming macros, shortcut keys, storing and deleting macros, absolute vs. relative cell references in macros, and macro security
• Identify the usefulness of the Macro Recorder and list four critical limitations of the Macro Recorder; additionally, modify Excel's Quick Access Toolbar and the Ribbon to provide shortcuts to macros
• List the nine essential elements of macros written using Visual Basic for Applications and utilize the Visual Basic Editor; manage macros through copy/paste and delete processes
• Create variables in macros and identify the purpose of branching and conditional logic routines such as IF/THEN/ELSE, DO/WHILE, and CASE