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

	Work with formulas
	Use references and AutoSum
	Enter Functions
	Use basic and date functions
	Use financial and logical functions

Working with Formulas

	Creating formulas
	Revising formulas

Using References and AutoSum

	Using relative references
	Using absolute references
	Using AutoSum

Entering Functions

	Selecting a function
	Including arguments

Using Basic and Date Functions

	Using basic functions
	Using date functions

Using Financial and Logical Functions

	Using financial functions
	Using logical functions
	Using nested IF functions

This course has the following features:

	Exercises that allow users to practice in Excel 2002
	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 2002
	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 2002: Working with Cells (EXPM01)
	Excel 2002: Working with Files (EXPM02)
	Excel 2002: Formatting Worksheets (EXPM03)
	Excel 2002: Page Setup and Printing (EXPM04)
	Excel 2002: Worksheets and Workbooks (EXPM05)

Excel 2002: Charts and Objects (EXPM07)

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