Recording macros

• Accessing the Developer Tab (2007 and 2010)
• Naming conventions and storage locations
• Recording macros
• Absolute and relative cell addressing

Running macros

• Assigning macros to toolbars or menus (2003)
• Assigning macros to the Quick Access Toolbar (2007 and 2010)
• Assigning macros to objects
• Creating new tabs (2010 only)

Workbook macros

• Recording macros in a specific workbook
• Saving the workbook as an Excel Macro-Enabled Workbook (2007 and 2010 only)
• Creating quick access items specific to workbooks (2007 and 2010 only)

Creating macro toolbars (2003)

• Creating a custom toolbar
• Adding macro buttons to the toolbar
• Attaching the toolbar to a workbook

Storing macros in workbooks (2007 and 2010)

• Recording macros in a specific workbook
• Saving the workbook as an Excel Macro-Enabled Workbook
• Creating quick access items specific to workbooks

Macro management

• Deleting macros
• Setting macro options
• Macro security

The Visual Basic environment

• Project explorer
• Code window
• Properties window

Working with code

• Code structure
• Adding comments
• Navigating within your code
• Editing macro code
• Getting help with syntax

Commonly used commands

• Workbook and worksheet commands
• Excel selection methods

Debugging

• Errors
• Using debug

Function procedures

• Creating function macros