Lesson 1: Customizing Excel Workspaces
Setting Options
Customizing Toolbars
Customizing the Display of Menus and Toolbars
Creating Custom Toolbars
Adding and Deleting Toolbar Buttons
Resetting and Deleting Toolbars
Arranging and Saving Workspaces

Lesson 2: Customizing Startup
Opening Workbooks at Startup
Opening Custom Workspaces at Startup
Creating Desktop Icons

Lesson 3: Collaborating with Workgroups
Creating Templates
Editing Templates
Creating AutoTemplates
Collaborating with Workgroups
Changing Workbook Properties
Creating a Shared Workbook
Viewing Tracked Changes
Accepting and Rejecting Changes
Merging Workbooks

Lesson 4: Using AutoFormats in Worksheets and Charts
Using Built-in AutoFormats
Applying AutoFormats to Worksheets
Applying AutoFormats to Charts
Creating Custom Chart Formats
Designing Custom Chart Formats
Saving Custom Chart Formats
Applying Custom Chart Types
Deleting Custom Chart Types

Lesson 5: Controlling Macros
Controlling Macro Cell References
Using Absolute Cell Referencing
Using Relative Cell Referencing
Saving Macros for Selective Use
Saving Macros in the Personal Macro Workbook
Saving Macros in a New Workbook

Lesson 6: Editing Macros
Opening the Visual Basic Environment
Inserting Procedures
Finding and Replacing Code
Deleting and Copying Code
Adding Comments

Lesson 7: Running Macros from Menus and Buttons
Assigning Macros to the Menu Bar
Assigning Macros to Toolbar Buttons
Assigning Macros to Built-in Buttons
Assigning Macros to Custom Buttons
Assigning Macros to Worksheet Buttons
Changing Assigned Macros

Lesson 8: Making Macros Interactive
Displaying Dialog Boxes in Macros
Displaying Message Boxes in Macros

Lesson 9: Using Break Mode
Inserting Breakpoints
Inserting Stop Statements

Lesson 10: Stepping Through Macros
Stepping Over Procedures
Stepping into Procedures