Excel 2000 Advanced
The Excel 2000 Advanced tutorial takes you step by step through the advanced tasks in Excel 2000.
Ranges and Lookup Functions Working with Named Ranges
Vlookup and Hlookup Functions
Data Management Importing Files
Custom and Conditional Formats
Validating Data
Group Editing Sharing and Protecting Files
Using Comments
Tracking Workbook Changes
Auditing, Scenarios and Reporting Using Auditing Tools
Using the Scenario Manager
Using Custom Views
Working with Report Manager
Database and Analysis Tools Working with Databases
Filtering Data
Sorting and Subtotalling
Goal Seek and Goal Solver
PivotTables Working with PivotTables
PivotTables on the Web