Two Variable Data Tables in Microsoft Excel Tutorial

Three weeks back I covered creating Single Variable Data Tables in Excel. As promised, in this tutorial I will cover creating a two variable data table. This tutorial assumes that you have read the earlier one and are comfortable with creating a single variable data table.

Data Tables in Excel tutorial

In my last Excel Tutorial, I covered using SUMIFS and SUMPRODUCT. Data Tables is also an advanced topic in Microsoft Excel that falls under the category of What-If Analysis. What-If or Sensitivity Analysis is carried out to study the variation of the output to changes in the input variable.