Excel - Data Tables - One-Input and Two-Input Data Tables

In Microsoft Excel, a Data Table represents one of the valuable tools within the What-If Analysis suite. It empowers users to experiment with various input values for formulas, enabling them to observe the subsequent impact on the formula's output. Data Tables are found on the Data tab in the
Forecast group, in the What-If analysis command. Don't get a Data Table and a Table confused. They are different features in Excel.

You can do a one-input or two-input data table. Here is a great example. Assume you are looking to purchase a home. There are three things that can change - they are called Input Cells. The Interest Rate, the Terms (years), and the Interest Rate. With a data table, you can use a 3D reference to quickly see different scenarios.

Chapters:
0:00 Intro
0:30 PMT function
1:05 Input and Dependent Cells
1:20 One-input Data Table
3:17 Hide cell
4:45 Two-input Data Table
7:18 Closing remarks

#chrismenardtraining #chrismenard #msexcel #exceltraining #microsoft #microsoftexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[sarahniemi]

Thank you! I was struggling with this concept and you explained it very well.

[adrinating]

Hi Chris! I am currently facing an issue for my project whereby I am unable to obtain the same value for my profit in my calculations and in my data table. For my profit, it was obtained through some randomised variables.

How can I work around this issue?

[firmaevents]

Thank you alot. But can it also be done with scenario manager?