No video
Data Sensitivity Analysis in Excel - What If Data Tables
Рет қаралды 114,951
Күн бұрынVBA/Macros Course (40% Discount): www.teachexcel...
Excel File: www.teachexcel...
Excel Forum: www.teachexcel...
Multiple ways to conduct a Sensitivity Analysis on your data in Excel - this is a great feature that allows you to test the outcome of changing one or multiple inputs.
Here you will learn how to do a horizontal, vertical, double, and multiple Sensitivity Analysis using the What If Data Table feature. The double version is a two-variable analysis and the multiple version allows testing the output from multiple formulas at the same time.
This is a handy tool to have in your pocket when you are working in Excel and, though it seems confusing at first, it really only requires getting the table structure input correctly.
Once you understand how to use this feature, you will be able to quickly and easily see by how much changing an input will change calculation output in the worksheet in Excel.
I hope you enjoy this Excel Data Analysis tutorial :)
TeachExcel.com
@jjmimid 3 жыл бұрын
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 3 жыл бұрын
You are very welcome! I'm very glad I could help :)))
@ElnurShabanov Жыл бұрын
The best ever explanation of Data Table. Thanks!
@chelseawang8014 4 жыл бұрын
Thank you so much for such a clear and complete introduction to sensitivity analysis! It is very helpful!
@sarithaalaparthi 3 жыл бұрын
thankyou for such a clarity and explanation with simple examples.
@TeachExcel 3 жыл бұрын
You are very welcome :)
@matsersilvaworld5224 6 ай бұрын
Hi, can we use this method to do sensitivity analysis in Analytical Hierachical Process (AHP)?
@samhitha8615 4 жыл бұрын
Thank you. You saved my day. Super clear.
@amagwu1 2 жыл бұрын
Great exercise! Thanks!
@muzakirzaki6043 2 жыл бұрын
great tutorial God bless you gracefully
@wayneedmondson1065 2 жыл бұрын
Nice lesson! Thanks!!
@noanxietyprep 11 ай бұрын
This super helpful. Thank you!
@alexrosen8762 4 жыл бұрын
Super useful. Thanks!
@sobroc 3 жыл бұрын
Thanks. This was really helpful. PS: I am a bachelor student.
@TeachExcel 3 жыл бұрын
You're welcome Stig! I'm glad I could help :)
@barrydragon8667 2 жыл бұрын
Very helpful. Ty very much!
@BudiSetiawan-iu3ps 4 жыл бұрын
hello, can we perform multiple values for more than 1 data input?
@YoungTX84 4 жыл бұрын
You may already know this but an easier way to access the paste special window is by pressing Ctlr+Alt+V
@ugrood75 4 жыл бұрын
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
@Chan-mq9ie 3 жыл бұрын
Great video! Thank you!
@briandennehy6380 4 жыл бұрын
Nice job thanks
@GabiRav 3 жыл бұрын
For making serial numbers you can use a tool in the excel ☺
@justdont5735 4 жыл бұрын
This was really helpful, thank you!
@MohammedIslamElshiekhElsmani 2 жыл бұрын
Interested!!
@lizkim1731 3 жыл бұрын
amazing tutorial
@benvelloor 4 жыл бұрын
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 4 жыл бұрын
Yes you can. You do it with Excel Solver, I'm learning this now.
@entertainmentgalaxy971 4 жыл бұрын
its good to see that feature of excel but that feature must be dynamic.
@1rasha 3 жыл бұрын
Thanks; it helped. But i have one query on this. Will you address please
@jabmalassie 3 жыл бұрын
13:17 MULTIPLE VALUES
@sustainablehampo757 3 жыл бұрын
Wonderful
@natashasaupe9136 3 жыл бұрын
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 3 жыл бұрын
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 3 жыл бұрын
did u get how to solve the issue, I am dying in trying to figure it out with my assignment.
@natashasaupe9136 3 жыл бұрын
@@abdulhafeez9090 do you still need help hafeez ?...or dah dpt buat dah...?
@nomadsoulkarma 3 жыл бұрын
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 3 жыл бұрын
🏆
奧特羅羅 Ultraman
Рет қаралды 6 МЛН
Leila Gharani
Рет қаралды 482 М.
Data Science at INCAE
Рет қаралды 56 М.
奧特羅羅 Ultraman
Рет қаралды 6 МЛН