Skip main navigation

Hurry, only 4 days left to get one year of Unlimited learning for £249.99 £174.99. New subscribers only. T&Cs apply

Find out more

Welcome to the Course

Welcome to Microsoft Future Ready: Data Analysis Using Excel with Essential Mathematics course. Starting with the absolute basics of maths and data, this course builds up your analyst skills while …

Time Series Forecasting

Lesson 3: Time Series Forecasting In this lesson, we’ll look at another forecasting method. This one is useful if we have a long history of data (for example, revenue over …

KPI Exercises

Lesson 2: Business KPIs In this lesson, we’ll roll up our sleeves and calculate a few different types of KPIs used often in the business world, with a special focus …

Null Hypothesis Testing Overview

Lesson 2: T-Test Comparing Two Groups In this lesson, we’ll dig into one of the most common methods for null hypothesis testing: the t-test. If we can show that the …

Data Forecasting

Lesson 1: Forecasting Concepts In this very short video lesson, we’ll get a quick introduction to two methods for exploring future trends in data: null hypothesis testing and time-series analysis.

Business Math

Lesson 1: Introduction to KPIs In this short lesson, we’ll dip our toes into the wide, wonderful world of business math and KPIs.

Proportions are not Averages

Proportions are percentages but written as a decimal such as 0,5 for 50%. People often think of these as averages but they’re actually a little bit different. In the above …

Bar Graph vs. Histogram

Lesson 4: Bar Graphs and Pie Charts This lesson throws a couple new types of data visualization into the mix: bar graphs and pie charts. We’ll see why bar graphs …

Skew

Lesson 2: Skew In the second lesson of this module, we’ll look at a new concept called “skewness,” which measures how asymmetrical (or skewed) a set of data is. We’ll …

Count Distributions

Lesson 3: Non-Normal Distributions In this lesson, we’ll take a brief look at some other distributions of data. We’ll also explore the differences between “discrete” and “continuous” data. Lab: Count …