O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

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 ...

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