Up one side; down another
Data tables are a neat Excel feature that has not been emphasized.
If you are looking at, for instance, a home loan with a number of interest rates and different loan periods, a Data table can lay out the results with a minimum of fluff and formulas.
Dick Kusleika, Microsoft MVP, has a description on his excellent Daily Dose of Excel blog.
Data Table Basics
J K Pieterse:
Excel 2007, 2010, 2013 tables
How to Use Microsoft Excel Data Tables to Analyze Information in a Database
How to Create and Use One-Input Data Tables in Microsoft Excel
How to Create and Use Two-Input Data Tables in Microsoft Excel
Overview of Data Tables - 2003 and 2007
Teach two-variable Excel data tables with real-life examples
See all Topics