After completing Excel 2000 MOUS Expert: Naming Ranges Working with Macros and Customizing Toolbars the user should be able to:

	Add and delete a named range
	Use a named range in a formula
	Use lookup functions (HLOOKUP and VLOOKUP)
	Record and run a macro
	Edit a macro
	Assign a macro to a toolbar button
	Hide display and customize toolbars

Adding Using & Deleting a Named Range

	Adding and deleting a named range
	Using a named range in a formula

Using Lookup Functions

	Using the Lookup Wizard
	Using the HLOOKUP function
	Using the VLOOKUP function

Recording and Running a Macro

	Recording a macro
	Running a macro

Editing a Macro

	Using the Visual Basic Editor
	Editing the keyboard shortcut
	Assigning a macro to a toolbar button

Working with Toolbars

	Hiding and displaying toolbars
	Customizing a toolbar

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)
	Excel 2000 MOUS Expert: Formatting Sorting and Filtering Data (E2KE03)

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.