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 ...

Open Excel and navigate to the “Data” tab. Select “What-If Analysis” from the “Forecast” group. Choose “Goal Seek” to find the necessary input value to achieve a desired result.

Select “Data Analysis” from the Analysis group. If you don’t see it, you may need to add the Analysis ToolPak add-in. Choose “Regression” from the list of analysis tools and click “OK”.