 |
Training Index
Running
Sensitivities and What If Analysis in Excel
|
|
|
Learn how to use Excel to run various scenario's, what
ifs and sensitivities using the built in tools. Use these
tools to see the break even position, consider what will happen when
some of your inputs change and assess the impact that certain
variables have on your spreadsheet model. Be aware that these video clips use Windows Media Player. Click on the
hyperlink and, depending on your connection speed, you may need to wait a
few moments.
|
| Title |
Price
|
Video
Clip
(Windows Media Player) |
Goalseek
The Goalseek feature allows you to specify the result you require
and which input can change. Then the computer will calculate the
required number. Very useful for break even analysis. This clip also
shows you how to perform a goalseek straight off a graph. |
FREE
|
|
 |
Data Tables
Learn how to use Excel's Data Tables feature to automatically run
multiple scenarios through a model, based on either one or two
variables. |
FREE
|
|
|
Multiple Scenarios
The scenario feature allows you to quickly change a number of input
cells based on some pre defined situations e.g. Low case, High Case,
Realistic Case. You can then switch between the various scenarios. |
FREE
|
|
|
The Watch Window
The watch window allows you to continuously view cells that interest
you (no matter where they are on the spreadsheet) while making changes
to inputs in the model. |
FREE
|
(3 min) |
|
|
Quote of the page:
No sensible decision can be made any longer without taking into
account not only the world as it is, but the world as it will be-
Isaac Asimov (science fiction writer)
|
|
|
Visit our
training page for a full list of the
training available on the site. |
Do you like what you see. Tell your friends. If you have a
training coordinator
at your organisation tell them that there is free excel training available
at this site.
Don't like what you see. Tell us at
training@AuditExcel.co.za .
Do you have suggestions of what you would like to see. Tell us at
training@AuditExcel.co.za .
|
