Excel 2000 MOS Expert: Analyzing Data and Using PivotTables

Products

Resources

Specials

Summary:

This training course shows how to use data analysis tools such as Goal Seek, Solver, and Scenarios, and PivotTables and PivotCharts.

Objectives:

After completing this training course , students will 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 the Web browser

Outline:

Using Goal Seek
Using Solver
Working with Scenarios
Using Data Analysis and PivotTables
Using PivotTables and PivotCharts
Using a PivotTable with the Web

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 DataExcel 2000 MOS Expert: Naming Ranges, Working with Macros, and Customizing ToolbarsExcel 2000 MOS Expert: Validating and Auditing 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 User Specialist® logo are registered trademarks of Microsoft Corporation in the United States and other countries

Terms of Use:

None