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