Goal Seek In Excel (Working Backwards From An Answer)
Discover Goal Seek - a little-known tool that removes the guesswork and gives you the exact answer you require.
When an Excel formula uses two or more input cells to generate its answer, it can be time-consuming to tweak the values to arrive at the exact answer you require.
GOAL SEEK solves this problem by allowing you to set the final answer to whatever you want, then asking Excel to work out (reverse engineer) what the input value needs to be to arrive at that answer.
In this video I build a PMT function (and explain how that works best) then walk you through the GOAL SEEK process. You will discover ...
- how to set up your data
- 3 different ways to use the Goal Seek tool
- a simple but complete demonstration of the PMT function
Lots of useful tips along the way.
😃 TIME CODES (click the link to go directly to that spot in the video)
- (0:00) Intro to Goal Seek
- (0:22) My PMT Goal Seek example data
- (2:54) Why use Goal Seek?
- (3:24) Where to find the Goal Seek tool.
- (3:33) Example 1: How much more could you borrow if you paid back more each month?
- (4:07) Example 2: What is the highest interest rate you could afford to repay if your payment amounts were higher?
- (4:30) Example 3: How much would the higher repayment reduce the length of your loan?
- (5:02) Summary and wrap up
I trust you found this video useful. What ONE thing resonated with you the most? Let me know by adding a quick comment below and click the thumbs up button under the video! Oh, and subscribe if you'd like to see more like this.
😃 USEFUL LINKS:
Share this Video:
https://www.youtube.com/watch?v=He_ob8ydc9E&t=0s
😃 SUBSCRIBE if you want to see more content like this
https://www.youtube.com/c/JasonMorrell?sub_confirmation=1
😃 HIRE JASON to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching
https://trst.com.au/microsoft-troubleshooter/?ref=yt
😃 ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.
😃 LET'S CONNECT!
https://officemastery.com (free training on the blog)
https://facebook.com/officemastery
https://linkedin.com/in/jkmorrell
https://youtube.com/JasonMorrell
Have a fantastic day!
Видео Goal Seek In Excel (Working Backwards From An Answer) канала JasonMorrell
When an Excel formula uses two or more input cells to generate its answer, it can be time-consuming to tweak the values to arrive at the exact answer you require.
GOAL SEEK solves this problem by allowing you to set the final answer to whatever you want, then asking Excel to work out (reverse engineer) what the input value needs to be to arrive at that answer.
In this video I build a PMT function (and explain how that works best) then walk you through the GOAL SEEK process. You will discover ...
- how to set up your data
- 3 different ways to use the Goal Seek tool
- a simple but complete demonstration of the PMT function
Lots of useful tips along the way.
😃 TIME CODES (click the link to go directly to that spot in the video)
- (0:00) Intro to Goal Seek
- (0:22) My PMT Goal Seek example data
- (2:54) Why use Goal Seek?
- (3:24) Where to find the Goal Seek tool.
- (3:33) Example 1: How much more could you borrow if you paid back more each month?
- (4:07) Example 2: What is the highest interest rate you could afford to repay if your payment amounts were higher?
- (4:30) Example 3: How much would the higher repayment reduce the length of your loan?
- (5:02) Summary and wrap up
I trust you found this video useful. What ONE thing resonated with you the most? Let me know by adding a quick comment below and click the thumbs up button under the video! Oh, and subscribe if you'd like to see more like this.
😃 USEFUL LINKS:
Share this Video:
https://www.youtube.com/watch?v=He_ob8ydc9E&t=0s
😃 SUBSCRIBE if you want to see more content like this
https://www.youtube.com/c/JasonMorrell?sub_confirmation=1
😃 HIRE JASON to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching
https://trst.com.au/microsoft-troubleshooter/?ref=yt
😃 ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.
😃 LET'S CONNECT!
https://officemastery.com (free training on the blog)
https://facebook.com/officemastery
https://linkedin.com/in/jkmorrell
https://youtube.com/JasonMorrell
Have a fantastic day!
Видео Goal Seek In Excel (Working Backwards From An Answer) канала JasonMorrell
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use IF, AND and OR in Excel (it's easier than you think)XLOOKUP Express TourHow To Use Flash Fill in Excel To Generate Any List Super QuickEp12: Dual Synchronised Multilevel Lists in WordHow to calculate squared numbers in Excel (plus square root, cubes and powers)Perfect VLOOKUP Formula in Excel (with examples)BODMAS Order Of Operations (You Must Know This)Combo Charts in ExcelThe AND function and OR function in Excel formulas (with examples)Charts & Graphs In Excel (And How To Make Them Look Fantastic)Beginners Excel Tutorial (The Basic Maths You Absolutely Need)3D Formulas In Excel (a.k.a. Cross Sheet Calculations)How Pros Use PowerPoint Presenter View For Full ControlTransposing Data In Excel (Paste Special and Transpose Function)Funnel Charts in ExcelHow To Protect Excel Workbooks, Worksheets & Cells (Complete Rundown)How to write a COUNTIFS formula (with examples)Excel IF Functions For BeginnersHow To Create An Excel Conditional Formatting FormulaBeginners Excel Formulas – AVERAGE, MAX, MIN and COUNT