Excel For HR: How to Use Pivot Tables [2023]

Pivot Table does all the manual work for you, allowing you to skip directly to the data analysis. But how can you use it for HR?
This video is part of our People Analytics Certificate Program. You will discover how to use the Pivot Table function in Excel to perform data analysis for the most common HR requests.
You will learn:
- How to create a Pivot Table from an existing dataset
- How to add and group data
- How to apply filters to your data
Watch the full video to find out how to apply Pivot Table to your HR data analysis in Excel.
This video uses a dataset based on fictitious data created for the People Analytics Certificate Program and is available as a resource for AIHR students.
If you want to learn more about how you can use data analysis to make better people decisions, check out our People Analytics Certificate Program aihr.ac/3Lw1AYo
TIMESTAMPS
00:00 Introduction
02:05 Creating a Pivot Table
04:28 Adding and grouping data
06:44 Manipulating data
09:41 Applying filters
11:27 Conclusion
____________________________________________________________________________
Upskill yourself and future-proof your HR career with our courses and certificate programs:
- Become a driver of HR's digital transformation aihr.ac/3Vab8vt
- Drive fact-based HR decisions with data aihr.ac/3L8JDOi
- Engage your top talent with a culture of learning aihr.ac/40IDJZX
Get unlimited access to all AIHR training courses and certificate programs with our Full Academy License aihr.ac/40zNvgU
👋👋 P.S. Follow us on LinkedIn for the latest HR developments!
/ aihr
#AIHR #ExcelForHR #PivotTables

[@dawnmccoy3654]

I love this video! Up until now, I have been terrified of pivot tables but this gives me confidence in how and why I would use them.

[@user-xj1gc9yc8k]

I want more video wher to go

[@AIHRAcademytoInnovateHR]

Hi there! Glad you enjoyed the video! If you'd like more videos on data-driven HR, make sure to subscribe to our channel. You might also be interested in People Analytics certificate program: www.aihr.com/courses/people-analytics-certificate/