Thumbnail | Products | Price | Action |
---|---|---|---|
|
Statistical Data Analytics In Excel - Section A: The Audit Risk Model and Why Use Analytics?
The audit risk model quantifies the audit process. Remember it?? It encourages efficiency and effectiveness… plan more, and audit way, way less! Let's refresh the concepts and look at it from a different angle. You will find the different costs of evidence and their impact on your audit efficiency staggering! Find out why you need to maximise the use of analytics in your audit programs.Module length 45-60 mins, self-paced. Course Module available for 30 days after purchasing.This is 1 of 7 modules of a complete course. Discounts apply if all 7 modules of the course are purchased as a package. |
$129.00
|
|
|
Statistical Data Analytics In Excel - Section B: The Six Levels of Analytical Procedures
Can you name the globally agreed-upon six (6) procedures? There are analytics and there are ANALYTICS. Are you maximising your use of the most efficient form of audit test? This is not about running scripts over data, this is about true analysis that turns data into information.Module length 75-90 mins, self-paced. Course Module available for 30 days after purchasing.This is 2 of 7 modules of a complete course. Discounts apply if all 7 modules of the course are purchased as a package. |
$159.00
|
|
|
Statistical Data Analytics In Excel - Section C: Simple Linear Regression
Remember regression analysis from college/university? You were taught the math rather than how to apply it to the real world. Learn how this mathematical tool will help you audit smarter by quickly and efficiently identifying outliers, targeting your testing and thus saving you valuable audit time and money.Module length 100-115 mins, self-paced. Course Module available for 30 days after purchasing.This is 3 of 7 modules of a complete course. Discounts apply if all 7 modules of the course are purchased as a package. |
$189.00
|
|
|
Statistical Data Analytics In Excel - Section D: Setting Bounds (Constructing Prediction Intervals) for Regression
Now that you know how to run regression in an audit context, learn how to build statistical bounds and add benchmarks to your analysis. Why do this? Eliminate the need for judgment calls or grey areas by statistically defining outliers and being able to put some math into your conclusions. When was the last time you could start your report with the words “I am 95% confident that… “.Pre-requisite knowledge: It is assumed you are familiar with the concepts of Section C before completing this section.Module length 75-90 mins, self-paced. Course Module available for 30 days after purchasing.This is 4 of 7 modules of a complete course. Discounts apply if all 7 modules of the course are purchased as a package. |
$159.00
|
|
|
Statistical Data Analytics In Excel - Section E: Noise Due to Data Sub-Populations and Lagging
Let’s address some common complexities that occur when you run regression in the real world. Reality is that you don’t always get a nice, neat looking analysis. Learn how to identify and address what the statisticians call ‘noise’ in the data, i.e. sub-populations and the effect of time lag/time lapse on your data.Pre-requisite knowledge: It is assumed you are familiar with the concepts of Section C & D before completing this section.Module length 60-75 mins, self-paced. Course Module available for 30 days after purchasing.This is 5 of 7 modules of a complete course. Discounts apply if all 7 modules of the course are purchased as a package. |
$129.00
|
|
|
Statistical Data Analytics In Excel - Section F: Curve Linear Regression
Let’s address another complexity that can occur when you run regression in the real world – not all data is linear. Learn how to run regression where relationships in your data are non-linear.Pre-requisite knowledge: It is assumed you are familiar with the concepts of Section C, D & E before completing this section.Module length 30-45 mins, self-paced. Course Module available for 30 days after purchasing.This is 6 of 7 modules of a complete course. Discounts apply if all 7 modules of the course are purchased as a package. |
$69.00
|
|
|
Statistical Data Analytics In Excel - Section G: Analytics for Fraud, Waste and Abuse
Learn what the research shows about how fraud is found, and perform case studies demonstrating how regression can be used as an advanced analytical tool to perform gap analysis, to reconstruct questionable or missing source data and to identify systematic fraud.Pre-requisite knowledge: It is assumed you have completed Sections C and D before commencing Section G.Module length 115-130 mins, self-paced. Course Module available for 30 days after purchasing.This is 7 of 7 modules of a complete course. Discounts apply if all 7 modules of the course are purchased as a package. |
$199.00
|
|
|
Sampling for Tests of Controls - Section A: The Audit Risk Model & What’s In It For Me
The audit risk model quantifies the audit process. Remember it?? It encourages efficiency and effectiveness… plan more, and audit way, way less! Let's refresh the concepts and look at it from a different angle. You will find the different costs of evidence and their impact on your audit efficiency staggering!Module length 45-60 mins, self-paced. Course Module available for 30 days after purchasing.This is 1 of 8 modules of a complete course. Discounts apply if all 8 modules of the course are purchased as a package. |
$129.00
|
|
|
Sampling for Tests of Controls - Section B: Statistics (not "Sadistics") and Tying Sample Size to Audit Risk
Yes, we need to revisit some time-honoured concepts (variance, alpha error, beta error, precision). Relax! We’ll make it easy by explaining it in plain English! The pay-off for getting this planning right is smaller sample sizes!Module length 75-90 mins, self-paced. Course Module available for 30 days after purchasing.This is 2 of 8 modules of a complete course. Discounts apply if all 8 modules of the course are purchased as a package. |
$159.00
|
|
|
Sampling for Tests of Controls - Section C: Multiple Statistical Sampling Methods
Learn that four methods for selecting samples for controls testing are available! We will teach you the four methods in Sections D, E, F and H. Find out how to choose the right method for your objectives and how to choose the right method to generate smaller sample sizes. Also obtain instructions on how to download the free sampling software (EZ-Quant) which we will be using during the rest of the course.Module length 20-30 mins, self-paced. Course Module available for 30 days after purchasing.This is 3 of 8 modules of a complete course. Discounts apply if all 8 modules of the course are purchased as a package. |
$69.00
|
|
|
Sampling for Tests of Controls - Section D: The "Fixed" Statistical Sampling Method
Find out when to apply the fixed sampling method in an audit context. Most auditors apply this for any and all controls testing they perform, however we will identify the right circumstances in which to apply this method. This module familiarises (or re-familiarises) you with the most commonly taught attribute sampling method.Pre-requisite knowledge: It is assumed you have completed Sections B and C before commencing Section D.Module length 60-75 mins, self-paced. Course Module available for 30 days after purchasing.This is 4 of 8 modules of a complete course. Discounts apply if all 8 modules of the course are purchased as a package. |
$129.00
|
|
|
Sampling for Tests of Controls - Section E: The "Two Step" Statistical Sampling Method
Suitable for Internal Auditors and External Auditors doing tests of controls, this is the most efficient statistical sampling method in the world. Also known as ‘Stop and Go Sampling’ this method is an auditor’s dream, producing small sample sizes. This highly desirable method is rarely seen in auditing literature.Pre-requisite knowledge: It is assumed you have completed Sections B and C before commencing Section E.Module length 60-75 mins, self-paced. Course Module available for 30 days after purchasing.This is 5 of 8 modules of a complete course. Discounts apply if all 8 modules of the course are purchased as a package. |
$129.00
|
|
|
Sampling for Tests of Controls - Section F: The "Discovery" Statistical Sampling Method for Fraud
This is your ‘go to’ method if you need to test for fraud and make a powerful statement like, “I’m 99% confident that no fraud has occurred”. Get the right audit tool for the job.Pre-requisite knowledge: It is assumed you have completed Sections B and C before commencing Section F.Module length 40-55 mins, self-paced. Course Module available for 30 days after purchasing.This is 6 of 8 modules of a complete course. Discounts apply if all 8 modules of the course are purchased as a package. |
$99.00
|
|
|
Sampling for Tests of Controls - Section G: A Very Necessary Discussion on Selecting Your Sample
After choosing the right sampling method, don’t undermine it by introducing BIAS via your selection process! If you get it wrong, it’s the easiest way for someone to attack your findings and conclusions. Discover the pros and cons of the 5 recognised selection techniques. Learn how to pull your sample without bias, address sample representativeness and use EZ-Quant as a random number generator.Pre-requisite knowledge: It is assumed you have downloaded the “EZ-Quant” freeware described in Section C before commencing this section.Module length 60-75 mins, self-paced. Course Module available for 30 days after purchasing.This is 7 of 8 modules of a complete course. Discounts apply if all 8 modules of the course are purchased as a package. |
$129.00
|
|
|
Sampling for Tests of Controls - Section H: Estimation Sampling
This attribute sampling method is relevant for first-time audits or consulting work where you don’t know the expected error or tolerable error for the population, but you need to find out. Learn how to estimate the error rate and let the data talk to you via this method.Pre-requisite knowledge: It is assumed you have completed Sections B and C before commencing Section H.Module length 30-45 mins, self-paced. Course Module available for 30 days after purchasing.This is 8 of 8 modules of a complete course. Discounts apply if all 8 modules of the course are purchased as a package. |
$69.00
|