MP9002: Desktop Computing - Naming Ranges, Working with Macros, and Customizing Toolbars > Excel 2000 MOS Expert

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. 

Topics:
Adding, Using and Deleting a Named Range
Using Lookup Functions
Recording and Running a Macro
Editing a Macro
Working with 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

Duration:
5 Hours