Spreadsheet Using Tools

Having developed a spreadsheet model, there is often little time left to use it.

These tools enable you to quickly run sensitivity analyses and produce sensitivity reports, compare two different versions of a spreadsheet and produce a series of quick reports on the model.

The sensitivity and breakeven analysis tool

This tool enables you to quickly produce and report sensitivity and breakeven analyses for any cell within the spreadsheet.  The sensitivity analysis enables you to select a range to vary any input cell and see the impact on any other cell within the spreadsheet.  The breakeven analysis enables you to see what value the input cell has to be so that the other cell has a value of zero (or any other value that you are trying to achieve).  This is particularly useful when you are trying to establish answer such questions as "How far can revenues drop before we stop making a profit".

Using this tool it is possible to run many analyses very quickly and produce answers and reports for discussion.

The sensitivity and breakeven tool

By pressing the document button at the top left hand corner of the sensitivity tool, a report of the results can be quickly created.

A typical sensitivity report

The Spreadsheet Comparison tool

Very often you will want to compare two different spreadsheets, two versions of the same spreadsheet or even two runs of the same spreadsheet.  This tool enables you to perform these comparisons and produces a table showing the differences.

The tool enables you to select whether you want to see the differences in the inputs, the formulas or the results of the spreadsheet.

[ Home ] [ Product description ] [ Free download ] [ Purchase product ] [ Sarbanes Oxley ] [ FAQS ] [ Support ] [ About us ] [ Free Download ] [ Contact us ]