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:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
