HR and people analyst Excel test: what to practice
People analytics screens use headcount tables: count by department, flag eligibility, clean names and emails, and work out contract and review dates. Accuracy and clean formulas matter more than clever ones.
What employers usually test
Take the hr analyst timed test
Five tasks in a live grid, easiest first. Graded instantly, with a lesson for every gap.
- 5 tasks in a live grid, easiest first. Graded the moment you submit
- About 10 minutes. Skip anything you don't know
- Your level and the exact lessons for your gaps, right away. No signup
- Aced it? Keep going with a bonus round of harder, interview-style tasks
Try a sample task
From lesson 6, AND, OR & IFS. Graded instantly.
Promotion eligibility
D2, show Yes if the rating is at least 4 and tenure is at least 2 years, otherwise No. Fill down to D7.Your 14-day prep plan
About 30 minutes a day. Free lessons first; Pro lessons are marked.
| Day | Focus | Access | Time |
|---|---|---|---|
| 1 | SUM, AVERAGE, MIN, MAX & COUNT | Free | 22 min |
| 2 | Relative vs absolute references | Free | 24 min |
| 3 | The IF function | Free | 22 min |
| 4 | AND, OR & IFS | Free | 24 min |
| 5 | COUNTIF & SUMIF | Free | 23 min |
| 6 | COUNTIFS, SUMIFS & AVERAGEIFS | Free | 25 min |
| 7 | XLOOKUP | Pro | 24 min |
| 8 | Cleaning messy data | Pro | 23 min |
| 9 | DATE, YEAR, MONTH & TEXT | Pro | 23 min |
| 10 | EDATE, EOMONTH & NETWORKDAYS | Pro | 24 min |
| 11 | UNIQUE & SORT | Pro | 24 min |
| 12 | Duplicates & reconciliation | Pro | 26 min |
| 13 | Timed run: the analyst interview capstone | Pro | 20 min |
| 14 | Retake the skills test and compare | Free | 10 min |
Questions
Is HR data really tested in Excel?
Yes. HR operations and people analytics roles often get a small headcount table and a few timed questions.
Which functions come up most?
COUNTIFS for headcount, IF with AND/OR for eligibility, and date functions for tenure and renewals.
How long should I prepare?
About two weeks at 30 minutes a day.
Prep for other roles
Updated Checked by running: every exercise answer on this page was graded by our formula engine on .