Data Analytics for Internal Auditors *new*
February 25 @ 9:00 am - 5:00 pm GMT
One event on 25th February 2020 at 9:00 am
The Digital World and the presence of data everywhere in the organisation is forcing Internal Auditors to rethink their approach to data. This course takes you on a rapid tour of how to get the best out of everyday software that is available to most auditors. You’ll learn tips and tricks to speed up your work, by deploying software techniques, 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.
- Delegates ideally also need the ability to install two other software elements if they wish to explore all of the hands-on content on 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 unable to be accessed through a touchpad.
Delegates who arrive on course without these capabilities either will 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 you will be supplied with practice data to take away and work with after the course.
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
Duration: One full day
All the courses in this section are created, designed and presented by the staff of Mindgrove UK.