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. 


Hayley Elson BCom, CA, PMIIA



Topics Explored

Internal Audit


White Paper


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


Level of Assumed Knowledge