Statistics and Data Analysis with Excel: Advanced

Overview

This comprehensive online course will empower you with advanced statistical techniques to derive data summaries and visualisations for you to drive actionable insights, using Microsoft Excel. In this course, will gain proficiency in: Analysis of Variance - ANOVA, Multiple Regression, Dummy Variable Regression, as well as Advanced Charting and Forecasting. 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

ANOVA - Analysis of Variance

Welcome to Excel Skills for Statistics and Data Analysis - Advanced! In this module, we will cover ANOVA - Analysis of Variance. We will be looking at how we can compare and contrast three or more samples of data.

Multiple Regression

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

Categorical Data and Dummy Regression

In this module, we explore how we can incorporate qualitative data into a quantitative regression model.

Advanced Charting and Forecasting

In this module, we will be looking at some advanced charting and forecasting tools and techniques. This will include Bubble Charts, Exponential Smoothing, and Forecast Sheet.

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