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

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

This guide will walk you through the three primary what-if analysis tools in Excel: Scenarios, Goal Seek, and Data Tables, along with additional tools like the Solver add-in. Scenarios ...