Course · 6 chapters
People Analytics with Excel + AI
The HRIS-export problem, solved: headcount, attrition, and comp cycles in Excel with Copilot and Claude, the monthly people pack in an afternoon.
What you'll be able to do
- One HRIS export becomes your first clean headcount bridge in 20 minutes, in a workbook you reuse every month.
- Split one turnover number into cohorts that reveal what's actually driving regrettable attrition, with Copilot checking your reasoning, not writing your conclusion.
- Band positioning, a merit matrix, and a pay-equity check ahead of the EU Pay Transparency Directive, all built with Copilot at scale.
- Turn a column of open-ended survey feedback into themes and sentiment with Excel text insights, with privacy thresholds built in.
- Assemble four workbooks into one leadership-ready pack with Claude Code, then save the playbook so next month takes ten minutes.
What's inside
- 1People Analytics with Excel + AI: Start Here
The export-transform-report loop every HR team runs, and where Copilot and Claude cut it down to an afternoon.
- 2Headcount & Org Reporting
One HRIS export becomes your first clean headcount bridge in 20 minutes, in a workbook you reuse every month.
- 3Attrition & Retention Analysis
Split one turnover number into cohorts that reveal what's actually driving regrettable attrition, with Copilot checking your reasoning, not writing your conclusion.
- 4The Comp Review Cycle
Band positioning, a merit matrix, and a pay-equity check ahead of the EU Pay Transparency Directive, all built with Copilot at scale.
- 5Make Sense of Survey Comments
Turn a column of open-ended survey feedback into themes and sentiment with Excel text insights, with privacy thresholds built in.
- 6The Monthly People Dashboard
Assemble four workbooks into one leadership-ready pack with Claude Code, then save the playbook so next month takes ten minutes.
Earn a certificate
Complete all chapters to receive your certificate of completion.