Click the Data tab, click What-If Analysis, and then choose Goal Seek. In Excel 2003, choose Goal Seek from the Tools menu. In the resulting dialog, enter 50000 as the To value.

The Analysis ToolPak add-in provides tools for regression analysis, which can help in extending complex and nonlinear data. Use the Solver add-in to find optimal values for formulas involving ...

In the Data Tools group, click the What-if Analysis drop-down and choose Scenario Manager (Figure B). Figure B Click Add and give the scenario a name, such as BestCase ( Figure C ), and click OK.

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. Key Takeaways Open Excel and ...

Just as Excel can perform basic data analysis functions, it has a surprising number of data visualization tools under the hood. “Excel isn’t explicitly a data visualization tool, it’s a ...