Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

Launch Excel. Create a loan table with Loan Amount, Interest Rate, Term in months, and Monthly Payment. Use the PMT function to calculate the Monthly Payment Now, we will use Goal Seek.

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals.

This month’s column shows how to use Excel’s Goal Seek for data analysis.

Learn how to use Excel’s What-If Analysis tools, including Goal Seek and Scenario Manager, to explore different scenarios and outcomes based on variable data inputs.

Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...

What do you think so far? Post a comment. Excel Goal Seek Tutorial - Learn how to use goal seek feature by building a retirement calculator in Excel [Pointy Haired Dilbert: Charting & Excel Tips] ...

Last month’s article showed you how to use Goal Seek, a what-if analysis tool that tells you how input values must change to achieve a specific goal.

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals.