Home
Up

The Excel Auditor   

Audit map Understand the structure of worksheets. Cells are marked by what they contain, all ranges are highlighted, and the output can include a comprehensive list of range names.
Bars and Buttons Manage your toolbars. Edit tooltips with the tooltip editor, and edit button images.
Cell Analyzer Know how your formulas are linked to other cells on the same sheet, other sheets, and other files
Cell Roots Generate lists of a precedents or dependent cells.
Circular References Trace circular references in your current workbook, and where circular references exist between open workbooks.
DocIt Essential data for your permanent file.
Dynamic Object Properties Control objects, such as graphs. Manage their positions.
Lister Ordered lists of essential data about your work, including sheet names and range names.Sort your lists alphabetically before you paste them. Shift your sheets to new locations within a workbook, or sort them by type.
Options Know what is behind a worksheet by unhiding scrollbars, worksheet tabs, gridlines and many more.
Search Probably the best Excel search engine available. Originally developed in response to the Year 2000 issue as a way for users, support personnel and developers to check for the use of date formulas and formats in their work, plus an assortment of cell formats.
Zoom Focus on important areas of a worksheet by interactively adjusting the zoom setting and seeing the effect as you make the changes.
   
  View the documentation - click on the link below
  The Excel Auditor's documentation

Today most businesses rely on reports or information produced by personal computing applications based on Microsoft's Excel. As a tool it's a very handy product, sometimes described as the Swiss Army Knife of business. Because of its adaptability it has found its way into all corners of business life. But like all tools it has to be used properly, and if it's not, then your business could be at risk.

 

Take a look at these questions:
  • How significant are your spreadsheet applications?
  • Are the results relied on for business decisions?
  • What disruption would occur if they were unavailable for any reason?
  • Do you regard them as a business system, or as an extension of an existing system?
  • Do measures for replacing them, within an acceptable time-scale, exist?
  • Do other areas use the results?
  • Are they carried out on a regular basis?
  • If present, would undiscovered errors lead to financial loss, embarrassment or incorrect decisions?
You probably found that quite a few applied to you. So, apart from your own expertise, how can you exercise more control over Excel?
The Excel Auditor can help you control, audit and document your Excel workbooks. It's not a substitute for the care and attention you and your colleagues put into the original construction, but it can give you the edge on keeping them under control.
 

Due to a technical issue this product has been withdrawn.

We hope to make it re-available in the near future.

 

Microsoft make Excel.

The Excel Auditor makes Excel excellent.

Last amended: 01 March 2011 at 21:57