Excel basics for Human Resource Practitioners

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
  • CountIF
  • Sum
  • IF statements
  • IFERROR
  • 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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s