Excel 2000 MOUS Expert

Synopsis
Excel 2000 MOUS Expert: Naming Ranges Working with Macros and Customizing Toolbars shows users how to create and use named ranges and how to use lookup functions. It also shows how to record run and edit a macro as well as hide display and customize toolbars.

Audience
This course is for anyone preparing for the MOUS Excel 2000 Expert certification exam.

Time
4 hours

Product Code: E2KE04

After completing Excel 2000 MOUS Expert: Naming Ranges Working with Macros and Customizing Toolbars the user should be able to:

Add and delete a named range

Use a named range in a formula

Use lookup functions (HLOOKUP and VLOOKUP)

Record and run a macro

Edit a macro

Assign a macro to a toolbar button

Hide display and customize toolbars

Adding Using & Deleting a Named Range
Adding and deleting a named range

Using a named range in a formula

Using Lookup Functions
Using the Lookup Wizard

Using the HLOOKUP function

Using the VLOOKUP function

Recording and Running a Macro
Recording a macro

Running a macro

Editing a Macro
Using the Visual Basic Editor

Editing the keyboard shortcut

Assigning a macro to a toolbar button

Working with Toolbars
Hiding and displaying toolbars

Customizing a toolbar

This course has the following features:

Exercises that allow users to practice in Excel 2000

A file containing the text of the exercises

Simulations that allow users to practice course skills even if they don't have access to Excel 2000

A glossary

A Skill Assessment

Excel 2000 MOUS: Working with Cells (E2KM01)

Excel 2000 MOUS: Working with Files (E2KM02)

Excel 2000 MOUS: Formatting Worksheets (E2KM03)

Excel 2000 MOUS: Page Setup and Printing (E2KM04)

Excel 2000 MOUS: Worksheets & Workbooks (E2KM05)

Excel 2000 MOUS: Formulas and Functions (E2KM06)

Excel 2000 MOUS: Charts and Objects (E2KM07)

Excel 2000 MOUS Expert: Importing & Exporting Data (E2KE01)

Excel 2000 MOUS Expert: Working with Templates Links and Report Manager (E2KE02)

Excel 2000 MOUS Expert: Formatting Sorting and Filtering Data (E2KE03)

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

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.