 |
Allen Computing and Business Analysis
|
Page Content
Related Pages
ACBA Audit Resources and Software Tools
This resources listing carries MS Excel products only. It is divided into four sections. For tools designed to help you create your own templates go to ACBA Oddments.
- Audit Functions and Tools
- Templates (primarily for use with the ACBA Electronic Working Papers package)
- Project Resource & Scheduling Control Kit
- Seminars and Presentations
Audit Functions and Tools
- ACBA Electronic Working Papers (ACBA EWP) is an audit project management and control tool. Its strength lies in the ease with which audit issues arising any where within a project can be linked to develop a comprehensive opinion about the control of business risks.
- The ACBA Random Sampling function can be downloaded free as a single user copy.
- Spreadsheet audit tools. A wide range of tools and worksheet functions for Excel developers, analysts and auditors.
Templates
Downloadable files carrying templates which are designed to use with the ACBA Electronic Working Papers package but may be employed generally. You can see these templates in action within one of the company's Exhibition Workbooks.
| Description of General Contents | Detailed Listing of Templates |
| Arithmetic and Analysis |
|
| Styles and Presentation |
|
Project Resource & Scheduling Control Kit
A simple, user friendly workbook, with instructions, for resource planning, scheduling and control of small projects. It allows an MS Excel workbook effectively to have multi-user functionality and gives project managers/team leaders instant access to up to date information on the progress of their project.
Seminars, Presentations and Published Articles
The slide presentations which accompanied seminars given by Stephen Allen to UK professional groups can be downloaded from here. This listing also includes copies of articles published on audit related topics.
| Group | Date and Place/Publication | Seminar Title or Article |
| IIA-UK (Eastern Region) | 19 Sept 2003, Ipswich | Analytical Aspects of Audit |
| CIPFA in the Midlands | 22 Oct 2003, Coventry | Electronic Working Papers (for Audit) |
| Institute of Revenues, Rating and Valuation | February 2008, Benefit Magazine | Certificated Conflict |
| Excel DevCon 2012 | 25 January 2012, Barbican, London | "Controlled Statements" within ACBA Electronic Working Papers |
| EuSpRIG 2012 | 5 - 6th July 2012, EuSpRIG 13th Annual Conference, Manchester. ISBN 978-0-9569258-6-2 | On the Interpretation of Spreadsheets within their Environment |
EuSpRIG, the European Spreadsheet Risk Interest Group, holds an annual conference (usually in early July) to which both academics and interested people from the business community are invited. The next conference will be held at the University of Greenwich, 4 - 5 July 2013.