Assessing the Impact of Variables Using Data Tables

A data table is a tool you can use to calculate how one or two variables change the result of a calculation. Use a data table when you want to see the range of results in a worksheet rather than seeing a single result at a time.

Creating a Data Table with One Variable

When you need to see how only one variable changes the result of a calculation, you can quickly create a data table. You place the input values—the values you want to test—in either a row or a column, and then tell Excel where to find them.

Creating a data table seems odd at first, but you'll quickly get the hang of it. Try this example of putting together a data table that uses one variable.

First, create a new worksheet and set ...

Get Learn Excel 2011 for Mac now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.