Sizzling Minerals
A unique Life-Changing Product that Everyone Needs

We can reveal a Critical Health Secret most people are not aware of…


Excel 2000 MOS Expert: Analyzing Data and Using PivotTables

Total Time: 3 hour(s)

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

Ojectives: 
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

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 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

 
   
 
  Home | Privacy | Contact Us