Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel

ResolvedVersion 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

Excel tip:

Add a € to your cells

If you need to add a € symbol to your Excel sheet - hold down the key Alt Gr and 4.

Alt Gr is located on the right side of the space bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.