Excel What If Analysis: Data Table One Variable (Excel 2016)

This video shows how to do what if analysis one variable data table in excel 2016.

[@jacquelynhavlik5577]

I had a project due in my spreadsheet class-I understood the concept but was struggling to execute. You helped me so much! Thank you Mr. Crow!

[@crowsmathclass]

You’re welcome.

[@mikeggera]

Splendid example and Mr. Crow's measured pace really helped me to understand this concept when other videos were not as helpful.

[@crowsmathclass]

Thank you.

[@hellonihaocomoestas]

I watched multiple other videos on this very topic. This is the most practical and concise one that I've seen. Thank you

[@crowsmathclass]

Thank you.

[@car25ram]

Steve your the man!

[@crowsmathclass]

Thank you.

[@aidanward2960]

Good sir you have just saved my gpa

[@crowsmathclass]

Glad it helped.

[@hemantamallik380]

Thank you so much. Your video helped me a lot.

[@crowsmathclass]

You’re welcome. Glad it helped.

[@alanpatten9651]

Man your videos are saving my Excel Course grade!! Thank you so much for these!

[@crowsmathclass]

You’re welcome. Glad they are helping. Good luck in your class.

[@MoneySkills4Life]

Thanks, it helped!

[@crowsmathclass]

You’re welcome. Glad it helped.

[@ercanyavuz1962]

Bende girdim bu şirkete paramı çekemiyorum sigorta parası istiyorlar

[@JacksonWelch]

Thank you!

[@crowsmathclass]

You’re welcome.

[@mateotorresdedullen4595]

if ya ain't from the south, i dont know it either! erbody!!!!!

[@robdowns9339]

Thanks, I do incredible things in excel, but remembering how to set up data tables is the least intuitive thing there is in excel. Whenever I search for a refresher, I am usually confused. Your example perfectly fit's my needed use.

[@crowsmathclass]

You’re welcome. Glad it helped.

[@KP-dd2ci]

I used to be very proficient in Excel...but for some reason can't get the 1 column table to work...feel like a total tool!!!

[@KP-dd2ci]

Solution...exit and re open file...numbers finally updated

[@MC-zr7hl]

Thanks so much for that description. After class Ive watched 2 other videos trying to understand the input cell and just wasn't getting it. I thought the inputs were the first column in the table, I didn't understand that those values were being put into the cell we were choosing in the "column input cell." Very cool, thanks again!

[@crowsmathclass]

You’re welcome. Glad it helped.

[@juanmelecio5178]

Question, what if once, formatting the formula with the name and the total is a negative. How can you fix it to where it only displays the name instead of the negative sign with the name? example: home->number group->number format->custom->general->"balance" but it displays -balance because the total is negative.

[@justinmaduako4315]

((Thanks, Mr. Crow, for letting me watch the Excel What If Analysis: Data Table One Variable (Excel 2016) video, while I do my homework, it was brilliant (Homework Emoji Combos | 🏡📝 👁📖📚🏫👨🏿‍🎓👨‍🔬➕➖✖➗))). Sincerely, Justin Maduako

[@crowsmathclass]

You’re welcome.

[@Rickyboparai9]

well explained

[@crowsmathclass]

Thank you.

[@adireddy7677]

Thanks Steve!

[@crowsmathclass]

You’re welcome.

[@davjasso5270]

i love u bro

[@crowsmathclass]

Glad it helped.

[@mahnoorzaheer1903]

Hey! I am trying to make one variable data table but it shows the same value in all cells. I did add it in Column input cell (my table is vertical like yours) and my output cells are also linked but it is still not working. What should I do? My assignment is due tonight

[@crowsmathclass]

I would not know what to tell you without seeing what you did. Try watching the video again and make sure you didn’t leave anything out.

[@mahnoorzaheer1903]

@@crowsmathclass do you have a proffesional email where i can email you the assignment?

[@harrygamer4190]

thank youuuu

[@crowsmathclass]

You’re welcome.

[@johncarlomendoza114]

Tyvm

[@crowsmathclass]

You’re welcome.

[@malinamuhtaer8622]

Thank you so much, your video is really helpful. 10 times better than my professor's.

[@crowsmathclass]

You’re welcome. Glad it helped.

[@mynamebean8561]

Thank you so much! I spent like 10 hrs trying to find the answer!

[@crowsmathclass]

You’re welcome. Glad it helped.

[@brooklyn6067]

you are an absolute legend mr crow

[@crowsmathclass]

Thank you.

[@kaitoyu3937]

Mr. Crow you are a legend. Thank you

[@crowsmathclass]

Thank you.

[@smathe7]

You’re the best! Thank you

[@crowsmathclass]

Thank you.

[@MacOSTrash]

Thanks chief

[@crowsmathclass]

You’re welcome.

[@ThaisAudibert]

so helpful!

[@crowsmathclass]

Thank you. Glad it helped.