Microsoft Office Tutorials and References

In Depth Information

**Summarizing Loan Options Using a Data Table**

Figure 13-4:
Calculating a credit card payment schedule.

Summarizing Loan Options Using a Data Table

If you’re faced with making a decision about borrowing money, you have to choose between

many variables, not the least of which is the interest rate. Fortunately, Excel’s Data Table

command (Data

➜

Data Tools

➜

What-If Analysis

➜

Data Table) can help by summarizing the results of

calculations using different inputs.

The workbook
loan data tables.xlsx
contains the examples in this section and

can be found on the companion CD-ROM.

The data table feature is one of Excel’s most under-utilized tools. A data table is a dynamic range

that summarizes formula cells for varying input cells. You can create a data table fairly easily, but

data tables have some limitations. In particular, a data table can deal with only one or two input

cells at a time. This limitation becomes clear as you view the examples.

Creating a one-way data table

A
one-way data table
shows the results of any number of calculations for different values of a

single input cell. Figure 13-5 shows the general layout for a one-way data table.