After completing Excel 2000 MOUS Expert: Formatting Sorting and Filtering Data the user should be able to:

	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

Formatting Numbers

	Applying number formats
	Creating custom number formats

Using and Applying Conditional Formats

	Applying conditional formats
	Finding formatted cells

Sorting and Grouping Data

	Sorting data
	Generating subtotals
	Grouping and outlining data

Using a Data Form

	Editing data
	Finding data

Using a Data Filter

	Activating AutoFilter
	Applying AutoFilter
	Extracting data

This course has the following features:

	Exercises that allow users to practice in Excel 2000
	A file containing the text of the exercises
	Simulations that allow users to practice course skills even if they don't have access to Excel 2000
	A glossary
	A Skill Assessment

	Excel 2000 MOUS: Working with Cells (E2KM01)
	Excel 2000 MOUS: Working with Files (E2KM02)
	Excel 2000 MOUS: Formatting Worksheets (E2KM03)
	Excel 2000 MOUS: Page Setup and Printing (E2KM04)
	Excel 2000 MOUS: Worksheets & Workbooks (E2KM05)
	Excel 2000 MOUS: Formulas and Functions (E2KM06)
	Excel 2000 MOUS: Charts and Objects (E2KM07)
	Excel 2000 MOUS Expert: Importing & Exporting Data (E2KE01)
	Excel 2000 MOUS Expert: Working with Templates Links and Report Manager (E2KE02)

Microsoft® is a registered trademark of Microsoft Corporation. Excel® is a registered trademark of Microsoft Corporation. Microsoft and the Microsoft Office User Specialist Logo are registered trademarks of Microsoft Corporation in the United States and other countries.