Excel 2000 MOUS Expert

Import & Export

	Import data from a text file
	Import data from an application
	Import a table from an HTML file
	Query a database
	Export data to an application

Templates, Links, & Reports

	Create a template and apply it to a workbook
	Edit a template
	Use a workspace
	Link workbooks
	Preview and print worksheets
	Use the Report Manager

Format, Filter, & Sort Data

	Apply accounting currency and number formats to data
	Create a custom number format
	Use and apply conditional formatting
	Sort data
	Generate subtotals
	Group and outline data
	Use a data form for data entry and retrieval
	Create a data filter
	Extract data

Ranges, Macros, & Toolbars

	Add and delete a named range
	Use a named range in a formula
	Use lookup functions (HLOOKUP and VLOOKUP)
	Record and run a macro
	Edit a macro
	Assign a macro to a toolbar button
	Hide display and customize toolbars

Validate and Audit Data

	Validate data
	Use the Auditing toolbar
	Trace cells referenced in a formula (precedents)
	Trace formulas that depend on contents of a cell (dependents)

Analysis & PivotTables

	Use Goal Seek to backsolve from a solution to its values
	Use Solver
	Work with scenarios
	Use PivotTables for data analysis
	Use the PivotTable AutoFormat feature
	Create PivotChart reports
	Create an interactive PivotTable for the Web
	Add fields to a PivotTable using a Web browser

Security & Sharing

	Create edit and remove a comment
	Change workbook properties
	Apply and remove worksheet and workbook protection
	Apply and remove file passwords
	Track and accept or reject changes to a workbook
	Create a shared workbook
	Merge workbooks