Spreadsheet Detective Ribbon

Video Tutorials

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.

Overview Video

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.

Downloading 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.

Shading & Mapping

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.

Non Modal Dialog & Autonames

Workbook Report

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.

Workbook Report

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.

Review Process Control

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 averages.

Scenarios and Monte Carlo

Annotations & Named Ranges

This tutorial shows some advanced views of the formulas. These provide techniques to tame Named Ranges

Annotations & 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..

Miscellaneous Utilities