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

Source: https://spreadsheetpractice.com/excel-test/hr-analyst · Updated October 29, 2026

## What employers usually test

| Skill | Functions | Practice |
|---|---|---|
| Headcount by group | COUNTIF, COUNTIFS | [Lesson 7: COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif) (free) |
| Eligibility rules | IF, AND, OR | [Lesson 6: AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs) (free) |
| Cleaning records | TRIM, PROPER | [Lesson 20: Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-data) (Pro) |
| Contract and review dates | EDATE, EOMONTH | [Lesson 24: EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays) (Pro) |
| Unique lists | UNIQUE, SORT | [Lesson 26: UNIQUE & SORT](https://spreadsheetpractice.com/learn/unique-sort) (Pro) |
| Spotting duplicates | COUNTIF | [Lesson 43: Duplicates & reconciliation](https://spreadsheetpractice.com/learn/duplicates-reconciliation-checks) (Pro) |

## A sample task

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

From [AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs). Solve it, graded instantly, at [the hr analyst test page](https://spreadsheetpractice.com/excel-test/hr-analyst).

## A 14-day prep plan

About 30 minutes a day.

| Day | Focus | Access |
|---|---|---|
| 1 | [SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count) | Free |
| 2 | [Relative vs absolute references](https://spreadsheetpractice.com/learn/relative-absolute-references) | Free |
| 3 | [The IF function](https://spreadsheetpractice.com/learn/if-function) | Free |
| 4 | [AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs) | Free |
| 5 | [COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif) | Free |
| 6 | [COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) | Free |
| 7 | [XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) | Pro |
| 8 | [Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-data) | Pro |
| 9 | [DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text) | Pro |
| 10 | [EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays) | Pro |
| 11 | [UNIQUE & SORT](https://spreadsheetpractice.com/learn/unique-sort) | Pro |
| 12 | [Duplicates & reconciliation](https://spreadsheetpractice.com/learn/duplicates-reconciliation-checks) | Pro |
| 13 | [Timed run: the analyst interview capstone](https://spreadsheetpractice.com/learn/capstone-analyst-interview) | Pro |
| 14 | [Retake the skills test and compare](https://spreadsheetpractice.com/excel-skills-test) | Free |

## 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

- [Financial analyst](https://spreadsheetpractice.com/excel-test/financial-analyst)
- [Accountant](https://spreadsheetpractice.com/excel-test/accountant)
- [Administrative assistant](https://spreadsheetpractice.com/excel-test/administrative-assistant)
- [Data analyst](https://spreadsheetpractice.com/excel-test/data-analyst)
- [Operations analyst](https://spreadsheetpractice.com/excel-test/operations-analyst)
- [Marketing analyst](https://spreadsheetpractice.com/excel-test/marketing-analyst)
- [Sales analyst](https://spreadsheetpractice.com/excel-test/sales-analyst)
- [Project manager](https://spreadsheetpractice.com/excel-test/project-manager)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
