Khyati has attended:
Excel Intermediate course
Time Management course
Microsoft Excel
How do i use Goel Seek and Scenario options?
RE: Microsoft Excel
Hi Kyati
Thank you for your question
Goal seek is a tool that allows you to alter the value of a result cell in a formula to a specific value, by manipulating one of the input cells.
Click on Tools-Goal Seek
Enter the cell to be changed, the value it is to be changed to, and the cell to be manipluated and click OK
The scenario manager is a tools for creating multiple scenarios in a single workbook. To use click on Tools-Scenarios and then click Add to add a new scenarion
Enter the scenario's name
Identify the cells to be changed
Then click OK
You can then enter the new cell values
Then repeat the above for each new scenario
Hop this is useful
Regards
Stephen