Essential Math for Data Analysis using Excel Online

Course objective

Build up your analyst skills while removing the mathematical hurdles and barriers to analysing data. Microsoft Excel is one of the most efficient andhighly rated tools worldwide when it comes to analysing data efficiently, but you’ll still need some knowledge of basic maths to utilise Excel’s functions. In this course, you’ll learn how to use Excel to handle different data types, data sets, summary statistics, understand mathematical notation, and even get a sneak peek into making statistical inferences and predictions.

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
  • Summarise data with distributions and graphs
  • Apply summary statistics to analyse 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

What is included

  • Videos and reading resources
  • Hands-On Labs
  • A total of 51 questions
  • Final exam with 33 questions
  • Certification

Course Outline

  1. Introduction to data and variables
  2. Summarising data with distributions and graphs
  3. Summary statistics
  4. Business statistics
  5. Introduction to inferential math and forecasting