Excel WhatIf Analysis with Scenario Manager and Goal Seek
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Arpit
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.
reply
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.
reply
Ranged
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
reply
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
reply
Ravi
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
reply
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
reply
Daniel
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???
reply
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???
reply
Grace
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!
reply
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!
reply
Insyirah
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 !
reply
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 !
reply
Sydney
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.
reply
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.
reply
Olindo
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.
reply
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.
reply
Viola
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
reply
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
reply
Issac
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!
reply
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!
reply
Add a review, comment
Other channel videos
