HR Statistics in Excel icon

HR Statistics in Excel | Online Course

Start testing your hypotheses using statistically valid methods. This online course teaches you essential statistical knowledge and how to apply it to human resources questions.

In this statistics training you will follow clear video lessons and practical activities to put your new skills to the test. You will learn how to formulate and test hypotheses in your organization, understand which statistical tests you need to perform and when, and how to support decision-makers with sound statistical analyses of HR data.


Online Self-paced

Study 3 hrs/week to finish in 5 weeks


Single course

only available as part of a certificate program


5 modules

11 video lessons + 11 activities

What you will do

HR Statistics in Excel course

Learn how to apply statistical tests to HR data

In this online HR course, you will learn the core concepts of statistics and how to apply them within the human resources domain.

+ course structure


Statistical Analysis 101


Validating Hypotheses: Chi-Square & Z Tests


Comparing Groups: The T-Test


Assessing Variations Between Groups: ANOVA & Tukey's HSD


Correlation Analysis

Download the syllabus for a detailed overview of all lessons, assignments, reading materials, and bonus content.

+ meet your instructor

Paul van der Laken profile picture

Paul van der Laken

Data Scientist


Paul van der Laken is a data science and machine learning expert with a PhD in people analytics. He's managed data science teams and projects at several multinationals, including Shell and Unilever.

Sampling & Surveys

Master different sampling techniques and best practices for survey design

Applying Statistical Tests

Learn when and how to apply statistical tests such as correlation analytics, T-test, and ANOVA

Statistical Significance

Grasp the concept of statistical significance and the different types of variablesy

Analyzing Data in Excel

Get hands-on with statistical analysis in Excel through practical case studies and activities

Download syllabus

Download the syllabus for the People Analytics Certificate Program (includes the HR Statistics in Excel course).

Enroll now
The HR Statistics in Excel course is available as part of our People Analytics Certificate Program.
People Analytics Foundations
1 modules
HR Data Analyst
4 modules
HR Dashboards in Power BI
5 modules
HR Statistics in Excel
5 modules
Capstone Project
1 modules
People Analytics Certificate Program
$ 975
1 Certificate Program
Full Access
$ 9,750
$ 1,650
11 Certificate Programs
installments from $ 165 / month

All our programs include

globe projects icon
human resources case study

Real-world projects & case-studies

Develop practical skills through working on real-world projects taught by the world’s best leading experts

people community icon
Global community of human resources professionals

Global HR practitioners community

Collaborate and solve problems on the spot by connecting with peers and HR professionals from around the world

accreditation seal icon
Accredited HR training courses

Accredited education

Globally accredited and recognized programs that are designed to help you learn practical skills and succeed

headset contact icon
best rated support and help

Personal Coach

Customize your learning path with your personal coach who is your one point of contact for everything AIHR


How will this HR Statistics in Excel course help me?

If you want to bring HR analytics to the next level, you need to be able to apply core statistical concepts. Finding correlations is a good first step but identifying cause-and-effect relationships is what will help you make an impact on the business using data. This is exactly what you will be learning with the Statistics in HR course. You'll learn the fundamentals of HR statistics and immediately apply your new skills in practical activities and case studies.

Why is this course not sold individually?

To optimize the quality of your learning experience, the HR Statistics in Excel course is not available for standalone enrollment. The course is part of our People Analytics Certificate Program and also included with the Full Academy Access License.

How do statistics help with HR Analytics?

Analytics are inseparable from statistics. Analytics is about making predictions using advanced algorithms or models. To identify which variables to add to your model, what sample size is needed, how effect sizes will impact your algorithm, and to answer many, many more analytics-related questions, you will need to have a solid understanding of statistics. That's what this course focuses on.


+   Are there any prerequisites?

This is an entry-level course. No prior statistical knowledge or skills are required. We do recommend that students have a basic understanding of HR Analytics, its process cycles, and possible applications.

+   Is there a fixed schedule?

No. This training is 100% online and self-paced! When you learn and how much time you spend each day, week, or month is up to.

In total, you will need to invest approximately 15 hours to finish the course.

+   How long do I have access to the course?

In total, you will have 12 months of access to the member portal, all lessons, and learning materials.

+   Are there subtitles available?

Yes. All our online trainings come with English subtitles. And this course also comes with additional Spanish subtitles!

+   Is this online course the right fit for me?

If you’re not sure if this course is the right fit, we are here to help you determine which training best fits your goals and needs! Simply talk to one of our admissions advisors or send them an email at [email protected]

Are You Ready to Develop In-Demand Skills?

Bring your People Analytics to the Next Level