Excel 2000 - Tips, Tricks, and Macros Training Class

Lesson 1: Advanced Macros

Write a Basic Macro
Use IF-THEN-END IF Statements
Use SELECT CASE-END SELECT Statements
Use WITH-END WITH Statements
Explore Error Handling
Program the Office Assistant

Lesson 2: Template Enhancements

Hide Data
Use Cell Locking and Protection
Create Styles
Use Excel Event Procedures

Lesson 3: On-screen Forms

Use Forms Controls
Use ActiveX Controls
Modify ActiveX Control Properties
Assign Macros to ActiveX Controls

Lesson 4: Workgroup Features

Office Collaboration
Create a Shared Workbook
Track Workbook Changes
Distribute a Shared Workbook
Resolve Workbook Changes