Spreadsheet Practice

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

SkillFunctionsPractice
Headcount by groupCOUNTIF, COUNTIFSLesson 7 Free
Eligibility rulesIF, AND, ORLesson 6 Free
Cleaning recordsTRIM, PROPERLesson 20 Pro
Contract and review datesEDATE, EOMONTHLesson 24 Pro
Unique listsUNIQUE, SORTLesson 26 Pro
Spotting duplicatesCOUNTIFLesson 43 Pro

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

In 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.

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 .