IIA-Australia White Paper - Data Mining Using Excel

IIA-Australia White Paper - Data Mining Using Excel

This is a members only resource. Please login to access. 

Author

Hayley Elson BCom, CA, PMIIA

Date

 2023

Topics Explored

Internal Audit

Format

White Paper

Extract/Description

Data mining does not have to be a complicated audit test, and it does not require specialist software. Programs such as Microsoft Excel can provide an efficient way of analysing large amounts of data.

Key Points

  1. Data mining benefits include productivity and cost savings, efficiency in data access, and reduced audit risk.
  2. Techniques such as Filtering, Sorting and Pivot Tables can be useful in reviewing large populations of financial balances such as debtors, creditors, payroll or other expenses. 
  3. Data mining can allow the auditor to identify  trends in  records.

Relevant Industries

All

Level of Assumed Knowledge

Intermediate