eBook: Data Analysis with ActiveData

Digital testing for innovative auditors.

Can digital auditing techniques be simple, understandable and easy to implement? Auditors are increasingly confronted with high expectations when analyzing business information. ActiveData for Excel is an uncomplicated, powerful and cost-effective MS Excel tool, with which this manual conveys the practical application of digital analysis of financial information.

The manual shows how source files can be transferred to ActiveData. The authors then explain alternative testing techniques in detail and with numerous examples.

  • Function-related testing: Comprehensive representations and examples show how typical analysis commands can be used to get valuable insights in different test fields.
  • Analysis of structures and groups
  • Key figures and their evaluation: Tests presented here equally support process reviews, balance sheet audits and / or the elucidation of fraud risks.
  • Rule-based testing techniques
  • As business processes are subject to rules the reader learns how to identify rule deviations with the help of suitable tests.
  • Pattern-based testing
  • The recognition of patterns within business data and resulting abnormalities
  • Introduction in contingency analyzes as they are gaining in importance with regard to mass data and their visualization
  • Sampling (Random-based selection procedures). The quality of auditor assessments is based, among other things, on individual evidence using sampling. The authors guide you through all relevant procedures step-by-step

In addition to the methodological instructions, the numerous practical analysis examples, including those on “Journal Entry Testing” (JET) or process-related SAP tests, can be directly integrated into everyday testing. Readers receive both a current insight into the state of analysis techniques as well as a manual and exercise book for analyzing.


Self Study Course - Auditing, Fraud Detection and Cash Recovery using ActiveData

The purpose of this course is to assist auditors, fraud examiners, and management in implementing audit data analysis routines, and fraud detection and cash recovery techniques using ActiveData For Microsoft Excel.

For accountants and auditors, Microsoft Excel provides a comfortable environment to work within and for many data analysis tasks, Excel can easily do the job. However when more complex data analysis and manipulation is needed, as is the case with fraud detection and cash recovery, more complex tools and techniques are needed. This is where the combination of Excel and ActiveData creates dramatic results.

This course will:

  • Introduce you to the powerful combination of ActiveData and Excel
  • Walk you through basic audit, fraud detection and cash recovery reporting concepts
  • Map out each step for the most common of fraud detection, cash recovery and audit tests
  • Equip you with sample data, providing a glimpse of the resulting report prior to the (crunch time) situation
  • Suggest audit procedures and fraud detection to perform on the resulting reports

This course will give you all the information you need to produce fraud detection, cash recovery and audit reports immediately for the most common accounting areas: accounts payable, accounts receivable, and the general ledger. To help practice the concepts, sample data are also provided, giving you an immediate "hands on" experience


Please note that these materials require Adobe PDF Reader Version 6 or better and ActiveData Professional Edition Version 5.0 or later.

To determine your version of the Adobe PDF Reader, select Help -> About from your reader. To get the latest version of the free reader, click on the button at right.

To determine your version of ActiveData, use ActiveData -> Help -> About.


Some of our users include: