Excel 2000 Expert

Importing and Exporting Data
Import data from text files (insert, drag-and-drop) operations
Import from other applications
Import a table from an HTML file (insert and drag and drop operations, including HTML round tripping)
Export to other applications

Using Templates
Apply templates
Edit templates
Create templates

Using Multiple Workbooks
Use a workspace
Link workbooks

Formatting Numbers
Apply number formats (accounting, currency, and number)
Create custom number formats
Use conditional formatting

Printing Workbooks
Print and preview multiple worksheets
Use the Report Manager

Use the Report Manager
Add and delete a named range
Use a named range in a formula
Use Lookup Functions (Hlookup or Vlookup)

Working with Toolbars
Hide and display toolbars
Customize a toolbar
Assign a macro to a command button

Using Macros
Record macros
Run macros
Edit macros

Auditing a Worksheet
Work with the Auditing Toolbar
Trace errors (find and fix errors)
Trace precedents (find cells referred to in a specific formula)
Trace dependents (find formulas that refer to a specific cell)

Displaying and Formatting Data
Apply conditional formats
Perform single and multilevel sorts
Use grouping and outlines
Use data forms
Use subtotaling
Apply data filters
Extract data
Query databases
Use data validation

Using Analysis Tools
Use the Microsoft PivotTable® autoformat
Use Goal Seek
Create Microsoft PivotChart® reports
Work with Scenarios
Use Solver
Use data analysis and PivotTable
Create interactive tables for the Web with PivotTable
Add fields to a table using the Web browser

Collaborating with Workgroups
Create, edit, and remove a comment
Apply and remove worksheet and workbook protection
Change workbook properties
Apply and remove file passwords
Track changes (highlight, accept, and reject)
Create a shared workbook
Link worksheets and consolidate data using 3-D references