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.

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

Annotations & Named Ranges

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

Annotations & Named Ranges

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

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.

Compare

Miscellaneous Utilities and Notes

Take data snapshots, easily navigate, protect multiple sheets, detect fraud, and many others.

Miscellaneous Utilities