Essential Math for Data Analysis using Excel Online

This Essential Math for Data Analysis using Excel Online course gives you the essential mathematical skills for analyzing data.

Data Analysis Track - Essential Math for Data Analysis using Excel Online

About This Course

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.

What you’ll 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

Prerequisites

  • Basic excel proficiency

Course Syllabus

  • Module 1: Our Data-Driven World
  • Module 2: Our First Data Walkthrough
  • Module 3: Our Data Structures
  • Module 4: Our Data Analysis Methods
  • Module 5: Our Data Analysis in Context
  • Module 6: Final and Challenge Labs

Course Staff

Ben Olsen

Ben Olsen
Sr. Content Developer
Microsoft

Ben is a Sr. Content Developer for Microsoft’s Learning and Readiness team, and is an analytics professional and educator with over 8 years of industry and managerial experience. Prior to joining Microsoft, Ben ran and directed multiple consulting firms, where he also held critical analytics roles in companies as diverse as Juniper Networks, Costco, and T-Mobile. He has taught Data Visualization at The University of Washington, and recently founded Seattle Pacific University’s Analytics Certificate Program.

Tom Carpenter

Tom Carpenter
Assistant Professor of Psychology, Data Science consultant
Seattle Pacific University

Dr. Tom Carpenter is Assistant Professor of Psychology at Seattle Pacific University, and is also a Data Science consultant. His areas of expertise include personality-social psychology, research methods, and statistics. His teaching focuses on introductory and advanced research methods and statistics in psychology as well as social and personality psychology. Dr. Carpenter’s research focuses on our hypocritical human nature: our propensity to ignore our overt preferences and standards and to transgress against ourselves and others. One line of research in this area focuses on implicit bias, the impulsive thoughts that can undermine our higher reasoning. Dr. Carpenter has developed new software methods for running the Implicit Association Test (IAT) using online survey software (read more here: www.iatgen.wordpress.com). A second line of research focuses on guilt, shame, and self-forgiveness, specifically focusing on the functions of ‘guilt-proneness’ and ‘shame-proneness’ as well as associations with the general ability to forgive the self. Finally, Dr. Carpenter has conducted research related to his area of teaching (statistics education).No. We will be using Excel Online for all applied portions of the course

Start learning Essential Math for Data Analysis using Excel Online

You can enroll now for the Essential Math for Data Analysis using Excel Online course at our DataChangers Academy ! Do you want to learn more? Then check out our other Data Analysis Track Courses .

Please use a Windows Live ID email address to register at the DataChangers Academy if you want to obtain a certificate after finishing the courses. If you don’t have one, you can create one here.

Show what you know and get a certificate

After finishing this course, you can obtain a Microsoft Professional Program certificate. In order to obtain a certificate, you can buy a voucher from us (in collaboration with MD2C).

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.