White Paper - Data Mining Using Excel

Whitepaper

This is a members only resource.

Please login to access.

Author

Hayley Elson

BCom, CA (Risk Specialist), PFIIA

Date

2025 version coming soon

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

Aligned to Global Internal Audit Standards

Yes