Excel Examples
Some demonstrations of some Excel techniques
by Daniel Brockman
Sensitivity Analysis
Use sensitivity analysis to identify which variables "drive"
a complex model and to validate the usefulness of the model
under a wide range of conditions. I extracted this example
from some work I did for a health care startup in 2003.
Click here.
Pivot Table
Pivot tables can provide cross-sectional views of data.
Look at the various worksheets in this hypothetical
example of ice cream shop sales.
Click here.
Loan Calculator
By replacing one loan with another, a borrower can obtain
a lower periodic payment, or a larger loan with the same
periodic payment. Lenders have corresponding opportunities
in the management of their assets. This spreadsheet compares
two hypothetical loans and calculates their differences.
Click here.
Miscellaneous Techniques
This spreadsheet demonstrates several Excel techniques and
statistical computations.
Click here.
Up
| Software Examples
| Dan's Resume
| Contact Dan