A data table is a range of cells that shows how changing one or two variables in your formula will affect the results of those formulas. Data tables provide a shortcut for calculating multiple results in one operation and a way to view and compare the results of all the different variations together on your sheet. Overview Data tables are part of a suite of commands that are called What-if Analysis tools. When you use data tables, you are doing what-if analysis. What-if analysis changes the values in cells to see how those changes will affect the outcome of formulas on the sheet. For example, you can use a data table to vary the interest rate and term length that are used in a loan to determine possible monthly payment amounts. There are three kinds of what-if analysis tools in Excel: scenarios, data tables, and Goal Seek. Scenarios and data tables take sets of input values and determine possible results. Goal ...