Excel 2000 MOS Expert: Naming Ranges, Working with Macros, and Customizing Toolbars

Products

Resources

Specials

Summary:

This training 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:

After completing this training 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

Outline:

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

Features:

Exercises that allow users to practice the application
A file containing the text of the exercises
Simulations that allow users to practice training course skills, even if they don't have access to the application
A glossary
A Skill Assessment

Applicability:

This training course is for anyone preparing for the MOS Excel 2000 Expert certification exam.

Prerequisites:

Excel 2000 MOS Expert: Importing and Exporting DataExcel 2000 MOS Expert: Working with Templates, Links, and Report ManagerExcel 2000 MOS Expert: Formatting, Sorting, and Filtering Data

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Microsoft® is a registered trademark of Microsoft Corporation.
Excel® is a registered trademark of Microsoft Corporation.
Microsoft and the Microsoft Office Specialist logo are registered trademarks of Microsoft Corporation in the United States and other countries.

Terms of Use:

None