These are a series of video tutorials that describe the key features of
the Spreadsheet Detective.
More detailed information can be found in the help spreadsheet that
is included with the Detective download.
Overview (Start Here)
This contains a brief overview of all the features of the Spreadsheet
Detective, including some newer features that may not yet be covered by
the other tutorials.
Troubleshooting Downloading And Installing (optional)
This tutorial covers details about how to download and install the
Spreadsheet Detective. Normally all that one needs to do is click on
the link provided in the email that we send you and follow the on
screen instructions. Feel free to skip this tutorial if the default
installation works for you.
Note that installing the Detective does NOT normally require system
administrator rights and can normally be performed by ordinary users
even in corporate networks.
Corporate IT people may also wish to read the technical supplement that
is included in the download.
And Installing (optional)
Shading and Mapping
This tutorial covers the shading and mapping features that show you
which cells have formulas and how they have been copied throughout a
spreadsheet. It included details such as the new bold shading features
that highlight non-isomorphic patterns. It also touches on the
Spreadsheet Detective's error tests.
Non Modal Dialog & Autonames
Understand what the formulas mean using the non-modal dialog or task
pane which remain active while you update your spreadsheet.
They provide AutoNames
that make it easy to understand what cryptic A1 references mean, as
well as providing hyper links for easy navigation.
Pink boxes show the extent of copied formulas, and the Detective can
automatically copy new formulas to maintain a consistent pattern.
Dialog & Autonames
The workbook report enables you to gain a birds eye view of complex
models. This includes understanding the high level data flow between
different parts of a model.
Compare Workbooks, Sheets and Ranges
These functions can be
used to see how a model has changed over time, or by different users of
a model. They may also be used to check its internal consistency of
repetitive parts of a model.
Review Process Control
The Spreadsheet Detective can help you
track a formal review. Issues can be graphically shown on worksheets,
and then consolotated into a report.
Scenarios and Monte Carlo Simulation
Most models involve uncertain inputs and assumptions. The
Scenario manager enables different scenarios to be easily compared
based largely on Excel formulas. Scenarios can also be
automatically generated by combining given values or using Monte Carlo
methods with random numbers. Reviewing a model under different
input values can find many errors, as well as avoiding the flaw of
Scenarios and Monte Carlo
Annotations & Named Ranges
This tutorial shows some advanced views of the formulas. These provide
techniques to tame Named Ranges
& Named Ranges
Shortcuts and Navigation
Some handy keyboard shortcuts and navigation tools.
Shortcuts & Navigation
Miscellaneous Utilities and Notes
Sensitivity report, Copy data snapshots, discover models in a file
system, encrypt workbooks using a master password, use the worksheet
pane, detect fraud, and protect multiple sheets..