Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - What if analysis
|
|
|
The UK's most regular 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 consultants - What if analysis
Resolved · Low Priority · Version Standard
Reply Mon 24 Sep 2007, 10:01Delegate Tamara said...
Tamara has attended:
Excel Intermediate course
Excel Introduction course
Excel Advanced course
What if analysis
How do I do this?
For upcoming training course dates see: Pricing & availability
RE: what if analysis
Hi Tamara,
For What-If Analysis, there are quite a few options:
1) Goal Seek
2) Scenarios
3) Solver
Depending on your requirements.
1) Goal Seek (Set a new target, let Excel work out the value to reach your target base on the formula)
a) Select your formula cell
b) Tools > Goal Seek
c) Confirm the result cell
d) Type in the new value
e) Key in the parameter cell.
2) Scenarios (Excel works out a new result with your input of a list of variables)
a) Tools > Scenarios
b) Add
c) Name Scenarios
d) define cells to be changed
e) Type in new Values
f) Either Show / Summarise on a new worksheet to see result
3) Solver (It finds an optimal value for a formula, your variables can be refined in a range)
*Must first switch on function in Tools>Add-Ins
a) Tools > Solver
b) Set Formula cell as target cell
c) Set it equal to your new value
d) Click Guess
e) add to insert new constrains
f) Click Solve to view changes
g) Either Keep new values or restore to original values
Hope this helps.
Katie
Hope this helps
Katie
|