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

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