Excel 2000 MOUS

Working with Cells

	Enter data
	Edit one or more cells
	Find and replace values
	Use the AutoFill feature to create series
	Create and edit hyperlinks

Working with Files

	Open files
	Save files
	Send a workbook via e-mail
	Save a worksheet or workbook as a Web page
	Use the Office Assistant

Formatting Worksheets

	Format cells
	Adjust alignment and indentation of text in cells
	Adjust rows and columns
	Format numbers
	Use the AutoFormatting feature
	Define apply and remove a style

Page Setup and Printing

	Preview worksheets workbooks and Web pages
	Change page setup
	Set up headers and footers
	Set print options
	Print worksheets workbooks and selections

Worksheets & Workbooks

	Insert and delete rows and columns
	Hide and unhide rows and columns
	Freeze and unfreeze rows and columns
	Move between worksheets in a workbook
	Rename insert delete move and copy worksheets
	Link worksheets consolidate data and check spelling

Formulas and Functions

	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

Charts and Objects

	Use the Chart Wizard to create a chart
	Modify charts
	Preview and print charts
	Insert move and delete an object (picture)
	Create and modify lines and objects