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

Please SUBSCRIBE:
Demonstration of two-way data table feature in Excel. This kind of table is sometimes referred to as a two-variable data table. This tool is one of the most commonly used for sensitivity analysis or what if analysis. The table shows the effect of changing two input variables on a selected output variable.

Download the demonstration file:

See the One-Variable Data Table tutorial:

[ApathyMLG]

This was from 2012 and it still helped me with my business class! Thank you

[robbiefelts]

12 Years later and still helps, Thanks.

[ViolentSmiley]

Thank you for the video sir. Im a senior in accounting taking a capstone Data Analytics class. You explained this way better than my professor

[zoeorlich]

Was so frustrated trying to remember what I did in excel for a certain problem in my finance class and this helped me so much thank you!!!

[cozynblue]

Thanks. Helped 'bigley' with my Excel 203 Finals!!

[etmstMdg]

lol i was watching this right before an excel quiz as a review super helpful thanks for making this video

[utubevast]

Thank you Matt. You make it very easy to understand. 

[kaleemoore]

This was super helpful. Thanks for making it plain.

[yiboxiong]

Very clear and helpful..Saved my Quiz...Big

[ayemkhin]

Omg this Enlighten me i just type the equation in google this save me big 💕

[arminemagumyan]

Thank you, Mr. Macarty, It helped me a lot!

[himQ]

I don't understand why we need the cell in E17? What does that do for the table and why?? Thanks guys.

[alvesjrnelson]

I am getting the same value for all cells and I don`t know why. Calculation option is automatic and data format looks the same. Do you have any suggestions? Thanks

[Someonebutnoone]

I have a bunch of data that I'm supposed to compare. Married and unmarried vs occupation. Married is a 1 and unmarried is a 0. Occupation is numbers 1-6. At 1:44 what am i supposed to do? Any help would be greatly appreciated.

[shawnmcdonald]

I have Excel 2007 with all the add-ins. When I use your example for the two dimension table, the results are $11, 000 in all the cells. What am I doing wrong?

[mistybruns]

How do I get the solver table downloaded?

[ridakhan]

How do you make a graph out of a two way table