Data Tables were introduced in Excel 2007. They were supposed to simplify the work with data in Excel. But in the reality they often made it more difficult. For example, handling different formulas in the same column is not really possible. Fortunately, you can easily convert a Data Table into a normal range.
Tag: datatable
Data Table: Analyze Your Results in Excel
An advanced method of analyzing the results of your calculations is to use a Data Table. With the Data Table, Excel can do your calculation again by changing two input values.