MP9002: Desktop Computing - Analyzing Data and Using PivotTables > Excel 2000 MOS Expert

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

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

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

Duration:
3 Hours