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 !
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!
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.
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.
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!
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
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!
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'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 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.
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
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!
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 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
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.
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')?
![[ ออกกอง ] วัยหนุ่ม 2544 โลกหลังลูกกรง..ทัวร์กองถ่ายหนังใน "คุกของจริง" | JUSTดูIT.](http://i.ytimg.com/vi/vB--aOkZCpw/mqdefault.jpg)
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 !
Thank You for making this easy to understand!!
Need relevant examples... Ones that we can relate to. The explanation was helpful! 👌
Definitely underused in Excel nice video
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?
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!
Beautiful I must say
Nice videos but your links to the files do not work.
I liked this video very much thank u ,love from India
Thanks
Thank you sir
Dude seriously live saver
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.
Nice video
Great tutorial
Thank you. You explained well.
It will be very helpful if you attach the excel file for each video
It was indeed helpful and so easy explanation to understand 😅
Thankyou very much, sir😊
My whatif analysis don't display in my excel
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.
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.
i have to ask - how is goal seek different then making 3 copy paste one bellow the other and changing the wanted numbers
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!
Really helpful
can you explain this tool with more examples and scenarios ???
Thanks!
Thank you for explaning wo clearly!
Great tutorial. Easy and to the point. Thanks!
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.
iS THERE A way to get goal seek by changing many numbers?
where it could avg out many variables to get to 200k?
Niceeeee
skipbo now sold with a bag of dope
Superb and fantastic formulas
This is so goooddddd!!! I loved it :) love from India
this is exactly what i needed, thanks. I have a test today haha
Love from India
Why I can't download tutorial file.?
For Goal Seek, go to 5:32.
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
thank you
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!
Щщщшш в
Great clear explanation. Thank you for posting
wow thank you for the tutorial, very good explanation sir
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'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 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.
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 ?
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!
you're amazing! thank you.!
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??
Great Video! 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!
Please could you help to understand comparatively the difference in the uses of the 3/4 tools of what if plus solver.
thks
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 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
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.
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.
SIMPLY SUPERB....SIR
Cool Guide!
It's a nice excel tutorial.........
7:25 If Martin Shkreli got a job in the card games industry
great,thank you very much
excellent thanks buddy
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!