McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Glossary
Data Files
Buzz in IT
Learning Objectives
Chapter Outline
Prerequisites
Multiple Choice Quiz
Short Answer
True or False
Case Problems
Hands-On Exercises
Feedback
Help Center


Advantage Series MS Office XP Excel 2002
Advantage Series: Microsoft® Excel 2002
Sarah Hutchinson-Clifford
Glen Coulthard
Decision-Making Using Excel

Learning Objectives

After completing this chapter, you will be able to:

1.

Describe methods for analyzing what-if scenarios

2.

Use Goal Seek and Solver to find the input values required to calculate a target outcome

3.

Use Scenario Manager to summarize assumptions and outcomes

4.

Forecast future results and plot a trendline in a chart

5.

Use one-input and two-input data tables

6.

Create, customize, and format PivotTable reports, PivotChart reports, and PivotTable lists

7.

Create custom views and save a workspace




McGraw-Hill/Irwin




Copyright2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.