Microsoft Excel Tips and TricksData Tables are a powerful but somewhat unknown Excel feature. Data Tables, not to be confused with Tables in Excel is part of What-if-Analysis. In Excel, we frequently have complex formulas using multiple input cells. A Data Table offers one-input or two-input tables. Data Table is one of three items under What-if-Analysis and is located on the Data tab. The PMT (payment) function is an excellent example of when to use a data table.
Credit Chris Menard