Excel What-If Analysis: How to Use the Scenario Manager - Envato
video description
I am a student and I am working on my final year project, I am working on the opportunity of adopting economic xx policies in a context of crisis.
I seek through this subject to study on the one hand the performance of these policies and on the other hand predict its adoption in Morocco
I would like to know, can I use this method of waht if style to analyze the said subject?
I would like to know if I can use this waht if method to analyze the subject?
I need your help
Thank you very much for you and for all
Date: 2022-09-19
Related videos
Comments and reviews: 19
schymi841
It seems to me that Scenario Manager is completely unnecessary tool. Or maybe I'm missing something.
But as the author said at the end of the video, you could just input those values in seperate columns and have the same result. I don't think that limited space on the sheet would stop you from doing that. You can always hide and unhide the extra columns if you need to.
reply
It seems to me that Scenario Manager is completely unnecessary tool. Or maybe I'm missing something.
But as the author said at the end of the video, you could just input those values in seperate columns and have the same result. I don't think that limited space on the sheet would stop you from doing that. You can always hide and unhide the extra columns if you need to.
reply
Abigail
I've got a large budgeting workbook with multiple sheets to help me evaluate the effectiveness of marketing activities. All of these sheets pull data from an Assumptions sheet. I wanted to have multiple scenarios for my assumptions and be able to switch between them and then go to the other sheets to see results -- so not a summary and not a pivot table. Is that possible?
reply
I've got a large budgeting workbook with multiple sheets to help me evaluate the effectiveness of marketing activities. All of these sheets pull data from an Assumptions sheet. I wanted to have multiple scenarios for my assumptions and be able to switch between them and then go to the other sheets to see results -- so not a summary and not a pivot table. Is that possible?
reply
Edwin
Excel has so many built in features, but the implementation is horrible. I mean, that scroll down list of 1-5 that remains 1-5 when you scroll down, that is a HUGE flaw and will most likely never get fixed. The thing with Excel is it has not polish, which speaks volumes as to who is behind the design and organization of Excel.
reply
Excel has so many built in features, but the implementation is horrible. I mean, that scroll down list of 1-5 that remains 1-5 when you scroll down, that is a HUGE flaw and will most likely never get fixed. The thing with Excel is it has not polish, which speaks volumes as to who is behind the design and organization of Excel.
reply
Angelo
Thank you very much for creating this video Good Sir. I am currently an graduate student in an MSRED program and am working on my capstone project, which looks at real estate development cycles across different economic conditions, this let me compare easily and made a clean chart for the presentation!
reply
Thank you very much for creating this video Good Sir. I am currently an graduate student in an MSRED program and am working on my capstone project, which looks at real estate development cycles across different economic conditions, this let me compare easily and made a clean chart for the presentation!
reply
Brendan
Good explaination. Thank you. You can name cells so that when you are in the scenario manager it doesn't just say Cell B4 etc. Select the cell you want to name and to the left of the formula bar highlight the cell number present in the box and type in your value. No spaces. Must use underscores etc.
reply
Good explaination. Thank you. You can name cells so that when you are in the scenario manager it doesn't just say Cell B4 etc. Select the cell you want to name and to the left of the formula bar highlight the cell number present in the box and type in your value. No spaces. Must use underscores etc.
reply
Robin
Your video is so helpful, I'm certifying (Excel Expert) and had no idea these functions, facets, etc in Excel existed. I will make use of this later on when I'm done with several other certificates and ready to return to work for a better position. Thank you so much for your video!
reply
Your video is so helpful, I'm certifying (Excel Expert) and had no idea these functions, facets, etc in Excel existed. I will make use of this later on when I'm done with several other certificates and ready to return to work for a better position. Thank you so much for your video!
reply
Grzesiek
Interesting lesson. Thank you very much. But dont you think that keeping all the scenarios in separate sheet (similar to Scenario Summary) and refere to them based on some cell value (eg. Scenario: [1-5]) would give you similar effect but a bit more controll and flexibility? >
reply
Interesting lesson. Thank you very much. But dont you think that keeping all the scenarios in separate sheet (similar to Scenario Summary) and refere to them based on some cell value (eg. Scenario: [1-5]) would give you similar effect but a bit more controll and flexibility? >
reply
Wizard
Just a suggestion, if you select the values adjacent to the figures aswell scenario manager will let you define them as labels so no need to guess from cell b4 what it is. I. e ticket 1, 000 select both cells which contain description and amount.
reply
Just a suggestion, if you select the values adjacent to the figures aswell scenario manager will let you define them as labels so no need to guess from cell b4 what it is. I. e ticket 1, 000 select both cells which contain description and amount.
reply
itech
5: 00 Excel can show you the names, if you first Define the names for the cells you want to change, under Formula / Define Name, then you will see the name of the cell that you want to change the value.
reply
5: 00 Excel can show you the names, if you first Define the names for the cells you want to change, under Formula / Define Name, then you will see the name of the cell that you want to change the value.
reply
lmcastellvi
Well explained: Two improvements: if you name your scenario cells with meaningful EXCEL NAMES such as TOTAL_REVENUE, the panel becomes more readable. Dynamic computation should also be explained.
reply
Well explained: Two improvements: if you name your scenario cells with meaningful EXCEL NAMES such as TOTAL_REVENUE, the panel becomes more readable. Dynamic computation should also be explained.
reply
Eric
Wow ive learned more in 13 mins from this video than I have in 4 classes of a college course. My professor loves making us learn by reading a book, I cannot learn that way. Thank you for this video!
reply
Wow ive learned more in 13 mins from this video than I have in 4 classes of a college course. My professor loves making us learn by reading a book, I cannot learn that way. Thank you for this video!
reply
Saurav
There is a way to add labels. Select the columns containing item name and values and then Go to Formulas and look out for Create from Selection beside Name Manager. Job done.
reply
There is a way to add labels. Select the columns containing item name and values and then Go to Formulas and look out for Create from Selection beside Name Manager. Job done.
reply
Vina
Very cool, good job of explaining. My reading material sucks. It does not explain nothing and it doesn't even go with my assignments. Which makes it very confusing. Thank you.
reply
Very cool, good job of explaining. My reading material sucks. It does not explain nothing and it doesn't even go with my assignments. Which makes it very confusing. Thank you.
reply
Jordan
Hey, great video, you can actually give name to the input parameters by using Named ranges before creating the Scenarios; just posting this in case someone find it useful.
reply
Hey, great video, you can actually give name to the input parameters by using Named ranges before creating the Scenarios; just posting this in case someone find it useful.
reply
Kiran
We can select the description along with the values and then go to Formulas - Create from the selection so that the names are automatically defined.
reply
We can select the description along with the values and then go to Formulas - Create from the selection so that the names are automatically defined.
reply
Ahmed
I cant see the added value from it? I can do this manually in less time, so can you explain more what is the benefit of it, great tutorial btw
reply
I cant see the added value from it? I can do this manually in less time, so can you explain more what is the benefit of it, great tutorial btw
reply
kppphd
Thanks for the demonstration. Could you also explain how to do the same with panel data (i. e. variables are running over many years?
reply
Thanks for the demonstration. Could you also explain how to do the same with panel data (i. e. variables are running over many years?
reply
Wicklonious
about the problem of xl showing the cell instead of the label mentioned at 6 min, that is fixed by defining a name for the cell
reply
about the problem of xl showing the cell instead of the label mentioned at 6 min, that is fixed by defining a name for the cell
reply
Server
I always always contemplate bad scenarios like if I was Vader or so and so I would of did things differently
reply
I always always contemplate bad scenarios like if I was Vader or so and so I would of did things differently
reply
Add a review, comment
Other channel videos
