Everyday I am amazed by the lack of Excel literacy in the office, particularly with the increasing focus on data within the HR space. With some Excel basics, and some raw data, you too can become a HR Data Kingpin.
Here are the absolute basic formulas that you need:
- VLookUp / HLookUp
- IF statements
- Ampersand for combining cells
- Absolute cell referencing
If any of these sound unfamiliar, please stay tuned over the next few weeks I’m going to produce video’s for each of these, within the context of how we would use these formulas in our HR roles. Trust me, knowing these formulas have won me many roles within HR, and with a little bit of effort on your part they can very easily become part of your knowledge base.