Ir al contenido principal

Essential Math for Data Analysis using Excel Online

Ofrecido por Microsoft
2–4 horas
por semana, durante 6 semanas
Gratis

\$99 USD para exámenes y tareas con calificación, más un certificado

Learn essential mathematical skills for analyzing data

Antes de comenzar

Basic excel proficiency
Inicio del curso: Jul 1, 2019
Finalización del curso: Oct 1, 2019

Lo que aprenderás

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

Información general

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.

Conoce a tus instructores

Ben Olsen
Sr. Content Developer
Microsoft
Tom Carpenter
Data Science and Research Consultant
Trevor Barnes
Content Developer
Self-employed

Preguntas frecuentes

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.
Ver cursos
Este curso forma parte de:

Obtén un Professional Certificate de de 2 a 4 meses si tomas un curso a la vez.

Ver el programa
1. 8–12 horas de trabajo

Practical Data Visualization techniques, tips, and tricks for the aspiring analyst and people who want to start from the beginning in any field needing this critical 21st-century skill.

2. 12–24 horas de trabajo

Become Data Literate, no prior experience required. This hands-on course gives you an overview of what a Data Analyst needs to know and deliver, and is meant to inspire you with all the possibilities that Data unlocks for the world.

Comienza con análisis de datos y estadísticas

Explorar 200 cursos de análisis de datos y estadísticas
Del total de los estudiantes de edX:
El 73% tiene empleo
Del total de los estudiantes de edX:
El 45% tiene hijos
Según los resultados de encuestas internas
397,645 personas están aprendiendo hoy en edX