Data Sensitivity Analysis in Excel - What If Data Tables

[@ElnurShabanov]

The best ever explanation of Data Table. Thanks!

[@chelseawang8014]

Thank you so much for such a clear and complete introduction to sensitivity analysis! It is very helpful!

[@jjmimid]

This really saved me the night before my exam. not sure how this button was "unchecked" but I spent hours trying to resolve my issue. THANK YOU FOR POSTING THIS!!!!

[@TeachExcel]

You are very welcome! I'm very glad I could help :)))

[@sarithaalaparthi]

thankyou for such a clarity and explanation with simple examples.

[@TeachExcel]

You are very welcome :)

[@samhitha8615]

Thank you. You saved my day. Super clear.

[@wayneedmondson1065]

Nice lesson! Thanks!!

[@noanxietyprep]

This super helpful. Thank you!

[@alexrosen8762]

Super useful. Thanks!

[@muzakirzaki6043]

great tutorial God bless you gracefully

[@barrydragon8667]

Very helpful. Ty very much!

[@Chan-mq9ie]

Great video! Thank you!

[@justdont5735]

This was really helpful, thank you!

[@briandennehy6380]

Nice job thanks

[@MohammedIslamElshiekhElsmani]

Interested!!

[@lizkim1731]

amazing tutorial

[@sobroc]

Thanks. This was really helpful. PS: I am a bachelor student.

[@TeachExcel]

You're welcome Stig! I'm glad I could help :)

[@mastersilvaworld]

Hi, can we use this method to do sensitivity analysis in Analytical Hierachical Process (AHP)?

[@jabmalassie]

13:17 MULTIPLE VALUES

[@sustainablehampo757]

Wonderful

[@BudiSetiawan-iu3ps]

hello, can we perform multiple values for more than 1 data input?

[@YoungTX84]

You may already know this but an easier way to access the paste special window is by pressing Ctlr+Alt+V

[@benvelloor]

Excellent tutorial! I had a doubt though! Is there any way to perform what if analysis with 3 input variables? I am guessing no, but just to clarify.

[@marvinjean1898]

Yes you can. You do it with Excel Solver, I'm learning this now.

[@GabiRav]

For making serial numbers you can use a tool in the excel ☺

[@ugrood75]

Thank you. I just wanted if you can help me how to change a TRUE or FALSE variable into numbers. For example, TRUE =1 and FALSE =0. Qualitative data change into Quantitative report

[@entertainmentgalaxy971]

its good to see that feature of excel but that feature must be dynamic.

[@1rasha]

Thanks; it helped. But i have one query on this. Will you address please

[@natashasaupe9136]

Sir. help me... why i did the what if analysis but after i click ok... it appear the same amount for all boxes.... really need help 😭

[@TeachExcel]

Tasha, you need to ask in my forum on teachexcel.com and upload a sample file and description of what you did. I'm sure it was just a simple mistake.

[@abdulhafeez9090]

did u get how to solve the issue, I am dying in trying to figure it out with my assignment.

[@natashasaupe9136]

@@abdulhafeez9090 do you still need help hafeez ?...or dah dpt buat dah...?

[@nomadsoulkarma]

Yea, me too, but I found what I did wrong: I forgot toput: =B1*B2 in B3 so do that and it will resolve

[@agape13]

🏆