Excel functions for HR
People data is lists of staff with departments, dates and scores. These functions help you count headcount, apply rules and look up details.
Typical jobs
- Count staff by department or status
- Apply eligibility rules that need two things to be true
- Average review scores
- Look up an employee's details from their ID
9 functions to learn
SUMBeginner
Add up a column or range of numbers
6 lessons · 1 freeLearn it
AVERAGEBeginner
Find the typical value in a set of numbers
6 lessons · 1 freeLearn it
COUNTBeginner
Count how many cells contain numbers
5 lessons · 1 freeLearn it
COUNTIFIntermediate
Count rows that meet a condition
6 lessons · 1 freeLearn it
COUNTIFSIntermediate
Count rows that meet several conditions
5 lessons · 1 freeLearn it
IFIntermediate
Show one result or another based on a test
6 lessons · 1 freeLearn it
Nested IFIntermediate
Choose between three or more outcomes
5 lessons · 1 freeLearn it
AND / ORIntermediate
Combine several tests inside IF
5 lessons · 1 freeLearn it
VLOOKUPIntermediate
Find a value in a table by its ID
6 lessons · 1 freeLearn it