User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
Excel 2000 MOS Expert Series: Naming Ranges, Working with Macros, and Customizing Toolbars
Product Code: e2ke04 Time: 5.0 hour(s) CEUs: Available

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.

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 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.

Copyright � 2006 Webteks. All rights reserved.