Total Time: 5 hour(s)

Summary: 
This course shows users how to add and delete a named range and use a named range in a formula; use the HLOOKUP and VLOOKUP functions; record, run, and edit a macro, assign a macro to a toolbar button; and hide, display, and customize toolbars.

Ojectives: 
After completing this course, students will be able to:
Add and delete a named range
Use a named range in a formula
Use lookup functions (HLOOKUP and VLOOKUP)
Record a macro
Run a macro
Edit a macro
Assign a macro to a toolbar button
Hide and display toolbars
Customize a toolbar

Topics: 
Adding, Using and Deleting a Named Range
Using Lookup Functions
Recording and Running a Macro
Editing a Macro
Working with Toolbars

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.