Learn the basics of HR data analytics | Make Better Decisions | Hands on with Excel and Sheets
InstructorRobert HeanLearners engage with specific exercises to derive headcount, engagement, diversity, and recruiting metrics using mock data.
The curriculum provides parallel guidance for both Google Sheets and Microsoft Excel, covering essential functions like AverageIf and CountIf.
Editorial course preview
These 4 complementary views highlight concrete, legible examples from the course presentation.
This instructional slide outlines hands-on activities involving a sample HR dataset, calculating metrics like turnover in Google Sheets, and performing data hygiene.
This overview slide outlines the course curriculum, covering foundational topics like data sources, challenges, Google Sheets basics, and how HR teams are perceived.
This slide outlines the course's target audience, identifying three key groups: individuals new to HR data, established HR teams, and managers seeking team insights.
The instructor demonstrates a 'Mad Libs' technique using fill-in-the-blank sentence templates to help students formulate analytical questions about their datasets.
Instruction is noted for being easy to follow, utilizing visual and practical examples to explain how to measure and present data.
The technical scope is narrow, focusing on a small number of spreadsheet functions which may not satisfy those seeking deeper analytical capabilities.
The curriculum aligns well with the stated goal of helping beginners understand basic HR metrics.
