Excel 2000 MOS Expert: Analyzing Data and Using PivotTables
Product Code: E2KE06 Time: 3 Hour(s) CEUs: .30

Summary:

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

Objectives:

After completing this 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 course skills, even if they don't have access to the application
  • A glossary
  • A Skill Assessment

Applicability:

This 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

Copyright © 2004 eLearningDepot.com. All rights reserved.