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 https://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 https://aihr.ac/3Vab8vt
- Drive fact-based HR decisions with data https://aihr.ac/3L8JDOi
- Engage your top talent with a culture of learning https://aihr.ac/40IDJZX

Get unlimited access to all AIHR training courses and certificate programs with our Full Academy License https://aihr.ac/40zNvgU

👋👋 P.S. Follow us on LinkedIn for the latest HR developments!
  / aihr  

#AIHR #ExcelForHR #PivotTables