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.