What-if analysis is perhaps the most basic method for understanding worksheet data. With what-if analysis, you first calculate a formula F, based on
the input from variables X, Y, and Z. You then say, “What if I change variable X? What if I increase Y? What if I decrease Z? What happens to the result?”
For example, Figure 7.1 shows a worksheet that calculates the monthly payment for a loan or mortgage based on three variables: the interest rate, the term, and the initial principal. Cell C8 shows the result of the PMT() function. Now the questions begin: What if the interest rate is 8 percent? What if the term is 25 years? What if the principal is $125,000? Or $150,000? Answering these questions is a straightforward matter of changing the appropriate variables
and watching the effect on the result.

Changing the value of one cell and watching its effect on the values of one or more other cells is straightforward. However, what if the cells you want to watch reside in another worksheet or workbook? You can arrange the windows accordingly, but Excel has an easier method: the Paste Picture Link command.

This command takes a copy of a specified range and turns it into a snapshot: a picture of the original range that you can add to any worksheet.
The snapshot is “live,” however, so any changes that occur in the original range will also appear automatically in the snapshot. (The snapshot itself is just a Picture object, so you can’t edit the data it displays.)

Follow these steps to use Paste Picture Link to create a range snapshot:

1. Select the range you want to watch.
2. Choose Home, Copy (or press Ctrl+C).
3. Switch to the worksheet and select the cell in which you want the snapshot to display.
4. Choose Home, pull down the Paste menu, and then choose As Picture, Paste PictureLink. Excel pastes the snapshot and sets up a link to the original range.

• The seven roads to financial ruin and how to avoid driving on them. So, perusing my usual financial sites this morning, I came across this article titled "7 roads to financial ruin". Now...
• 13 Quick Tips for Better Tennis There are a lot of tennis tips and tricks floating around out there, but many are complicated and complex, and...
• The Rule of 72 - How It Helps, And How It Doesn't Would you like an easy way to approximate the rate of return or amount of time needed to achieve a...
• Money, Gold, the FED, and why you should be concerned about the US Dollar This is a guest post by Mr Credit Card from askmrcreditcard.com. Though Mr Credit Card reviews credit cards, today, he...
• Avoid the Bond Fund Trap Investment professionals often preach to the masses (that's us) that two of the biggest killers of investment returns are fear...