Example of how to build a sensitivity analysis table in Excel to evaluate how changing two inputs simultaneously will affect an output (profit). This is one of the functions on the “What-If-Analysis” section of Excel.

RESOURCES & LINKS:

____________________________________________

► Download the practice file we use in the video:

My Courses:

► Become an Excel Power User in 2.5 Hours (81% discount):

► Master Excel Keyboard Shortcuts (85% discount):

Related Financial Modeling Videos:

► Using NPV & IRR to Analyze Investments:

► Build a 3 Statement Financial Model:

► Goal Seek in Excel:

► Build an Excel Combo Chart (Dual Axis):

► Subscribe for more finance videos:

____________________________________________

Sensitivity analysis in Excel is one of the skills that separates the common Excel user from the power user.

Often we try to analyze business problems my thinking about what will happen if certain things change. For instance, what happens if we change the price? Well, the revenue would go up if we just changed price for a business, but total customers stayed the same.

However, the reality is that in reality, you never have scenarios where one variable changes, but everything else stays the same. There are always repercussions. When you raise the price, usually some customers will stop buying, but some will continue.

So when trying to analyze situations, it is better to try to build models and analyses that reflect many different variables changing at the same time.

This is where sensitivity analysis comes in. Using this Excel feature, we are able to examine how multiple changing variables will affect different business metrics. To do this, we can build a “sensitivity data table” to examine the range of possible outcomes.

In this tutorial, we learn how to build a sensitivity analysis table in Excel 2016 to evaluate how changing two inputs simultaneously will affect an output (profit).

I hope you enjoyed this tutorial, please subscribe to my channel:

► Subscribe for more finance videos:

If you’d like to improve your skills and resume, I built a business-focused Excel course on Udemy that teaches the 20% of Excel used for 80% of business.

The course is 2.5 hours and includes things like:

-Completely abandoning the mouse to increase speed 3X

-Data manipulation & visualization

-Conditional statements & pivot tables

Thousands of people from over 80 countries have taken the course, with the skills helping them pass college exams, receive job offers, and even get raises. Take a look at the reviews!

Nguồn: https://vnecon.vn/

Xem thêm bài viết khác: https://vnecon.vn/tong-hop

### Xem thêm Bài Viết:

- BÀI RAP VỀ NAKROTH BBOY CÔNG NGHÊ
- Onmyoji Arena | Cách lên đồ mạnh nhất cho Enma – Diêm Ma, xạ thủ bắn 1 ăn 3 nhưng hơi bị ngu
- Doraemon Tập 55 – Miếng Dán Hoán Đổi Vai Trò Làm Mẹ, Dây Tiếp Đất Truyền Hoảng Loạn – Hoạt Hình
- [Topgame] Top 6 game online miễn phí 100% đã hay lại còn đồ họa đẹp | PC #1
- TỬ VI NỮ SINH NĂM 1991 – TÂN MÙI CUNG MỆNH PHONG THỦY HỢP TUỔI GÌ?

didnt understand at 2:49. can you explain it in slow, so we can learn. thank you.

Show how to configure the table on the left side first, before jumping to computing. That's half the work.

Hey! Love your videos. Straight to the point and easy to pick up. However, Im having trouble trying to understand how does this table derive its numbers?

Check out my brand new video on valuing companies using the Discounted Cash Flow Method ► https://youtu.be/Gm0Xn_MidZ8

thanks for the explanation

Hey Eric I have a similar kind of analysis but this involves a equation containing the involvement of parameters taken in the row and columns, can you help me on that. I will share more details if you are interested

so good and very easy to comprehend, concise!! Thank youuu

God Bless You, Thank you!

Great tutorial!

Love your work

Actually, I have a question. I just read through your course description on Udemy. I’d be interested in enrolling but I have a Mac and was wondering how dramatic the drawbacks are since you recommend having windows. What I’m wondering is whether there will be merely slight differences in keyboard shortcuts or more substantial disadvantages which will not allow me to properly follow the course and execute all functions you teach. Thank you for your answer in advance. All best, Albert

Great Video. Clearly explained! Thank you !

What if analysis and sensitivity analysis are not the same thing. This video is useless for my sensitivity analysis problem.

Super helpful! Thank you!

Very easy to understand. Good job!

I built a tool that lets you run a sensitivity analysis by simply uploading your Excel file: https://causal.app/sensitivity

please do scenario analysis for the same variables used above

Is not coming

No matter how much experience you have using Excel, there's always something new to learn 👍

Thank you, very useful video

I built an Excel sensitivity analysis tool – https://causal.app/sensitivity. It figures out which variables in your model are the most important, and shows you what happens if you vary each variable one by one.

The video is a very good example. this type of analysis will need some marketing facts as well in order to find the best price strategy.

Short easy clear and crisp

great video! Love kind of short lessons. Thank you and waiting more ones like that!

E-mail please i Want To ask u about sensitivity analysis

You explained everything so clearly and didn't waste any time! Everything so precise.

The part where the data table self populated blew my mind. Thank you Eric

Thank You!

Eric, I set up the table just like you do in the video and followed the steps to the letter, but after I input the variables into the Data Table and click OK the OP remains the same at $4000 under each assumption.. I am using Excel 2016 as a part of the Microsoft 365 suite.

What's wrong?

Thanks – very helpful and straightforward!

hi, when i do the same method, I obtain the same numbers in all the boxes (the one we put in the top left corner). Does someone know where the error might come from ?

Thanks

simple thanks you

Helpful thank you!

I've never seen a YouTube video that is so precise, concise and straight to the point before. Thank you, Eric

Thanks Eric! Very clear explanation. I have some questions regarding your keyboard shortcut operations. I saw you quickly removed two decimal places, but with alt key, and H and 9, you can only remove 1 decimal places. How did you manage to remove two decimals in only one or two press on keyboard? Thanks for your help!

Isnt it scenario analysis, since you are changing 2 assumptions at a time?

Does not help

https://en.m.wikipedia.org/wiki/Sensitivity_analysis

Thanks Eric. It was effective

Thank you Eric, that was useful and easy to follow

As a Chinese, his English still make sense to me to understand how to use Excel Table function to solve practical problems/assignments. Many thanks!

Thanks Eric for this video.

how come the column and row cell selections gets mixed up when data is analysed – how can your prevent this ??