O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

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

Chapter 9

Working with Data Analysis Tools

Create a Data Table

If you want to study the effect that different input values have on a formula, one solution is to set up the worksheet model and then manually change the formula’s input cells. For example, if you are calculating a loan payment, you can enter different interest rate values to see how this affects the payment.

The problem with this method is that you see only a single result at one time. A better solution is to set up a data table, which is a range that consists of the formula you are using and multiple input values for that formula. Excel automatically creates a solution to the formula for each different input value.

Create a Data Table

Type the input values:

To enter the values ...

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