Internal audit analytics - data and visualisation
-
30 January 2025 9:00 am - 5:00 pm
-
Training course
This course is designed for those who use data analytics in their internal audit function
Presented by Mindgrove
The digitisation of organisations is forcing internal auditors to rethink their approach to data and become more ‘hands–on’. This course takes you on a rapid tour of how to get the most out of MS Excel software. Designed around the needs of novices and newcomers to this field, you’ll learn tips and tricks to speed up your work, particularly in the control testing phase of an audit.
Course overview
This course is open to all.
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
- manage and manipulate data to create persuasive results during the fieldwork phase of an audit.
The course is accompanied by a manual that has course text and a practice data to take away.
Data analytics and handling – working directly with Excel
- checking spreadsheet integrity – common sources of error
- invalid data and formulae precedents
- recording macros
- re‐performance and virtual calculations – a key audit skill
- shortcuts and speed–up keys – how to remember them
- Excel statistics – what do you get out of the box?
- filtering and stratification – how to do it?
- Pivot tables, Pivot charts and Slicers – what are they and how do they help?
- creating an audit workpaper within Excel
- simple and complex sortation, sorting by other than value.
Data analytics and handling – extras through Excel
- fuzzy data matching – an explanation of how the tool works and how to acquire it
- replicating what other paid–for software can do by substituting EXCEL
- formulae – simple examples of how they work and how to put them into use.
Data graphics – colour and imagery through Excel
- conditional formatting – correct, incorrect, high and low values, special searches
- using colour, icons, and thematic schemes
- creating charts – what might be suitable?
- embedding charts and images in your reports.
External data sources
- connecting with external data – why do this?
- data import into EXCEL from text, tables, proprietary databases, external websites
- the JET engine and MSQRY
- creating a query from tables and fields and editing
- editing queries using Power Editor and bringing results into EXCEL
- transforming data and creating transformation rules
- interacting with data sources to refresh data
- creating dashboards using free free–standing products such as Power BI and Tableau.