O'Reilly logo

Microsoft Excel 2010 In Depth by Bill Jelen

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

26. Using What-If, Scenario Manager, Goal Seek, and Solver

When Dan Bricklin invented VisiCalc in 1979, he was trying to come up with a tool that would let him quickly recalculate his MBA school case studies. Three decades later, spreadsheets are still used for the same functionality.

Newer spreadsheet tools such as Goal Seek and Solver allow you to back directly into the assumptions that lead to a solution. This chapter discusses some of Excel 2010’s features that are helpful when you try to find a specific answer.

Using What-If

After you have set up a model in Excel, you can make copies of the model side by side and then change the various input variables to test their impact on the final result. Because this type of analysis answers the ...

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