Essential Math for Data Analysis using Excel Online

Provided by Microsoft
\$99 USD
for a certificate

Learn essential mathematical skills for analyzing data

Professional CertificateExcel Fundamentals
Professional CertificateData Analysis: Absolute Beginners
Course Format:Instructor-Led
Start Date:Jan 1, 2019

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

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.

Before you start

Basic excel proficiency
• Instructor-Led: course contains assignments and exams that have specific due dates, and you complete the course within a defined time period.
• Course ends: Jan 22, 2019

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.

Also in Data Science at edX

Propelling

Drive your career forward with university-backed credit programs and verified certificates

Convenient

Study and demonstrate knowledge on your schedule

Flexible

Try a course before you pay

Supportive

Learn with university partners and peers from around the world