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 formula, we're going to use the…

Resume Transcript Auto-Scroll

Author

Released

1/31/2007

Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.

Skill Level Beginner

5h 13m

Duration

1,185,535

Views

Show MoreShow Less

Q: When trying to apply the techniques from the “Relative and absolute referencing” video to a worksheet other than the exercise file included with the title, the formulas did not work for the entire worksheet. The formulas would only work when going through the worksheet row by row. What could be causing this to happen?

A: When trying to apply formulas to a whole workshee, here is a tip to try:

If you want to always refer to the same cell then use an absolute reference. For example, always pulling the value from cell A3 would be referenced as $A$3. This will never change no matter where you copy it to in the spreadsheet.

If you want to reuse the same formula, but with values in different cells, use the relative reference, A3. This way formula =A3*B3 will become =A4*B4 as you copy it down a column.

Q: In the chapter 7 video "Sorting and Grouping" at approximately 4:05, the author says to go to cell 5 on the worksheet and click on Subtotal to subtotal the grouping. My screen will not allow me to click on the Subtotal option at the top of the page. Is this an issue with my version of Excel?

A: It seems that there is an error in the instructions in this video. The video should have instructed users to do the subtotaling first, then create the table.