O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8 Analyzing Alternative Data Sets

Defining and Editing Alternative Data Sets To create a scenario

  1. On the Tools menu, click Scenarios.

  2. In the Scenario Manager dialog box, click Add.

  3. In the Scenario name box, type the name of the new scenario.

  4. At the right edge of the Changing cells box, click the Collapse Dialog button.

  5. Delete the contents of the Add Scenario dialog box, and then hold down while you click the cells to include in the scenario.

  6. At the right edge of the Changing cells box, click the Expand Dialog button.

  7. Click OK.

  8. In the Scenario Values dialog box, enter the alternative values for each cell in the scenario.

  9. Click OK, click Show, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required