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.
Objectives:
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 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
