About this document
Excel What-If Analysis Tools Guide by Reagan Ssebbaale is a document available to read on EtoBox.
The document discusses three tools in MS Excel for what-if analysis: Scenario Manager, Goal Seek, and Solver. Scenario Manager allows users to create and switch between different sets of input values to view their effects on model results. Goal Seek varies an input cell value until a formula returns the desired output value. Solver is more powerful than Goal Seek by allowing constraints and finding the optimal values for multiple changing cells to maximize or minimize an output cell.
- Author
- Reagan Ssebbaale
- Language
- EN