Analytical and Auditing Skills

Audits depend on the collection and analysis of data.  Many companies have plenty of data but little information. The ability to analyse data and interpret the findings is a critical skill. It enables us to make correct assertions, based on facts, and helps companies make the right decisions in complex situations. It also provides an audit trail and mitigates risk.

This Analytical and Auditing Skills training course equips trainees with the skills to extract secrets from data against tight deadlines and provides clear and consistent standards for analytical work. This is a highly practical training course, with the emphasis on learning by doing rather than “Death by PowerPoint”. Nearly all of the time is spent with delegates working through case studies and exercises.

 

Course Objectives of Analytical and Auditing Skills

• Understand how data analysis can improve decision making

• Cleanse a data set

• Select and apply appropriate analytical methods

• Perform an effective audit

• Prepare succinct reports, including graphs and charts

Day 1
Analytical Skills

• Steps in the Analytical Process

• Organising and Collecting Data

• Evaluating Data and Addressing Information Gaps

• Communication

• Creativity

• Critical Thinking

• Research

• Qualitative Analysis

Day 2
Quantitative Analysis

• Continuous Variables

• Charts and Graphs

• Mean

• Standard Deviation

• Normal Distribution

• Discrete Variables

• Patterns and Seasonality

• Correlation vs. Causation

Day 3
Data integrity

• Data Cleansing – duplicates

• Data Cleansing – outliers

• Common vs. Special Causes

• Control Chart

• Pareto Analysis

• Indices

Day 4
Auditing Skills

• The Responsibilities of an Auditor

• Attributes of Effective Auditors

• Planning & Preparation

• Developing Audit Documentation

• Conducting an Audit

• Effective Questioning

• Collection and Analysis of Objective Evidence

• Maintaining Independence

Day 5
Reporting

• Identifying Improvement Opportunities

• Developing and Documenting Audit Findings

• Discussing and Preparing Audit Conclusions

• Using Graphs and Charts as Appropriate

• Presenting Findings and Conclusions

• Follow-up