Excel WhatIf Analysis with Scenario Manager and Goal Seek

[@angelicacauntay5272]

I've been watching your tutorials in your Excel playlist since the start and as an accountant, so far this one's my favourite!!! You are God-sent!

[@jessmyers2740]

These are awesome and so easy to follow. I started watching from the beginning just to see what I could learn and I'm addicted!

[@techteachersandstudents]

Glad you like them! Thanks for watching.

[@elinat6993]

Goal seek can be very useful, for example, when looking for what the price should be to make a certain profit. Thank you very much! You have a great way of presenting!

[@issacyau0916]

Oh my god! This tutorial is extremely helpful, it helps me totally understand the whole process and the purpose of the funtion. Thank you for making this video!

[@ikromrustamov6112]

Щщщшш в

[@jacquelinehadid8043]

Thanks so much for your videos!!! I paid $190 for a course and can't understand what they are talking about.. learned more from your free youtube videos!

[@sydneyrochelle9966]

It's a very nice and detailed tutorial. You helped me answer my assignments about Goal seek, Data Validation and Look Up. Looking forward for more tutorials that would help me learn into it.

[@Syahininsyirah]

Thank you so much you deserve more credit and views .This was part of my project and i liked how you were on point and i was able to focus and catch everything.So glad to have found your video.Keep it up !

[@taemi5507]

this is exactly what i needed, thanks. I have a test today haha

[@hamidmghazi]

Great tutorial. Easy and to the point. Thanks!

[@gracecowden9819]

I found after I hit OK in the goal seek it gave me ##### icons. I needed to accect the changes and then double click into the text box, and then hit enter for the sum precalculated. After doing those extra steps it seems to have worked. Thanks for the tutorials!

[@lindaoulton7549]

Great clear explanation. Thank you for posting

[@brshankar2010]

Very clear presentation. Never thought Scenario Manager & Goal seek to be so easy. I have a question. The scenario & Goal seek can be worked out for multiple options? - 1. Price change for one product for select months, 2. Qty change for 3 different months, etc?. Thanks

[@anamta7753]

did you get the answer of this ?

[@tannukumari5247]

It was indeed helpful and so easy explanation to understand 😅 Thankyou very much, sir😊

[@urvashibhardwaj6615]

This is so goooddddd!!! I loved it :) love from India

[@Chan-mq9ie]

Thank you for explaning wo clearly!

[@gtav-kv8nm]

Thank you. You explained well.

[@ubaidmiandad3480]

Superb and fantastic formulas

[@lesliewinans]

Thank You for making this easy to understand!!

[@riyan7817]

wow thank you for the tutorial, very good explanation sir

[@hinduswastika9754]

I liked this video very much thank u ,love from India

[@subhroneelsarkar-gnit]

Love from India

[@FrozenShadoW918]

iS THERE A way to get goal seek by changing many numbers? where it could avg out many variables to get to 200k?

[@dipenmodi1807]

Need relevant examples... Ones that we can relate to. The explanation was helpful! 👌

[@zuhair6661]

Great tutorial

[@kamarasiakarifa6359]

Thanks,I understood all the presentation.but my question is beside the words current year, optimistic etc is there other ideas on how to play with the data. Today is my first to treat data analysis through your presentation.please reply my comments.

[@Howtoexcelatexcel]

Definitely underused in Excel nice video

[@architapaul5032]

Would I be able to understand this these videos and other advanced Excel ones of I've done the beginner course on Excel from this channel?

[@haywirekwek]

I have a table of costing, target mark up's, GST, other costs components in order to derive a target price. But it is all dependent on an exchange rate. How do i set the target sell price of my products so that it doesn't change whenever i change the exchange rate???

[@composure7394]

Why I can't download tutorial file.?

[@alhashimiomer2112]

Really helpful

[@yousfoss4367]

Please could you help to understand comparatively the difference in the uses of the 3/4 tools of what if plus solver. thks

[@TravisMoore-li9mz]

