Question: what is the difference between solver and other what-if analysis tools?
Answer: What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables. ... The Solver add-in is similar to Goal Seek, but it can accommodate more variables.