 Essential Math for Data Analysis using Excel Online

Provided by Microsoft

Learn essential mathematical skills for analyzing data

Start Date:

Before you start

Basic excel proficiency

What you will learn

In this course, you will learn how to:
• Handle data sets for analysis purposes
• Understand beginning mathematical notation
• Work with different types of data
• Summarize data with distributions and graphs
• Apply summary statistics to analyze and understand data sets
• Calculate business metrics and KPIs to derive business value from data sets
• Apply basic inferential math to data
• Use tools to forecast future trends in data
Module 1: Introduction to Data and Variables

Module 2: Summarizing Data with Distributions and Graphs

Module 3: Summary Statistics

Module 5: Introduction to Inferential Math and Forecasting

Overview

This course is part of the Microsoft Professional Program in Data Analysis.

Starting with the absolute basics of math and data, this course builds up your analyst skills while removing the mathematical hurdles and barriers that often come with beginning to learn how to analyze data. This course is intended for anyone with the desire to do data analysis and who would like to learn the math behind it all in a simplified way, as well as for anyone who would like a thorough refresher on the essentials.

Learn how to handle different data types, understand mathematical notation, become proficient in handling data sets and summary statistics, and even get a sneak peek into how to be effective at making stctistical inferences and predictions, all told in a way to maximize your understanding—so that afterward, you can be well on your way toward analyzing data in any field or discipline.

Q: Do I need desktop Excel?
A: No. We will be using Excel Online for all applied portions of the course, with the exception of a lab in Module 5, where we will not require the desktop version of Excel and the applied portion is optional.

Q: Do I need a Windows computer to complete the course?
A: No. You can complete the labs using a computer running Windows, Mac OS X, or Linux.
View Courses Of all edX learners:
73% are employed
Of all edX learners:
45% have children
Based on internal survey results 391,509 people are learning on edX today