After completing Excel 2000 MOUS: Formulas and Functions, the user should be able to:

	Enter and revise formulas
	Use absolute and relative references
	Use the AutoSum feature
	Enter and use basic functions
	Enter and use date functions, financial functions, and logical functions

Working with Formulas

	Entering formulas
	Entering a range
	Revising formulas

Using References and AutoSum

	Using absolute and relative references
	Using AutoSum

Entering Functions

	Using the Paste Function
	Using the Formula Palette

Using Basic and Date Functions

	Using the AVERAGE, SUM, COUNT, MIN, and MAX functions
	Using the NOW and DATE functions

Using Financial and Logical Functions

	Using the FV and PMT financial functions
	Using the IF logical function

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 course index
	A glossary
	A Skill Assessment

	Office 2000: Getting Started (O2KC01)
	Office 2000: Editing Text and Printing (O2KC02)
	Office 2000: Text and Document Formats (O2KC03)
	Office 2000: Introduction to Excel (O2KC05)
	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: Charts and Objects (E2KM07)

Microsoft® is a registered trademark of Microsoft Corporation. Excel® is a registered trademark of Microsoft Corporation.