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!
The video is super clear. In 8 minutes you explained it perfectly. Loved it. I would however not use this functionality in a real use cases, as reality is always more complex and you rarely change only one variable. So I rather set up helper table, where I would include several combinations. I even think that I would be faster in my results. But, as I said: The video is super. Thanks a lot.
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!
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!
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 !
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.
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!
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
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.
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???
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.
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.
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')?
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
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?
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.
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
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!
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!
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!
Glad you like them! Thanks for watching.
The video is super clear. In 8 minutes you explained it perfectly. Loved it. I would however not use this functionality in a real use cases, as reality is always more complex and you rarely change only one variable. So I rather set up helper table, where I would include several combinations. I even think that I would be faster in my results. But, as I said: The video is super. Thanks a lot.
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!
Щщщшш в
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!
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 !
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.
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!
this is exactly what i needed, thanks. I have a test today haha
This is so goooddddd!!! I loved it :) love from India
It was indeed helpful and so easy explanation to understand 😅
Thankyou very much, sir😊
Love from India
Thank you for explaning wo clearly!
Great tutorial. Easy and to the point. Thanks!
Thank you. You explained well.
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
did you get the answer of this ?
Superb and fantastic formulas
I liked this video very much thank u ,love from India
Great clear explanation. Thank you for posting
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.
iS THERE A way to get goal seek by changing many numbers?
where it could avg out many variables to get to 200k?
wow thank you for the tutorial, very good explanation sir
Thank You for making this easy to understand!!
Definitely underused in Excel nice video
Great tutorial
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?
Need relevant examples... Ones that we can relate to. The explanation was helpful! 👌
Really helpful
Beautiful I must say
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???
It will be very helpful if you attach the excel file for each video
Thank you sir
Please could you help to understand comparatively the difference in the uses of the 3/4 tools of what if plus solver.
thks
can you explain this tool with more examples and scenarios ???
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.
Nice video
Why I can't download tutorial file.?
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.
Can I have the file to practice by myself? I cannot go to the link in the description
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.
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??
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')?
You can't, just close excel and don't save it.
i have to ask - how is goal seek different then making 3 copy paste one bellow the other and changing the wanted numbers
Nice videos but your links to the files do not work.
SIMPLY SUPERB....SIR
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
that would be a great video i also need help here
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?
Cool Guide!
Great Video! Thank you ! :)
you're amazing! thank you.!
7:25 If Martin Shkreli got a job in the card games industry
Thanks
For Goal Seek, go to 5:32.
It's a nice excel tutorial.........
Thanks!
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.
excellent thanks buddy
great,thank you very much
thank you
What if we were dealing with large volume of data with thousands of rows inputting all that data to create scenarios would be impossible
I was also curious about this problem!
My whatif analysis don't display in my excel
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
skipbo now sold with a bag of dope
Niceeeee