BeginnerLogical Functions
Flag reps below target with IF
Use IF to label each rep as meeting or missing their target.
IF
5 min15 points
Excel for HR
HR data is small, sensitive and full of dates — which makes date arithmetic and careful conditional logic the core skills.
What the job actually asks for
Headcount by department, tenure, time-to-hire, turnover rate, salary banding. The datasets rarely run to thousands of rows, but the calculations feed decisions about real people, so being approximately right is not acceptable.
The recurring tasks
- Calculate tenure and time-to-hire
- Summarise headcount by department
- Band salaries and check pay equity
- Track turnover rates by quarter
Where people get caught
Averages that mislead. Mean salary in a small team is dragged badly by one senior figure, and reporting it without the median produces a number that is technically correct and practically wrong.
What interviews test
Calculating tenure from a hire date, counting headcount with several conditions, and knowing when a median tells the truer story than a mean.
Practice built from human resources work
3 exercises using the situations above, ordered from most approachable to hardest.