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!
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!
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???
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')?
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.
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?
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'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!
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.
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!
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!
Щщщшш в
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
Love from India
Great tutorial. Easy and to the point. Thanks!
Thank you for explaning wo clearly!
Great clear explanation. Thank you for posting
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
This is so goooddddd!!! I loved it :) love from India
It was indeed helpful and so easy explanation to understand 😅
Thankyou very much, sir😊
Thank you sir
Great tutorial
Thank You for making this easy to understand!!
wow thank you for the tutorial, very good explanation sir
Really helpful
Nice video
Need relevant examples... Ones that we can relate to. The explanation was helpful! 👌
Thanks
Definitely underused in Excel nice video
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.
Thanks!
iS THERE A way to get goal seek by changing many numbers?
where it could avg out many variables to get to 200k?
SIMPLY SUPERB....SIR
thank you
It will be very helpful if you attach the excel file for each video
you're amazing! thank you.!
Cool Guide!
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 nice excel tutorial.........
Great Video! Thank you ! :)
Please could you help to understand comparatively the difference in the uses of the 3/4 tools of what if plus solver.
thks
great,thank you very much
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
excellent thanks buddy
7:25 If Martin Shkreli got a job in the card games industry
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.
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?
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.
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??
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 you explain this tool with more examples and scenarios ???
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!
For Goal Seek, go to 5:32.
Why I can't download tutorial file.?
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?
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'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 have to ask - how is goal seek different then making 3 copy paste one bellow the other and changing the wanted numbers
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.
Niceeeee
My whatif analysis don't display in my excel
skipbo now sold with a bag of dope