You’ll find it under the Formulas tab, in the Formula Auditing group. Once you open it, just hit Add Watch and select the cells you want to monitor. The pop-up will show you the sheet name, cell ...

TL;DR Key Takeaways : Excel’s “ What-If Analysis ” tools, including Goal Seek and Scenario Manager, simplify financial decision-making by automating calculations and analyzing various scenarios.

In Excel, three primary tools are available for performing What-If Analysis: Scenarios, Goal Seek, and Data Table. To recap the last couple of months, here are brief definitions of Scenarios and Goal ...