After completing Excel 2002: Worksheets and Workbooks, the user should be able to:

	Modify row and column formats
	Modify worksheet names and positions
	Insert and delete worksheets
	Use 3-D references
	Check spelling
	Work with a subset of data by filtering lists

Working with Rows and Columns

	Inserting and deleting rows and columns
	Hiding and unhiding rows and columns
	Freezing and unfreezing rows and columns
	Splitting a worksheet

Working with Worksheets

	Moving between worksheets in a workbook
	Renaming a worksheet
	Inserting and deleting worksheets
	Moving and copying worksheets

Linking Worksheets and Consolidating Data

	Using 3-D references in a formula
	Using 3-D references in a function
	Using Paste Special

Zooming and Spell-Checking

	Changing the zoom setting
	Checking spelling

Using a Data Filter

	Activating AutoFilter
	Applying AutoFilter
	Extracting data

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: Formulas and Functions (EXPM06)
	Excel 2002: Charts and Objects (EXPM07)

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