Skip main navigation

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 …

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.

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 …

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 …

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.

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 …