How to make a two way (two variable) data table in Excel

# How to make a two way (two variable) data table in Excel Learn how to create a **two-way data table in Excel** to perform professional-level sensitivity analysis. This tutorial covers the step-by-step process of setting up a two-variable data table to see how changing two different inputs impacts your final output. A two-way data table is one of Excel's most powerful **"What-If Analysis"** tools. It allows you to visualize a matrix of outcomes—for example, seeing how varying both "price" and "response rate" affects your total profit simultaneously. ### In this video * **00:00** - Introduction to Two-Way Data Tables * **01:18** - Setting up the input variable array for rows and columns * **01:44** - The critical difference in model connection between 1-way and 2-way tables * **02:01** - Using the What-If Analysis menu to link row and column inputs * **02:43** - Applying Conditional Formatting to interpret large data matrices ### Resources & Links: * **Download the demonstration file:** https://alphabench.com/data/DirectMail.xlsx * **Watch Next (One-Variable Data Table):** https://youtu.be/fSi3i3Hyvyg * **Subscribe for more Excel & Analytics tips:** https://www.youtube.com/subscription_center?add_user=mjmacarty #ExcelTutorial #DataAnalysis #WhatIfAnalysis #ExcelTips #SensitivityAnalysis #BusinessAnalytics #ExcelDataTables #DataVisualization #FinancialModeling --- **Please SUBSCRIBE:** https://www.youtube.com/subscription_center?add_user=mjmacarty