Wow i’ve 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!
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.
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.
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!
Good evening Robin, I just saw this video and read your comment which called out to me. I also wish to pass MOS Expert Excel 2016 but I do not know where to begin nor if this certification is difficult. Could you enlighten me on this?
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.
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!
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.
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.
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.
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.
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...
@@envatotuts Thanks for the reply! Auto-captioning is not accurate enough to be in compliance with accessibility law, and therefore cannot be shared in my California community college coursework. If accurate captions are ever added, please let me know, my students and I would greatly appreciate it 😊
@@Mr.RobertsonCABT Interesting. We do add captions to all our longer courses and we are working towards captioning everything. Thanks for letting us know.
Hello to all; I thank you for your clarity it is really very rich 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
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?>
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?
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.
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.
Wow i’ve 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!
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.
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.
Indeed atleast someone knows.
Ctrl+Shift+F3 to create name from selection
I have spent many videos to understand but to be very honest, this is "the best" explained video. Thanks a ton!
The way you broke down 'Scenario' to is components is simply brilliant. Great video. Thanks.
thanx perfectly worked for my 10th
IT practical
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!
Good evening Robin,
I just saw this video and read your comment which called out to me. I also wish to pass MOS Expert Excel 2016 but I do not know where to begin nor if this certification is difficult. Could you enlighten me on this?
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.
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!
Thanks a lot this really helped me with one of my assignments.
Very Helpful Demo
thanks, this is better than courses who i paid
Double thumbs up!
Thanks, Bob for the nice simple explanation.
This is very important to share it as thanks for sharing
Thanks your teaching method is clear
Wowww! It was a really great lecture. So easily Explained. Thank you so much!
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.
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.
Thank you. This is going to help me in a course assignment.
Thanks, Very Informative !
I really love it simple and helpful!
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.
Thanks😊!
Thank you very much for this epic video. It's a whole new lesson for me and I understood every step.
Better then my professor
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.
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...
Excellent video, thank you for helping me create an interactive and educational lesson for my students!
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
Great video! Thank you! :-)
I'm wondering if this could be close-captioned? I'd love to use this in my classroom!
There is closed captioning - just click the CC button in the video player. Hope that's helpful.
@@envatotuts Thanks for the reply! Auto-captioning is not accurate enough to be in compliance with accessibility law, and therefore cannot be shared in my California community college coursework. If accurate captions are ever added, please let me know, my students and I would greatly appreciate it 😊
@@Mr.RobertsonCABT Interesting. We do add captions to all our longer courses and we are working towards captioning everything. Thanks for letting us know.
Reasonably good vid but would have preferred a simpler example.
Just what I was looking for. Thanks.
Thanks Bob, keep posting more videos!
Thanks, it was of use.
Great lesson, thanks man!
You have to name cells so names could appear in the solution (scenario summary): ruclips.net/video/q-bj9WKeibs/видео.html
Thanks for the link. it really helped me
Wat ef anilyses
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
Hello to all; I thank you for your clarity it is really very rich
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
Really useful, but Carl+~doesn’t work , when I press these two screen swift to another window
That was really easy, tnx
Name the cells with the values so that the changing cells in the Scenario Summary will show the cell names rather than cell locations.
thank you for this lesson. it was very helpfull
This is very helpful, thank you so much.
great
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?>
Thank You very much!!! God Bless
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?
Thanks for the demonstration. Could you also explain how to do the same with panel data (i.e. variables are running over many years)?
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.
Is there a way to have this scenario summary dynamic where i can change the inputs of numbers?
Is there a way to put multiple values in a changing cell??
Thanks, mate! Really useful. :p
what ef analysis, in northern erland
Thank-you!
cool tutorial!!!
Thank you
thank you
thenks , god bless
super sir ....
i am interested in how did you make the “DYMO Label“ on top of the menu bar...what do you do with it ?
It is a plug in to support DYMO label printers. Has no purpose outside of those printers.
Unfortunately this tool can only handle 32 cells total
great.
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.
I always always contemplate bad scenarios like if I was Vader or so and so I would of did things differently