Beautiful I must say

[@OlawaleMichael-qm4kf]

Thank you sir

[@anamta7753]

can you explain this tool with more examples and scenarios ???

[@daanvangemert8151]

Great video. Question I have: how can I change the code if the changing only needs to happen when the value in sCell is negative??

[@HimSha07]

Nice video

[@arpitsharma009]

I have a 10 row-10 columns Table and I have a Cell where I want to choose a Value which is present in B1 then in its next cell how to automatic populate the Corresponding values in other Columns... I saw hundreds of videos and it remain unanswered. how to do it seen forms, conditional formatting highlighting, but it isnt like that. I want one cell to automatically print me a value according to a value in different Cell.

[@BoxerDogs]

After you click 'Show' for a scenario, the cell values change. How would you restore the cells to the original cell values (if you did not create a scenario called 'Current')?

[@RodolfoEspinal]

You can't, just close excel and don't save it.

[@DuongThuy-mk2fm]

Can I have the file to practice by myself? I cannot go to the link in the description

[@techteachersandstudents]

Have you tried copying the link and then pasting it into your browser's address bar, and then pressing Enter (or Return)? That should work.

[@ApoTheOnion]

For Goal Seek, go to 5:32.

[@Seftehandle]

i have to ask - how is goal seek different then making 3 copy paste one bellow the other and changing the wanted numbers

[@danieltineoc]

Nice videos but your links to the files do not work.

[@carajoos5844]

This is super clear and concise and helpful but modifying the original dataset makes my who body twitch! Please please everyone make a copy of the original table and then run this on the copy! I am having a hard time seeing the value of the Goal Seek since it only allows changing a single cell and that value can very easily be calculated for a single cell. Plus, since it is changing the original data is makes me very nervous! Can you show an example of when it would actually be useful since these scenarios are not realistic? Also, wouldn't it be more useful to have all 3 scenarios side by side in their own rows instead of changing the original data table? I'm kind of failing to see the value of these built in tools but perhaps that is because I am experienced at building these types of scenario tests on my own using formulas.

[@qinliu6631]

Why didn't the Scenario work if I change the price? if I changed the price, switch between different scenarios, the data didn't go back to the original one?

[@hafsa281]

It will be very helpful if you attach the excel file for each video

[@violaantkowiak2652]

Hi can you please show video about financial calculations for beginners I want to learn to calculate on spread sheet loan interest per year etc Thank you in advance

[@annekavanagh50]

that would be a great video i also need help here

[@rakibulhaque3444]

Thanks

[@sowmyakrishnam1444]

SIMPLY SUPERB....SIR

[@orelshema]

Cool Guide!

[@arturshlyakhetko8213]

Thanks!

[@iwatchedthevideo7115]

7:25 If Martin Shkreli got a job in the card games industry

[@raiyanszone]

It's a nice excel tutorial.........

[@nancylindfield1125]

thank you

[@anjjavierto4150]

you're amazing! thank you.!

[@olindoomio6832]

Hi thanks for your tutorial. Can you please make a video about data anomaly finding and removing data anomaly from the dataset. Please I am requesting you. Thanks in advance. Keep well.

[@albertrzeszutek2645]

Great Video! Thank you ! :)

[@lucasnagildo5540]

My whatif analysis don't display in my excel

[@faisalsaood2598]

excellent thanks buddy

[@yazeedathammeh9926]

great,thank you very much

[@BobbyBhattacharjee]

What if we were dealing with large volume of data with thousands of rows inputting all that data to create scenarios would be impossible

[@susan6502]

I was also curious about this problem!

[@rangedarcher2041]

Can't we change multiple prices.... Like, just imagine that you are serious about increasing the prices to increase the sales to $200000,but you want to change all the prices to do that and not only of 'skipbo ',so will you be able to get that result through 'Goal Seek'? Very Good Video anyways. thank you

[@tuananhvu4205]

Niceeeee

[@meixo9083]

skipbo now sold with a bag of dope