Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
Who Should Attend?
This course is suitable for intermediate learners who have a basic level of familiarity with writing Microsoft Excel formulas. No prior knowledge of statistics is necessary. It is best suited to accountants, management consultants, analysts and other business professionals.
Course Overview
This Kubicle course contains 7 lessons, 2 exercises and 1 Exam. It covers the following topics:
- Introduction to statistics
- Average, median and mode
- Interpreting percentiles
- Creating databins
- Variance and standard deviation
- Finding trends in data
- Correlation
Key Outcomes
Once you have completed this course you will know how to use all of Excel’s most popular statistics functions (e.g. MEDIAN, CORREL, PERCENTILE.EXC) and be able to deploy these functions in formulas that perform calculations on various datasets. You will also know when to correctly use these functions as many are only relevant certain datasets. Consequently, you will be able to avoid many common statistical errors that users make in Excel.