Curso · 6 capítulos
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.
O que você vai saber fazer
- The export-transform-report loop every HR team runs, and where Copilot and Claude cut it down to an afternoon.
- 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, merit matrices, and the equity check, done in Excel with Copilot instead of a spreadsheet marathon.
- Turning a column of open-ended feedback into themes and sentiment with Copilot's text insights, right inside Excel.
- Assembling four workbooks into one reusable pack with Claude Code, so month two takes ten minutes instead of a full day.
O que tem dentro
- 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, merit matrices, and the equity check, done in Excel with Copilot instead of a spreadsheet marathon.
- 5Make Sense of Survey Comments
Turning a column of open-ended feedback into themes and sentiment with Copilot's text insights, right inside Excel.
- 6The Monthly People Dashboard
Assembling four workbooks into one reusable pack with Claude Code, so month two takes ten minutes instead of a full day.
Ganhe um certificado
Conclua todos os capítulos para receber seu certificado de conclusão.