Excel Goal Seek Explained in Simple Steps
Вставка
- Опубліковано 5 вер 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
Unlock the potential of Excel's Goal Seek feature in this insightful tutorial! Learn how Goal Seek can simplify complex calculations, especially when you know your target outcome but not the pathway. Ideal for sales, finance, and any data-driven field.
🔍 What You'll Learn:
- How to use Goal Seek to find specific outcomes in Excel.
- Practical applications of Goal Seek in sales and financial reporting.
- Streamlining calculations when only the target result is known.
👨💼 Perfect for:
- Professionals in sales and finance looking to achieve specific targets.
- Excel users who want to enhance their problem-solving skills.
- Anyone interested in efficient data manipulation in Excel.
📌 Key Highlights:
- Effortlessly adjust data to meet desired outcomes.
- Discover practical examples of Goal Seek in action.
- Prepare for more complex scenarios with Solver in the next video.
- Curious what goal seek does? Find out now, because it can save you time.
Read the article: www.xelplus.co...
Excel's Goal Seek tool is in the Data Tools Tab as a part of What-If Analysis in the Excel Ribbon.
Goal seek can be described as follows:
• It is the opposite of a formula: instead of finding the end result, you give it the end result and it gives you the input
• It eliminates the trial and error process
• It is like guessing on speed. It’s useful for situations where you want quick answers
• It is a simplified Solver
The main advantage of Goal seek is that you don’t have to change your Excel formulas or turn a formula field to an input field.
Solver video: • Excel Solver - Example...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Stay Ahead with Our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
I tried to understand this from two other very highly rated Excel teachers. I finally understood it with your explanation. Very grateful!!!!!!!!!! Thanks for posting.
Probably you focused harder this time :-)
The way she explains the topic in intro solves half the dilemma ....the objective of a specific topic and later the concept are cross referred ...excellent trainer I must say
Thank you very much, Leila!
Regards,
Zlatka Gocheva, Bulgaria
Mam... May God continue to shower his richest blessings over you. Thank you for your awesome teachings.
Thank you Nilesh for the kind words.
Quick overview of how to use Goal Seek. Looking forward to the Solver video.
Will be out next week :)
Dear Mrs, Leila Gharami thank you your videos are always useful. you're doing great job we hope you will continue
u r such a lovely person. so warm and cheerful. u make boring stuff interesting
ohhh thank you! Appreciate the nice comment and support.
You're my rescuer.. If I Faced any minefield Miss/Mrs. leila is here.. Thank you so much..
So nice of you :)
Leila, another great teaching and useful video! Look forward to the solver video.
Glad you like it.
You are amazing tutor!! You explain excel in a simple way and giving specific examples helps me to understand better the application of each tool at Excel.
I would like also to watch a video about VBA, Macros and Scenario Manager examples.
Thank you!!
Thanks Vasiliki. I'm glad the explanations are clear. I am currently working on a VBA course and will be posting some videos here on UA-cam as well - probably next week Thursday....
I loved this video it was really very helpful for my daughter to understand goal seek .I have tried many times to explain goal seek to her.But everytime she was confused with it. Thanku so much Leila.
Thanks for your comment. Very happy to hear that Vishnu!
Thanks for the ease of your explaination and the way you deliver the info.
Keep up the good work
Leila, you are amazing. God richly bless you.
Thank you Robert. Glad you like it.
my 2 months dilemma just solved today, Gracias miss 😍
Thank you very much for the lecture. You made it very simple and easy to understand.
Thank you. This will help me in a course assignment.
Nice and in simple way you communicated. Excellent
Thank you for your video.
Your so amazing. You just saved me so much time!! Always come in clutch
Leila you're a live saver! i know you know !
excellent, thank you very much!
Hi liela, Thanks giving formula for the goal seek 👍👍
You're very welcome!
Extremely, I particularly enjoyed this and it was very beneficial in enabling me to study for my commerce exams
Thanks Leila ! It is very clearly !
You're very welcome Hanh.
Hi Thank you so much for this video, it really does help me
Thank you, Leila!
You're welcome Darkhan!
I wish you will be a famous UA-camr one day (in Sha Allah)
At that time
Don't forget your old viwers.
Thanks for your support :) I'm very happy even if only a handful of people benefit from the content here.
she is famous
very well explained
You're amazing. Thanks for simplifying this.
Good video!
Great video.
This helped a lot , Thank youuu
You a great person thank you for teaching us
.
Thank you
Enjoying your many videos
graduated to this one today
Off to solver
Much appreciated Leila G
Keep well
.
Very nice explanation! i'll take a look to the solver video! thanks!
Thank you very much for the lecture.
You are an amazing tutor
Leila Thank You for interesting and useful video!
You're welcome Learn Excel :)
You are such a great tutor. Thank you
Thanks for watching!
Thank you for your video! I have a question I want to apply goal seek for multiple outcomes. I have several lines with specific outcome - but Goal seek or solver only applies to one cell. How can I apply to multiple cells?
I will push a little bit here: is there a chance to use Goal Seek (or an equivalent function) for an entire column of a table? basically, to have the search done without being forced to use the procedure for each line of the column? I hope that this would be interesting for other "students" of yours... And, like many of them, I wish you good luck for 2020! Happy New Year!
I have the same question
Thank you Leila for this... this is very useful...
You made my day, thanks
Wonderful, thank you.
Excellent. loved the goal seek function
Great to hear!
thank you
Very good explanation, cant wait for solver video !
You're very welcome.
love your voice!
Thanks
Very well explained
Thanks mam really worth
Thank you so much mam!
You're very welcome.
Thanks😊😊😊
Thank you for goal seek fun!
Very well explained! Good that you differenciated between input and output cells. One tip, especially if the model is quite large: use in the formula bar: Trace Precedents, or Trace Dependents. You might check if the arrows "flow" from the Set Cell and Changing cell. I use the Goal Seek very often in my classes for caclulating Break Even Points. In that case you have to substract the two "y" values and this result is the set cell that should be 0.
Looking forward to solver......
Hi Bart - That's a great tip! Specially for more complex setups. Thanks for sharing.
Good One
Thank you!
You're very welcome.
Hi Leila.. Great video and good explanation.. Waiting for power query tutorials
Glad you like it Balaji :)
How to use Goal Seek dynamically please help me
Thank you so so much. You helped me so much. :)
Glad I could help, Andreea!
Ohh Good Video and most helpful Thank ......
You're welcome Majid. Glad you find it helpful.
Please discuss also scenario manager. Thanks mam!
I tried writing a macro using a button and a loop where goal seek would move line to line down a column to calculate margins it would only work for about 10 rows until it crashed. This was a few years ago never went back to work on it. However it initially worked
Very well explained!
Thakn you vvvmuch
Thanks very much.
ty
Pretty easy, I'm just making it harder than it really is lol.
Can u teach scenario manager
Great video help me alot... The solver one was better... If you could show more complex examples I would appreciate it verry much..
I LOVE YOU INCREDIBLY.. THANK YOU VERY MUCH
You're welcome!
thanks thanks
Cool goal seek :)
Thanks Malina :)
How are the cells changing colors? Input in red and output in green?
Many Thanks,
SIMPLE AND INTERESTING
Thanks. Glad you like it.
thank u. its very useful
You're very welcome Don.
Thanks a lot. It helped a lot
Can you teach us how to get the impact to goal, pretty please? :)
Have been using goal seek. It only works in this vertical layout with the numbers ordered a specific way. The data input appears to allow you to pull cells from anywhere on the sheet but won't return an answer unless it is in this super specific format. Highly frustrating and makes goal seek next to useless.
you have a soothing voice. I am gonna fall asleep.
Great😃🤩
Great teacher
Thanks. Glad you like it Nabil.
Thanks for this
I often use goal seek to calculate 365/365 payment on amortization table. I kinda hate it and know there are "simpler" ways because accounting software always seems to get the value automatically.
Is there a formula to replicate goal seek method in excel ?
Leila, have you ever heard rose diagram (used in geology)? Please show us how to do it please. @t
Thanks in advance
Your big fan
Looks similar to the solve function in matlab. Would be useful when the equation is a ridiculously long.
There is also a Solver function in Excel. It's for more complex “what-if-analysis” which Goal Seek can’t do. You can check it out here: ua-cam.com/video/dRm5MEoA3OI/v-deo.html
Thanks a ton LG
You are my fevrt teacher ❤️
You're welcome Dev. Glad to hear that :)
You are my worst commenter
Bartamwala
Keep getting “cell must contain a value’ for some reason
thank youuuu
I wish she can drop the excel file for practice to make the video useful.
Hi Leila , thanks for training , where are you from ? although i can guess that 😊😊😊
Can it be integrated in vba program
What to do if by changing cell is more than one cell
Hi Leila, is it possible to set not a specific goal but MAX value?
You should check out solver. It gives you more flexibility: ua-cam.com/video/dRm5MEoA3OI/v-deo.html
hi as you said you will show solver in your next video thank you. pls can you share example of employees head count required (FTE) calculation based on average handle time and shrinkage of 25 , need to calculate total employee required
Hi Amol - I just filmed the Solver video. How about you post your specific question either here: www.mrexcel.com/forum or here: www.excelforum.com/ - you can post a link to your question here too and if I get a chance I can take a look, otherwise you will get answers from others...
Is goal seek good for Mortgage Cal. Or for EMI
Yes - you can also use it for Mortgage Cal.
split the data in column B into a column for Item # in column C
text to columns?