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.
 
Search JabSto ::




Custom Search