A WORLD OF KNOWLEDGE. A NEW HORIZON.info@smarthorizon.uk
Auditing and Governance Risk and Compliance

Audit Sampling and Data Analytics with Excel

Auditors increasingly use data analytics and statistical sampling to improve audit quality and efficiency. This course covers sampling methods, sample size determination, evaluating results, and using Excel for data analysis, testing full populations, duplicates, gaps and anomalies.

5 days Classroom or live online English
Smart Horizon Certified - Global Leadership Consultants
Take the course details with you.

Download the full standard outline: why attend, methodology, objectives, audience, competencies, the daily outline and current plans.

Download course PDF
Why attend

From knowledge to real-world impact.

Analytics allow auditors to test more with less effort. This course gives practical skills using a tool every auditor has.

Workplace challenges

Professional Problems This Course Is Designed to Solve

The programme explores practical approaches to the following challenges. Results depend on how the learning is applied in your organisation.

  • Difficulty translating subject knowledge into practical workplace decisions.
  • Inconsistent approaches to the activities covered in the course outline.
  • Lack of a structured plan for applying and reviewing new skills.
Course methodology

How you will learn.

The course is hands-on with Excel exercises on audit datasets, sampling calculations and case studies.

Course objectives

What you'll take away.

By the end of this course, participants will be able to:

  • Explain statistical and non-statistical sampling
  • Determine sample sizes and select samples
  • Evaluate and project sample results
  • Prepare and clean audit data in Excel
  • Perform analytics tests on full populations
  • Document analytics work properly
Target audience

Who should attend.

This course is suitable for:

  • Internal auditors
  • External auditors
  • Compliance testers
  • Risk analysts
  • Finance controllers
Target competencies

Capabilities you will build.

Participants will develop competencies in:

  • Audit sampling
  • Sample evaluation
  • Data preparation
  • Excel analytics
  • Anomaly detection
  • Audit documentation
Course outline

Your learning journey.

A focused, practical outline with time to explore, apply and reflect.

Day 1Sampling Fundamentals

  1. 09:00–09:54Purpose of sampling
  2. 09:54–10:48Sampling risk
  3. 10:48–11:00Statistical and non-statistical methods
  4. 11:00–11:30Coffee break
  5. 11:30–12:12Statistical and non-statistical methods (continued)
  6. 12:12–13:06Attribute sampling
  7. 13:06–14:00Exercise: Sampling design

Day 2Sample Selection and Evaluation

  1. 09:00–09:54Sample size
  2. 09:54–10:48Selection methods
  3. 10:48–11:00Evaluating errors
  4. 11:00–11:30Coffee break
  5. 11:30–12:12Evaluating errors (continued)
  6. 12:12–13:06Projecting results
  7. 13:06–14:00Lab: Sampling in Excel

Day 3Data Preparation

  1. 09:00–09:54Data requests
  2. 09:54–10:48Importing and cleaning
  3. 10:48–11:00Validation
  4. 11:00–11:30Coffee break
  5. 11:30–12:12Validation (continued)
  6. 12:12–13:06Power Query basics
  7. 13:06–14:00Lab: Preparing data

Day 4Analytics Tests

  1. 09:00–09:54Duplicates and gaps
  2. 09:54–10:48Stratification
  3. 10:48–11:00Benford's law
  4. 11:00–11:30Coffee break
  5. 11:30–12:12Benford's law (continued)
  6. 12:12–13:06Pivot analysis
  7. 13:06–14:00Lab: Audit analytics

Day 5Documentation and Use

  1. 09:00–09:54Documenting analytics
  2. 09:54–10:48Interpreting results
  3. 10:48–11:00Integrating into audits
  4. 11:00–11:30Coffee break
  5. 11:30–12:12Integrating into audits (continued)
  6. 12:12–13:06Next steps
  7. 13:06–14:00Capstone: Analytics audit

The timings provided are estimates and may vary depending on the number of participants and the discussions taking place during the sessions. They are indicative only and do not constitute a binding commitment.

Dates & venues

