Statistics and Data Analysis with Excel: Intermediate

Overview

In today's data-driven world, the ability to analyse and interpret complex data is crucial for making informed, strategic decisions. This comprehensive online course will empower you with advanced statistical techniques to transform raw data into actionable insights, using Microsoft Excel. Through hands-on exercises, you will delve into the world of inferential statistics, learning how to draw meaningful conclusions and make accurate predictions based on sample data. Gain proficiency in creating and interpreting pivot tables, pivot charts, and other interactive data visualisations to effectively communicate your findings. Enhance your digital literacy with extensive use of Excel's advanced functions and the Data Analysis ToolPak, streamlining your data analysis workflow. Join over 1 million professionals who have advanced their careers with our highly-rated Excel courses. Whether you’re looking to boost your employability, enhance your current role, or simply elevate your Excel skills, this course will provide you with the knowledge and tools to stand out in the competitive job market. Enrol now and become a data-driven leader, driving strategic decisions with confidence and precision.

Syllabus

Pivot Tables and Pivot Charts

In this module, we will cover the Pivot Tables and Pivot Charts. We will be looking at how we can generate useful numerical summaries from large data sets.

Categorical Data and Goodness-of-Fit

In this module, we will be looking at categorical data. We will also explore statistical techniques and tests to infer whether we have any significant patterns in our distributions of categorical variables.

Two Sample Tests

In this module, we will explore the statistical tools and techniques that are available when we are comparing and contrasting two sets of data.

Correlation and Simple Regression

In this module, we explore the statistical tools and techniques that are available when we have Correlated data sets and when we have a Cause and Effect relationship between two data sets.

Optional - Additional Excel Content to enhance your Excel Skills

The material in this section consists of a series of Toolboxes. While the material covered in these Toolboxes is not necessarily related to Statistics - these Toolboxes will help you expand your tools and techniques in Microsoft Excel. To further your skills in Microsoft Excel in domains beyond Statistics, you may want to consider our other courses and specializations: Excel Skills for Business. Excel Skills for Data Analytics and Visualization, Excel Skills for Business Forecasting