What-If analysis in Excel with a Data Table by Chris Menard

Excel offers either one input or two input data table. Both are available under the Data tab, What-if analysis. You need both input and dependent cells to do a data table.

A Data Table allows you to have multiple inputs and see how different inputs values would impact the result. This is extremely useful to analyze a problem in Excel.

Blog Post on Data Tables:

Chris Menard's Website:

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!

[matthewmulligan]

YOU JUST SAVED MY FINANCIAL MODEL ASSIGNMENT. GOATED

[albertodamian]

You just spent 10 seconds teaching me what a semester’s worth of office hours and 2 guided tutoring sessions a week couldn’t!

[olivier]

Absolutely brilliant mate, I didn't understand my teacher but you did it perfectly, thank you very much

[DavidWilliams-wjsc]

i always write my PMT formulas like this -pmt(rate, nper, pv) ....to force it positive. vs =pmt(rate, nper, -pv) In other words, change the equals sign to a neg at the start.
Nice video. I'm using it for a pricing sheet for buying house. I can look down one column for expected rents, and the top row is price of property. Where they meet is how much cash flow I would get. I used formulas before, but now, after your video I use a data table. Thanks!

[MrMechE]

Thanks! Helped me with my HW. Thumbs up

[rinasimangan]

This is the perfect tutorial for whatif analysis.

[bobvandersmissen]

you just saved my exam, this is more or less an exercise on my exam!!!

[d.m.]

Thank you for the help. This was very helpful in passing my project in my foundations of computer information systems course.

[srinivaasn]

Thanks for the tutorial. Clear and crisp.

[shiblee]

Hey man thanks for making it so easier to understand and to follow . You are best

[ivanpparra]

Very well explained and great example. Thank you!

[ivanostojcic]

Very useful video to remind me again of this function. Thanks a lot, Chris

[trevor]

Great video Chris! Very informative and I like how you do the steps from the start. Will definitely be coming back for other videos.

[ellazhao]

your shortcut of ctrl+~ saved my thank you so much!

[wkkmkpz]

I did my homework for school thanks to you

[williamrivera]

Thank you so much for this instructional video. It's very clear, concise and easy.

[yefaobeng]

Thank you for making it so clear! Much Much Much better than Microsoft Support service!

[yanwenwei]

Thanks, Chris! It's really helpful!

[neenareadsalot]

Thank you. I knew I was missing a step and you helped me remember. :)

[harryputra]

Don't forget to : File> options> formula> workbook calculation should be set to Automatic.