After completing Excel 2000 MOUS Expert: Analyzing Data and Using PivotTables the user should 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 a Web browser

Using Goal Seek

	Calculating new results
	Running Goal Seek

Using Solver

	Changing multiple input cells
	Running Solver
	Reviewing Solver's results

Working with Scenarios

	Creating a scenario
	Manipulating a scenario
	Merging scenarios
	Creating a Scenario Summary

Using Data Analysis and PivotTables

	Creating a PivotTable
	Navigating in a PivotTable
	Customizing a PivotTable

Using PivotTables and PivotCharts

	Using the PivotTable AutoFormat feature
	Creating a PivotChart Report
	Customizing PivotCharts

Using a PivotTable with the Web

	Creating an interactive PivotTable
	Adding fields to a PivotTable
	Formatting PivotTables

This course has the following features:

	Exercises that allow users to practice in Excel 2000
	A file containing the text of the exercises
	Simulations that allow users to practice course skills even if they don't have access to Excel 2000
	A glossary
	A Skill Assessment

	Excel 2000 MOUS: Working with Cells (E2KM01)
	Excel 2000 MOUS: Working with Files (E2KM02)
	Excel 2000 MOUS: Formatting Worksheets (E2KM03)
	Excel 2000 MOUS: Page Setup and Printing (E2KM04)
	Excel 2000 MOUS: Worksheets & Workbooks (E2KM05)
	Excel 2000 MOUS: Formulas and Functions (E2KM06)
	Excel 2000 MOUS: Charts and Objects (E2KM07)
	Excel 2000 MOUS Expert: Importing & Exporting Data (E2KE01)
	Excel 2000 MOUS Expert: Working with Templates Links and Report Manager (E2KE02)
	Excel 2000 MOUS Expert: Formatting Sorting and Filtering Data (E2KE03)
	Excel 2000 MOUS Expert: Naming Ranges Working with Macros and Customizing Toolbars (E2KE04)
	Excel 2000 MOUS Expert: Validating and Auditing Data (E2KE05)

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.