Excel 2000 MOUS Expert

Synopsis
Excel 2000 MOUS Expert: Analyzing Data and Using PivotTables shows users how to use data analysis tools such as Goal Seek Solver and scenarios. It also shows how to use PivotTables and PivotCharts.

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

Time
3 hours

Product Code: E2KE06

After completing Excel 2000 MOUS Expert: Analyzing Data and Using PivotTables the user should be able to:

Use Goal Seek to backsolve from a solution to its values

Use Solver

Work with scenarios

Use PivotTables for data analysis

Use the PivotTable AutoFormat feature

Create PivotChart reports

Create an interactive PivotTable for the Web

Add fields to a PivotTable using a Web browser

Using Goal Seek
Calculating new results

Running Goal Seek

Using Solver
Changing multiple input cells

Running Solver

Reviewing Solver's results

Working with Scenarios
Creating a scenario

Manipulating a scenario

Merging scenarios

Creating a Scenario Summary

Using Data Analysis and PivotTables
Creating a PivotTable

Navigating in a PivotTable

Customizing a PivotTable

Using PivotTables and PivotCharts
Using the PivotTable AutoFormat feature

Creating a PivotChart Report

Customizing PivotCharts

Using a PivotTable with the Web
Creating an interactive PivotTable

Adding fields to a PivotTable

Formatting PivotTables

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)

Excel 2000 MOUS Expert: Naming Ranges Working with Macros and Customizing Toolbars (E2KE04)

Excel 2000 MOUS Expert: Validating and Auditing Data (E2KE05)

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.