Excel Skills for Statistics and Data Analysis: 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

Welcome and Critical Information

Welcome to Excel Skills for Statistics and Data Analysis - Intermediate! In this module, we will go through why you need to study this course and what skills you will gain. Additionally, we will go through how the course is structured, and the resources you have along the way. We can't wait to see you further your knowledge in Excel Skills for Statistics and Data Analysis!

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.

Course wrap up - Bringing it all together in one Final Assignment

The course wrap-up involves bringing everything together in the final assignment. Make sure you have attempted each of the Practice Assignments in previous modules before you attempt this Final Assignment. Ensure you understand the assignment requirements to complete it successfully. You've got this!

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