You are currently browsing the Audit Commander weblog archives for June, 2007.
June 29, 2007 by Mike.Blakley.
I have established a web page devoted to sharing articles and ideas on IT auditing. Part of it consists of tutorial modules as shown below. Some are VBA classes for use within Excel, others pertain to use of the XL Audit Commander.
| General Audit Topics | ||||
| Module | Description | Approx Length | With Quiz? | Last Update |
|---|---|---|---|---|
| Module-1 | Obtaining Basic Population Statistics | 15 minutes | Yes | 06-22-2007 |
| Module-2 | Audit uses for Benford’s Law | 15 minutes | Yes | 06-22-2007 |
| Module-3 | Use of histograms in audits | 15 minutes | Yes | 06-23-2007 |
| Module-4 | SQLite as an Audit Tool | 30 min | No | 06-29-07 |
| Module | Description | Approx Length | With Quiz? | Last Update |
| Module-5 | Beyond the COUNTIF and SUMIF functions | 20 min | No | 06-25-07 |
| Module-6 | A work-around for very large files | 20 min | No | 06-29-07 |
| Module-7 | Identifying duplicates and gaps in large files | 20 min | No | 06-29-07 |
| Module-8 | Sizing up the population - Going to Extremes | 20 min | No | 06-29-07 |
Posted in Data Extraction, Data Classification, Audit Software, Data Validation | No Comments »
June 3, 2007 by Mike.Blakley.
XL Audit Commander provides a variety of audit tools which can be run from within Excel, all at no cost. An operation guide explains the commands available and the procedures to perform them.The software uses a very minimal portion of your spreadsheet area and can easily be invoked only when needed by pressing Control-E. Download the software to try. Also included is the capability to perform a variety of data extracts for audit tests, and examples are included in a sample workbook for download.
These include such tests as searching for close matches on names, data extraction using conditions, etc. More details.
Posted in Audit Software | No Comments »