• Home
  • Statistical Data Analysis In Excel

Statistical Data Analysis In Excel


This 7 part e-learning program introduces and explores how mathematical tools available in Excel allow you to perform powerful analysis of relationships in data. The concepts in all of the modules apply to the fields of both internal and external audit.

Course is available for 120 days after purchase.

About

Content Description

Analytics are the most misunderstood, misapplied, and underutilised type of testing.

In this program you will look at your data differently and discover how ‘complex’ analytics can be made easy using maths tools available in Excel to assist you in identifying and concentrating your testing on the high risk issues that matter.

You will learn how to apply regression analysis in an audit context and audit smarter by quickly and efficiently identifying outliers, targeting your testing and saving you audit time and costs.

You will also learn how to take it to the next level by building statistical bounds and adding benchmarks to your analysis. You will identify and address some common complexities that arise when running regression in reality, which will help you to persist with your analysis when hurdles arise.

Learning Outcomes

At the end of this activity you will be able to: 
• Understand and employ multiple types of analytics in an audit context, but in particular, regression analysis. 
• Distinguish between differing types of audit evidence and their associated costs. 
• Comply with promulgated internal and external audit standards for analytical procedures. 
• Introduce efficiency and effectiveness into the audit process via analytical procedures. 
• Perform regression analysis in Excel. 
• Assign statistical confidence and tolerances to regression analyses in Excel. 
• Apply benchmarks to your analyses. 
• Utilise features of the Analysis ToolPak in Excel. 
• Address common complexities that arise when analysing data.

Benefits

This program equips you with the knowledge and skills to maximise your use of analytical procedures and utilise the mathematical tools available in Excel to save time and costs.

This activity is presented by Audit Smarter.

Course is available for 120 days after purchase.

EVENT DETAILS


Topic: Audit & Assurance

Sub-Topic: Internal Audit

Format: Self-paced

Proficiency Level: Foundation, Intermediate

CPD: 10 hours