Find a session that works for you.

Confirmed dates accept registration requests. Tentative dates are enquiry only.

Dubai 16 Nov - 20 Nov 2026
Confirmed dates
£3,150.-Register
Online Live virtual classroom 16 Nov - 20 Nov 2026
Confirmed dates
£1,250.-Register
Cape Town 23 Nov - 27 Nov 2026
Confirmed dates
£1,890.-Register
Online Live virtual classroom 23 Nov - 27 Nov 2026
Confirmed dates
£1,250.-Register
Frankfurt 7 Dec - 11 Dec 2026
Confirmed dates
£2,650.-Register
Online Live virtual classroom 7 Dec - 11 Dec 2026
Confirmed dates
£1,250.-Register
Kuala Lumpur 14 Dec - 18 Dec 2026
Confirmed dates
£1,450.-Register
Online Live virtual classroom 14 Dec - 18 Dec 2026
Confirmed dates
£1,250.-Register
Paris 4 Jan - 8 Jan 2027
Confirmed dates
£2,860.-Register
Online Live virtual classroom 4 Jan - 8 Jan 2027
Confirmed dates
£1,250.-Register
Istanbul 18 Jan - 22 Jan 2027
Confirmed dates
£2,650.-Register
Online Live virtual classroom 18 Jan - 22 Jan 2027
Confirmed dates
£1,250.-Register
Amsterdam 1 Feb - 5 Feb 2027
Confirmed dates
£2,540.-Register
Online Live virtual classroom 1 Feb - 5 Feb 2027
Confirmed dates
£1,250.-Register
Singapore 15 Feb - 19 Feb 2027
Confirmed dates
£2,820.-Register
Online Live virtual classroom 15 Feb - 19 Feb 2027
Confirmed dates
£1,250.-Register
Cape Town 22 Feb - 26 Feb 2027
Confirmed dates
£1,890.-Register
Online Live virtual classroom 22 Feb - 26 Feb 2027
Confirmed dates
£1,250.-Register
London 1 Mar - 5 Mar 2027
Confirmed dates
£2,450.-Register
Online Live virtual classroom 1 Mar - 5 Mar 2027
Confirmed dates
£1,250.-Register
Dubai 15 Mar - 19 Mar 2027
Confirmed dates
£3,150.-Register
Online Live virtual classroom 15 Mar - 19 Mar 2027
Confirmed dates
£1,250.-Register
Frankfurt 5 Apr - 9 Apr 2027
Confirmed dates
£2,650.-Register
Online Live virtual classroom 5 Apr - 9 Apr 2027
Confirmed dates
£1,250.-Register
Kuala Lumpur 19 Apr - 23 Apr 2027
Confirmed dates
£1,450.-Register
Online Live virtual classroom 19 Apr - 23 Apr 2027
Confirmed dates
£1,250.-Register
Barcelona 26 Apr - 30 Apr 2027
Confirmed dates
£2,840.-Register
Online Live virtual classroom 26 Apr - 30 Apr 2027
Confirmed dates
£1,250.-Register
Paris 3 May - 7 May 2027
Confirmed dates
£2,860.-Register
Online Live virtual classroom 3 May - 7 May 2027
Confirmed dates
£1,250.-Register
Istanbul 17 May - 21 May 2027
Confirmed dates
£2,650.-Register
Online Live virtual classroom 17 May - 21 May 2027
Confirmed dates
£1,250.-Register
Amsterdam 7 Jun - 11 Jun 2027
Confirmed dates
£2,540.-Register
Online Live virtual classroom 7 Jun - 11 Jun 2027
Confirmed dates
£1,250.-Register
Rome 14 Jun - 18 Jun 2027
Confirmed dates
£2,450.-Register
Online Live virtual classroom 14 Jun - 18 Jun 2027
Confirmed dates
£1,250.-Register
Singapore 21 Jun - 25 Jun 2027
Confirmed dates
£2,820.-Register
Online Live virtual classroom 21 Jun - 25 Jun 2027
Confirmed dates
£1,250.-Register
London 5 Jul - 9 Jul 2027
Confirmed dates
£2,450.-Register
Online Live virtual classroom 5 Jul - 9 Jul 2027
Confirmed dates
£1,250.-Register
Dubai 19 Jul - 23 Jul 2027
Confirmed dates
£3,150.-Register
Online Live virtual classroom 19 Jul - 23 Jul 2027
Confirmed dates
£1,250.-Register
Frankfurt 2 Aug - 6 Aug 2027
Confirmed dates
£2,650.-Register
Online Live virtual classroom 2 Aug - 6 Aug 2027
Confirmed dates
£1,250.-Register
Kuala Lumpur 16 Aug - 20 Aug 2027
Confirmed dates
£1,450.-Register
Online Live virtual classroom 16 Aug - 20 Aug 2027
Confirmed dates
£1,250.-Register
Rome 23 Aug - 27 Aug 2027
Confirmed dates
£2,450.-Register
Online Live virtual classroom 23 Aug - 27 Aug 2027
Confirmed dates
£1,250.-Register
Paris 6 Sept - 10 Sept 2027
Confirmed dates
£2,860.-Register
Online Live virtual classroom 6 Sept - 10 Sept 2027
Confirmed dates
£1,250.-Register
Istanbul 20 Sept - 24 Sept 2027
Confirmed dates
£2,650.-Register
Online Live virtual classroom 20 Sept - 24 Sept 2027
Confirmed dates
£1,250.-Register
Amsterdam 4 Oct - 8 Oct 2027
Confirmed dates
£2,540.-Register
Online Live virtual classroom 4 Oct - 8 Oct 2027
Confirmed dates
£1,250.-Register
Singapore 18 Oct - 22 Oct 2027
Confirmed dates
£2,820.-Register
Online Live virtual classroom 18 Oct - 22 Oct 2027
Confirmed dates
£1,250.-Register
Vienna 25 Oct - 29 Oct 2027
Confirmed dates
£2,940.-Register
Online Live virtual classroom 25 Oct - 29 Oct 2027
Confirmed dates
£1,250.-Register
London 1 Nov - 5 Nov 2027
Confirmed dates
£2,450.-Register
Online Live virtual classroom 1 Nov - 5 Nov 2027
Confirmed dates
£1,250.-Register
Dubai 15 Nov - 19 Nov 2027
Confirmed dates
£3,150.-Register
Online Live virtual classroom 15 Nov - 19 Nov 2027
Confirmed dates
£1,250.-Register
Frankfurt 6 Dec - 10 Dec 2027
Confirmed dates
£2,650.-Register
Online Live virtual classroom 6 Dec - 10 Dec 2027
Confirmed dates
£1,250.-Register
Kuala Lumpur 13 Dec - 17 Dec 2027
Confirmed dates
£1,450.-Register
Online Live virtual classroom 13 Dec - 17 Dec 2027
Confirmed dates
£1,250.-Register

Good to know

A few things to know.

How is the course delivered?

Our classroom programmes combine facilitated discussion, case studies, exercises and reflection. The precise format will be confirmed before enrolment.

Can you deliver this programme for our team?

Yes, you can enquire about a tailored programme. Share your goals, group size and preferred dates with our learning team.

Will I receive a certificate?

Participants who complete the programme receive a Smart Horizon UK certificate of attendance. Smart Horizon UK programmes are not externally accredited and do not award a professional qualification, licence or designation. Where a course title or outline refers to a professional certification (for example, AACE International's Certified Cost Professional), the programme supports learning and preparation only; the credential itself is awarded solely by the relevant professional body under its own application and examination requirements.

What should I confirm before booking travel?

Please confirm the session, exact venue, accessibility arrangements, fees and any visa requirements with the team before arranging travel. Tentative dates are not confirmed sessions.

Keep exploring

Your next horizon awaits.

All courses
Your next chapter starts here

Enquire about this course.

Send your selected programme and session to our learning team.

Your email app opens a draft. Nothing is sent until you send that email; no booking is created.