Click Here to Drop Your Doubts
Summary: In this class, Jaywant Sir will be explaining What if analysis (Solver) Function.
Process: To enable Solver Function, click on the file menu, click on more, click on options, in the excel options dialogue box, click on add-ins, click on manage, click on excel add-ins, click on go, in the add-ins dialogue box, click on the solver, click on okay. Solver Function is now enabled.
Select target data, click on the data tab, go to analyze section, click on solver, in solver parameters dialogue box, fill in the details as required, click on solve, in solve results dialogue box, click on okay.
What-if analysis tool that finds the optimal value of a target cell by changing values in cells used to calculate the target cell.
Conclusion: After completion of this class you will be able to do What-if analysis (Solver) Function.
