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 --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

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!