When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Statistics and Data Analysis with Excel: Advanced

Statistics and Data Analysis with Excel: Advanced

This course is part of Statistics and Data Analysis with Excel Specialization

Instructor: Assoc Prof Prashan S. M. Karunaratne

4,825 already enrolled

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

35 reviews

Advanced level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

35 reviews

Advanced level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Design and develop interactive data visualisations in Excel.
Integrate Excel functions and the Data Analysis ToolPak for professional applications.
Analyse and evaluate data in Excel using advanced statistical tools.
Create forecasts in Excel to drive actionable insights.

Skills you'll gain

Tools you'll learn

Microsoft Excel

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

9 assignments

Taught in English

91% of learners achieved a positive career outcome

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Statistics and Data Analysis with Excel Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 5 modules in this course

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.

Module details

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.

What's included

6 videos7 readings2 assignments

6 videosTotal 20 minutes

Welcome to Statistics and Data Analysis with Excel: Advanced2 minutes
ANOVA - Analysis of Variance2 minutes
One-way ANOVA3 minutes
Two-way ANOVA with replication - Part 16 minutes
Two-way ANOVA with replication - Part 24 minutes
Two-way ANOVA without replication3 minutes

7 readingsTotal 70 minutes

Course Overview10 minutes
Your Learning Path - How the course is structured10 minutes
Download workbooks10 minutes
Toolbox Summary - One-Way ANOVA10 minutes
Toolbox Summary - ANOVA 10 minutes
Why the Practice Assignment is after the Graded Assignment10 minutes
Optional Reading - ANOVA10 minutes

2 assignmentsTotal 60 minutes

Practice for the Final Assignment of the Course30 minutes
Test Yourself on ANOVA30 minutes

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.

What's included

6 videos4 readings2 assignments

6 videosTotal 31 minutes

Multiple Regression (Intro) Part 14 minutes
Multiple Regression (Intro) Part 24 minutes
Multiple Regression5 minutes
Multiple Regression - Forecasting part 15 minutes
Multiple Regression - Forecasting part 24 minutes
Multiple Regression - Tests9 minutes

4 readingsTotal 40 minutes

Download workbooks10 minutes
Toolbox Summary - Multiple Regression10 minutes
Why the Practice Assignment is after the Graded Assignment10 minutes
Optional Reading - Multiple Regression10 minutes

2 assignmentsTotal 60 minutes

Practice for the Final Assignment of the Course30 minutes
Test Yourself on Multiple Regression30 minutes

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

What's included

5 videos4 readings2 assignments

5 videosTotal 27 minutes

Categorical Data and Dummy Regression 4 minutes
Dummy Regression8 minutes
Dummy Regression - Forecasting - Part 1 6 minutes
Dummy Regression - Forecasting - Part 23 minutes
Dummy Regression - Tests7 minutes

4 readingsTotal 40 minutes

Download workbooks on Categorical Data and Dummy Regression10 minutes
Toolbox Summary - Dummy Regression10 minutes
Why the Practice Assignment is after the Graded Assignment10 minutes
Optional Reading - Categorical Data and Dummy Regression10 minutes

2 assignmentsTotal 60 minutes

Practice for the Final Assignment of the Course30 minutes
Test Yourself on Categorical Data and Dummy Regression30 minutes

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.

What's included

4 videos8 readings3 assignments

4 videosTotal 17 minutes

Advanced Charting and Forecasting (Intro)3 minutes
Bubble Charts7 minutes
Exponential Smoothing4 minutes
Forecast Sheet4 minutes

8 readingsTotal 80 minutes

Download workbooks10 minutes
Toolbox Summary - Specialised Charts10 minutes
Toolbox Summary - Forecast Sheet workaround for Macs10 minutes
Toolbox Summary - Phases of the Business Cycle10 minutes
Toolbox Summary - Create an Interactive Dashboard10 minutes
Toolbox Summary - Dashboard Design Principles10 minutes
Why the Practice Assignment is after the Graded Assignment10 minutes
Optional Reading - Advanced Charting and Forecasting10 minutes

3 assignmentsTotal 120 minutes

Practice for the Final Assignment of the Course30 minutes
Test Yourself on Advanced Charting and Forecasting30 minutes
Final Assignment: Advanced Statistics and Data Analysis using Excel60 minutes

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