Excel 2000 - Level 3 Training Class

Lesson 1: Working with Multiple Worksheets

Working with Workbooks
Linking Cells in Different Workbooks
Workbook Versus Links and Workspaces
Sharing and Merging Workbooks

Lesson 2: Consolidating and Analyzing Data

Consolidating Data from More Than One Worksheet
Using the Goal Seek and Solver Utilities
Using Scenario Manager to View a Worksheet with Different Input Values

Lesson 3: Using Protection and Display Options

Using Comments
Protecting Workbooks
Using Custom Views

Lesson 4: Advanced Formula Construction

Using Names
Using the IF Function
Using the VLOOKUP Function
Using IS Functions and the Auditing

Lesson 5: Introduction to Macros

Running Macros
Recording a Macro
Viewing and Editing VBA Code

Lesson 6: Customizing the Work Area

Working with Built-in Toolbars
Using Custom Toolbars
Creating and Using Styles
Using Templates

Lesson 7: Creating Excel Web Pages

Using Excel as a Web Tool
Other Web Options

Lesson 8: Working with Interactive Excel Web Documents

Saving Excel Worksheets as Web Documents
Spreadsheet Web Components