1.1 Welcome: Your Analytics Toolkit (Start Here)

Audit data analytics means using software to test whole populations of transactions, rather than a small sample, to find the items that need an auditor’s attention. A payables file of 100,000 invoices cannot be read by a person; a well-designed test can read it in seconds and return the dozen invoices that look like duplicate payments.

This course is part of the EunoiaData Professional Toolkits series. Its point of difference is simple: a ready-made library of audit tests you can run in Excel on standard ERP and payroll extracts, with no paid audit software. Every test is shown on a small worked data example, so you can see the data before and after.

What you leave with

Each module ends with a toolkit item, delivered as a table you can copy into Excel or Word and adapt:

Who this course is for

Internal auditors, accountants, finance and payroll managers, and risk and compliance staff. You should be comfortable with everyday Excel: entering formulas, sorting and filtering. Audit basics (evidence, working papers, reporting) are assumed; if you need them, start with our Internal Audit Fundamentals course. For deeper Excel skills, see Microsoft Excel Professional Formulas and Mastering Microsoft Excel Charts.

Frameworks used in this course

This course explains these frameworks in its own words. It uses their principles; it does not reproduce their text.

• IIA Global Internal Audit Standards (2024).
• COSO Internal Control – Integrated Framework (2013).
• ISA 520 Analytical Procedures and ISA 530 Audit Sampling (IAASB): the extant versions. Revisions are in progress: the IAASB released an exposure draft of a revised ISA 520 in August 2026, and ISA 530 is part of a wider modernisation project.
• Benford’s Law: a statistical method, not a framework.

Product names such as Microsoft Excel, SAP, Sage, Pastel, Microsoft Dynamics and Oracle are trademarks of their owners and are used for identification only; EunoiaData is not affiliated with or endorsed by any software vendor. Framework names belong to their issuing bodies; this course explains them in its own words and is not endorsed by them. The course does not prepare you for any certification exam.

How the Excel examples work

Every technique is taught in Microsoft 365 first, using dynamic arrays and functions such as XLOOKUP, FILTER, UNIQUE, COUNTIFS, LET and Power Query. Where an older version needs a different method, a short Excel 2016 note follows. Formulas appear inline in the text; you will not be quizzed on formula syntax. The quizzes test the audit logic: which test to run, why, and what a result means.

Data comes from ERP and payroll systems. Each lesson teaches the vendor-neutral extract first, then shows how this typically looks in an ERP such as SAP. Many African organisations run either SAP ECC (the older version) or S/4HANA (the newer one), and some table names differ, so always ask IT which one you run.

Practise as you go

Every worked data table in this course can be copied straight into Excel. Select the table on the lesson page, copy it, and paste it into cell A1 of a new sheet. A Practise it note under each table tells you which formula or Power Query step rebuilds the result, so you can check your work against the lesson. The toolkit tables in each x.4 lesson paste the same way, ready to adapt as your own templates.

The case company

About the case company: Kuvanya Group, its subsidiaries (Kuvanya Bank, KuvaTel, KuvaPay, Kuvanya Mining Supplies and Kuvanya Shared Services), its client “the Power Authority” and every person named in this course are fictional. They were created by EunoiaData for teaching purposes only. Any resemblance to real organisations or people is coincidental. Countries, laws and regulators are real and are described as they stood in 2026.

Kuvanya Group is a family-founded holding group of about 4,200 staff in Zimbabwe, Zambia, South Africa, Botswana, Kenya and Nigeria. It reports in US dollars while its subsidiaries also trade in local currencies, so its ledgers are mixed-currency. Kuvanya Shared Services in Harare runs one group ERP; Kenya and Nigeria run stand-alone payroll systems that upload CSV journals. Internal audit is a two-person team: Nomsa Dube, Head of Internal Audit, and Femi Adebayo, an analytics specialist working remotely from Lagos and an Excel power user who sometimes trusts the data too quickly.

How the three views work

Each teaching lesson closes with three short points:

• As the auditor: what to test and what the result means.
• As the manager: what the data owner must provide or fix, and how to run the test yourself as a control.
• As the board: what an audit committee member should ask about analytics results.

Analytics is not only for auditors. Many of these tests make excellent monthly management controls.

Example: Tendai Musarurwa, the Group CFO, asks why audit needs Excel tests when the external auditors already sample invoices. Femi explains that a sample of 40 invoices says little about the other 101,960. A duplicate-payment test reads all of them, and costs nothing but time and a clean extract.

Three views

• As the auditor: agree the population, period and data source of every test before you run it, and record them in the workbook.
• As the manager: treat audit tests as controls you can run yourself each month, before the auditor does.
• As the board: ask what share of each key population was tested by analytics, and what was found.

Check before you act: Framework editions and requirements here are as at October 2026 and are expected to change. The IAASB has proposed revisions to ISA 520 and is modernising ISA 530. Confirm the current edition with the issuing body (The IIA, COSO or the IAASB) before you rely on it.

Key takeaway

Audit analytics tests whole populations in Excel; this course gives you five tools and a library of tests, each shown on worked data, using Microsoft 365 first.