Internal audit analytics – data & visualisation

Presented By
Stan Dormer CFIIA Stan is a recognised expert in the field of governance, auditing, business and project risk and IT. He is the author of numerous articles and was the author of the distance learning materials and revision schools supporting IIA qualifications.

The Digital World and Big Data is forcing internal auditors to rethink their approach to data and get ‘hands-on’. This course takes you on a rapid tour of how to get the most out of the software available to most auditors. You’ll learn tips and tricks to speed up your work, particularly in the controls testing and reporting phases of an audit.

Who should attend?

This course is open to all.

NOTE: This is a 'hands-on' course and each delegate must bring a laptop to the course with an installed copy of Microsoft Office version 2010 or later. They will also need an ability to install two other software elements if they wish to explore all the hands-on content supported by the course. Each delegate must also ensure that they are authorised and able to copy working data (comprising example Excel, PDF, TXT and Access files from a provided DVD, or from a memory stick, or from a pre-supplied email attachment) and are able to access, at least, the standard features of a standard installation of Microsoft Excel. The use of a mouse is recommended for some exercises as some features within Microsoft Office are impossible to access via a touchpad. Delegates who arrive on course without these defined capabilities will either not be able to proceed or will only be able to enjoy partial course content.

What will I learn?

Upon completion you will be able to:

  • check up to 100% of the data available to you electronically;
  • put vital components of Office to work in the most efficient manner; and
  • manage and manipulate data to create persuasive results.

The course is accompanied by a manual that has course text and a DVD of practice data to take away.

Course programme

Data analytics and handling - working directly with Excel

  • checking spreadsheet integrity – common sources of error
  • re‐performance and virtual calculations – why do this?
  • excel statistics – what do you get out of the box?
  • filtering and stratification
  • simple and complex sortation
  • why test a sample when you could hit 100%?

Data analytics and handling – extras through Excel

  • fuzzy data matching
  • replicating what other tools can do

Data graphics – colour and imagery through Excel

  • conditional formatting
  • using colour, icons, and thematic schemes
  • creating charts that dazzle
  • embedding charts and images in your reports

Queries, Reports, Dashboards and Business Intelligence

  • data import from usual and unusual sources
  • the JET engine and finding MSQRY within your system
  • connecting with external data
  • creating a query from tables and fields and their interpretation
  • generating reports
  • polishing results
  • creating dashboards using free free-standing products that can interact with MS Office

Presented by

Mindgrove Ltd

CPE competency areas covered

  • improvement and innovation
  • critical thinking
  • business acumen

7 CPE points

Full price

Member: £625 + VAT
Non-member: £840 + VAT

SAVE £100 when you book this course 3 months in advance

All training courses are subject to our Fair Collection Notice and Privacy Policy

Internal audit analytics – data & visualisation

Duration: 1 day

25 February 2020


Start: 09:00
End: 17:00


Manchester venue TBC


Member price:
Non-member price:
Save !

IIA Members save per person - Join Us or Login above

Book your place
Book now to secure your place