How to Perform What-If Analysis in Microsoft Excel


show more What-If Analysis provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

What-If Analysis

What if analysis let's you use the power of computer to do many mathematical calculations for you very quickly. If you know the result that you want from a formula, but not the input values that the formula needs to get that result, you can use the Goal Seek feature. And that's found under the Data tab, in the Data tools area. Excel is fairly powerful and you have three different What-If analysis options, but we're going to concentrate on the Goal Seek function in this movie and in our basics.

EatCake has been doing very well and are thinking of expanding so they want to be able to take a loan out of $100,000, and pay it over 180 months. They have a particular payment in mind, but they want to know if the interest rates are anywhere near the right levels for them to be able to secure a loan of this amount. They're not really sure what interest rates will allow them to do that. So rather then putting in values here and trying to calculate numbers here to work with this particular...

What-If Analysis
Video duration: 3m 53s 5h 13m Beginner

Viewers:

What-If Analysis provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...