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 …
Course: Essential Mathematics for Data Analysis in Microsoft Excel
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 …
These articles are from the online course:
Essential Mathematics for Data Analysis in Microsoft Excel
