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

La Fête du Travail commence avec plus de 70 $ d'économies sur Coursera Plus. Bénéficiez de 40 % de réduction pendant 3 mois.

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues. Consultez les langues disponibles.

Statistics and Data Analysis with Excel: Intermediate

Ce cours fait partie de Spécialisation "Statistics and Data Analysis with Excel"

Enseigné en Français (doublage IA)

Instructeur : Assoc Prof Prashan S. M. Karunaratne

4 389 déjà inscrits

Inclus avec En savoir plus

5 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

22 avis

niveau Intermédiaire

Expérience recommandée

1 semaine à compléter

à 10 heures par semaine

5 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

22 avis

niveau Intermédiaire

Expérience recommandée

1 semaine à compléter

à 10 heures par semaine

Ce que vous apprendrez

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.

Compétences que vous acquerrez

Catégorie : Data Analysis Software
Catégorie : Spreadsheet Software
Catégorie : Descriptive Statistics
Catégorie : Sampling (Statistics)
Catégorie : Correlation Analysis
Catégorie : Data Analysis
Catégorie : Statistical Hypothesis Testing
Catégorie : Data Presentation
Catégorie : Statistical Analysis
Catégorie : Predictive Modeling
Catégorie : Statistical Methods
Catégorie : Regression Analysis
Catégorie : Variance Analysis
Catégorie : Data Visualization
Catégorie : Excel Formulas
Catégorie : Pivot Tables And Charts
Catégorie : Data Visualization Software
Catégorie : Statistical Inference
Catégorie : Statistics

Outils que vous découvrirez

Catégorie : Microsoft Excel

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Évaluations

9 devoirs

Enseigné en Français (doublage IA)

Planning flexible

Apprenez à votre propre rythme

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Élaborez votre expertise du sujet

Ce cours fait partie de la Spécialisation "Statistics and Data Analysis with Excel"

Lorsque vous vous inscrivez à ce cours, vous êtes également inscrit(e) à cette Spécialisation.

Apprenez de nouveaux concepts auprès d'experts du secteur
Acquérez une compréhension de base d'un sujet ou d'un outil
Développez des compétences professionnelles avec des projets pratiques
Obtenez un certificat professionnel partageable

Il y a 5 modules dans ce cours

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.

Inclus

8 vidéos7 lectures2 devoirs

8 vidéosTotal 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 lecturesTotal 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 devoirsTotal 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.

Inclus

3 vidéos4 lectures2 devoirs

3 vidéosTotal 14 minutes

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

4 lecturesTotal 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 devoirsTotal 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.

Inclus

4 vidéos5 lectures2 devoirs

4 vidéosTotal 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 lecturesTotal 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 devoirsTotal 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.

Inclus

9 vidéos6 lectures3 devoirs

9 vidéosTotal 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 lecturesTotal 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 devoirsTotal 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

Inclus

8 lectures

Obtenez un certificat professionnel

Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.

Instructeur

Évaluations de l’enseignant

(6 évaluations)

Assoc Prof Prashan S. M. Karunaratne

28 Cours1 743 187 apprenants

Offert par

Macquarie University

En savoir plus sur Data Analysis

Coursera
Advanced Quantitative Statistics with Excel
Cours
Statut : Essai gratuit
Macquarie University
Statistics and Data Analysis with Excel: Advanced
Cours
Statut : Essai gratuit
Macquarie University
Statistics and Data Analysis with Excel: Essentials
Cours
Statut : Essai gratuit
Logical Operations
Excel: Statistical Analysis and Data Transformation
Cours
Statut : Essai gratuit

Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?

Felipe M.

Étudiant(e) depuis 2018

’Pouvoir suivre des cours à mon rythme à été une expérience extraordinaire. Je peux apprendre chaque fois que mon emploi du temps me le permet et en fonction de mon humeur.’

Jennifer J.

Étudiant(e) depuis 2020

’J'ai directement appliqué les concepts et les compétences que j'ai appris de mes cours à un nouveau projet passionnant au travail.’

Larry W.

Étudiant(e) depuis 2021

’Lorsque j'ai besoin de cours sur des sujets que mon université ne propose pas, Coursera est l'un des meilleurs endroits où se rendre.’

Chaitanya A.

’Apprendre, ce n'est pas seulement s'améliorer dans son travail : c'est bien plus que cela. Coursera me permet d'apprendre sans limites.’

Avis des étudiants

5 étoiles
73,91 %
4 étoiles
17,39 %
3 étoiles
8,69 %
2 étoiles
0 %
1 étoile
0 %

Affichage de 3 sur 22

5.0

Révisé le 8 févr. 2026

I always had a problem to understand statistics. After this training, everything became understandable and easy. Thank you.

Voir plus d’avis

Profitez de plus de 10 000 programmes grâce à notre offre spéciale pour la Fête du Travail
Abonnez-vous à Coursera Plus
Commencez par réaliser des économies simples pour vos équipes qui travaillent dur
Économisez 30 % dès aujourd'hui

Foire Aux 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 course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.