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: Intermediate

Statistics and Data Analysis with Excel: Intermediate

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

Instructor: Assoc Prof Prashan S. M. Karunaratne

4,149 already enrolled

Included with Learn more

Ask Coursera

5 modules

Gain insight into a topic and learn the fundamentals.

Intermediate 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.

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Analyse and evaluate data using advanced statistical methods.
Synthesise and interpret inferential statistics for predictive analysis.
Design and develop interactive data visualisations.
Integrate Excel functions and Data Analysis ToolPak for professional applications.

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

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

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. Each module includes downloadable workbooks, toolbox summaries, applied dialogue activities, and both practice and graded assessments, building to a comprehensive final assignment. Who this is for: Data analysts, business professionals, and researchers who have completed the Essentials course — or equivalent statistics experience — and are ready to apply more advanced analytical methods. 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.

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.

What's included

8 videos7 readings2 assignments

8 videosTotal 35 minutes

Welcome to Statistics and Data Analysis with Excel: Intermediate2 minutes
Introduction to Pivot Tables and Pivot Charts1 minute
PivotTables - Part 15 minutes
PivotTables - Part 26 minutes
Customising Pivot Tables - Part 15 minutes
Customising Pivot Tables - Part 26 minutes
Pivot Charts - Part 14 minutes
Pivot Charts - Part 27 minutes

7 readingsTotal 70 minutes

Course Overview10 minutes
Your Learning Path - How the course is structured10 minutes
Download the workbooks on Pivot Tables and Pivot Charts10 minutes
Toolbox Summary - Pivot Tables & Pivot Charts Part 110 minutes
Toolbox Summary - Pivot Tables & Pivot Charts Part 210 minutes
Why the Practice Assignment is after the Graded Assignment10 minutes
Optional Reading - Pivot Tables and Pivot Charts10 minutes

2 assignmentsTotal 60 minutes

Pivot Tables and Pivot Charts - Practice for the Final Assignment of the Course30 minutes
Test Yourself: Pivot Tables and Pivot Charts30 minutes

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.

What's included

3 videos4 readings2 assignments

3 videosTotal 14 minutes

Categorical Data and Goodness-of-Fit3 minutes
Goodness-of-Fit7 minutes
The Chi-Square Test4 minutes

4 readingsTotal 40 minutes

Download the workbook on Categorical Data and Goodness-of-Fit10 minutes
Toolbox Summary - Categorical Data and Chi Square Tests10 minutes
Why the Practice Assignment is after the Graded Assignment10 minutes
Optional Reading - Categorical Data and Goodness-of-Fit10 minutes

2 assignmentsTotal 60 minutes

Categorical Data and Goodness-of-Fit - Practice for the Final Assignment of the Course30 minutes
Test Yourself: Categorical Data and Goodness-of-Fit30 minutes

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

What's included

4 videos5 readings2 assignments

4 videosTotal 14 minutes

Two sample tests3 minutes
Two Sample t-test for Means4 minutes
Paired t-test3 minutes
Two Sample F-test for Variances4 minutes

5 readingsTotal 50 minutes

Download the workbook on Two Sample Tests10 minutes
Toolbox Summary - Two Sample t Tests10 minutes
Toolbox Summary - Paired t Tests10 minutes
Why the Practice Assignment is after the Graded Assignment10 minutes
Optional Reading - Two Sample Tests10 minutes

2 assignmentsTotal 60 minutes

Two Sample Tests - Practice for the Final Assignment of the Course30 minutes
Test Yourself: Two Sample Tests30 minutes

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.

What's included

9 videos6 readings3 assignments

9 videosTotal 44 minutes

Correlation and Simple Regression Part 14 minutes
Correlation and Simple Regression Part 23 minutes
Correlation5 minutes
Simple Regression - Part 17 minutes
Simple Regression - Part 25 minutes
Simple Regression - Forecasting Part 16 minutes
Simple Regression - Forecasting Part 24 minutes
Simple Regression - Tests Part 15 minutes
Simple Regression - Tests Part 27 minutes

6 readingsTotal 60 minutes

Download the workbooks on Correlation and Simple Regression10 minutes
Toolbox Summary - Correlation and Regression10 minutes
Toolbox Summary - Simple Regression10 minutes
Why the Practice Assignment is after the Graded Assignment10 minutes
Optional Reading - Correlation and Simple Regression10 minutes
Summary of Course and Next Steps10 minutes

3 assignmentsTotal 90 minutes

Correlation and Simple Regression - Practice for the Final Assignment of the Course30 minutes
Test Yourself: Correlation and Simple Regression30 minutes
Final Assignment: Excel Skills for Statistics and Data Analysis: Intermediate30 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

What's included

8 readings

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Assoc Prof Prashan S. M. Karunaratne

28 Courses1,699,365 learners

Offered by

Macquarie University

Explore more from Data Analysis

Macquarie University
Statistics and Data Analysis with Excel: Essentials
Course
Macquarie University
Statistics and Data Analysis with Excel: Advanced
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Unlock access to 10,000+ courses with a subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 4,700 global companies that choose Coursera for Business

Frequently asked questions

While not strictly required, completing Statistics and Data Analysis with Excel: Essentials — or having equivalent knowledge — is strongly recommended. This Intermediate course assumes you are already familiar with descriptive statistics, the normal distribution, and one-sample hypothesis testing (Z-tests and t-tests). Learners without this background may find the pace challenging from the start.

You'll work with PivotTables and Pivot Charts for data summarisation, Chi-square tests for categorical data, two-sample t-tests and paired t-tests for comparing means, F-tests for comparing variances, and correlation and simple regression for modelling relationships and making forecasts. Excel's Data Analysis ToolPak is used throughout to support and streamline these analyses.

The techniques covered — PivotTable reporting, hypothesis testing, and regression modelling — are directly applicable to roles including data analyst, business analyst, financial analyst, research analyst, operations manager, and HR analytics professional. These skills are particularly valuable in industries where data-informed decisions are expected but advanced programming knowledge is not required.

Simple regression is a statistical method that models the relationship between two variables — one that you want to predict (the outcome) and one that drives it (the predictor). In this course, you'll build regression models in Excel, interpret the line of best fit, generate forecasts, and use regression t-tests to evaluate whether the relationship is statistically significant. These are core skills for any data-facing role.

This course combines rigorous statistical methods with practical Excel application — using the Data Analysis ToolPak alongside hands-on workbooks and real-world scenarios. Unlike general Excel courses, the focus here is specifically on statistical inference and predictive modelling. Unlike programming-based statistics courses, all analysis is done in Excel, making the skills immediately applicable for professionals who work in spreadsheet environments every day.

Each week includes short instructional videos, a downloadable Excel workbook to practise in, toolbox summary references, a dialogue activity that applies concepts to realistic scenarios, a graded "Test Yourself" assignment, and a practice assignment you can use to build confidence. The course closes with a final assignment that draws on all four core modules.

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.