Customizing the Excel Interface
Setting Options
Customizing Toolbars
Customizing Menus
Creating Workspaces

Using Templates
Creating Templates
Editing Templates

Using Custom Chart Types
Applying Built-in Custom Chart Types
Creating User-Defined Custom Chart Types
Saving User-Defined Custom Chart Types
Applying and Deleting User-Defined Custom Chart Types

Collaborating with Workgroups
Changing Workbook Properties
Creating Shared Workbooks
Viewing Tracked Changes
Accepting and Rejecting Changes
Merging Workbooks
Sharing Workbooks with Mail Recipients

Working with External Data and Web Documents
Importing Data from External Sources
Working with XML Documents
Importing Data from the Web

Creating Macros
Recording Macros
Running Macros
Using Absolute Cell References in Macros
Using Relative Cell References in Macros
Saving Macros for Selective Use

Editing Macros
Editing Macro Code
Inserting Procedures into Macros
Finding and Replacing Macro Code
Adding Comments to Macros

Running Macros from Menus and Buttons
Assigning Macros to Menus
Assigning Macros to Worksheet Buttons
Changing Assigned Macros

Making Macros Interactive
Adding Dialog Boxes to Macros
Adding Message Boxes to Macros
Adding "If…Then…Else" Statements to Macros

Debugging Macros
Inserting Breakpoints
Inserting Stop Statements
Adding Watch Expressions
Stepping Over Procedures
Stepping Into Procedures