98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel
Microsoft Excel
Resolved · Low Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Recently used file listUnder the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files. |