Excel 2000 MOS Expert Series: Analyzing Data and Using PivotTables
Product Code: e2ke06 Time: 3.0 hour(s) CEUs: Available

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

Objectives:

  • 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


Topics:

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

Technical Requirements:
Minimum 500MHz Processor; 128 MB RAM; Minimum display resolution 1024x768; Windows 2000, XP, Vista, 7 or Mac OS X v10.4+; Internet Explorer 7.0+ or Firefox 3.0+ or Chrome 3.0+ or Safari 4.0+. 56K minimum connection; Adobe Flash Player 9.0+ or Windows Media Player 9.0+ for IE users who do not have Adobe Flash Player; JavaScript, popup windows and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright Information:

Trademark Information:
Product names mentioned in this catalog may be trademarks/servicemarks or registered trademarks/servicemarks of their respective companies and are hereby acknowledged. All product names that are known to be trademarks or service marks have been appropriately capitalized. Use of a name in this catalog is for identification purposes only, and should not be regarded as affecting the validity of any trademark or service mark, or as suggesting any affiliation between MindLeaders, Inc. and the trademark/servicemark proprietor.

Terms of Use:

Copyright © 2011 MindLeaders. All rights reserved.