O'Reilly logo

Office 2013 In Depth by Joe Habraken

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

Performing a What-If Analysis

Excel provides you with the ability to perform a what-if analysis on worksheet data. An analysis of the data in a worksheet can really be approached in two different ways: manipulating values to affect outcomes or specifying an outcome such as a required net profit, and allowing Excel to determine the values required to give you the desired outcome.

As already mentioned, the first possibility for conducting a what-if analysis consists of varying key values in a worksheet, which enables you to see how these changes to the key values affect the result of a particular formula or function. For example, you might want to analyze how different variable costs, such as marketing and supplies, affect your net profits.

There ...

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