Time saver tip – Custom Views in Excel

There is a nagging challenge that my team and I have encountered for a long time, and I’m sure all HR and Compensation pros have faced the same. You see, we build files with confidential information about all our employees, such as their package, performance ratings, promotion potential etc. We then share partial views of…

Use the Left or Right function in Excel to extract text from a cell

The Left and Right functions are very useful for managing text in Excel files. Let’s imagine you have text in a field and you want to retrieve from it only the characters on the left. To give you an idea, the field has grades which are composed of 2 digits indicating the level of the…

All you need to know : from compensation surveys to salary ranges and salary review

Frances, one of my readers, recently commented to me as follows : I have to create salary ranges and compare the current salary to market data. This will allow me to make the determination if the person’s pay is within the acceptable range. Year-end is approaching and I am starting to get more questions around…

Compensation Geek, hero of the Recruitment team !

Imagine the situation : your colleague in Recruitment is looking to prepare the package offer for a candidate. This candidate is already working in the same GCC country as your company, but their pay is composed differently than yours. Their current package is composed of basic and a single living allowance, as well as a sales…

Mid-year review : the best of Compensation Insider

This post is dedicated to my readers, old and new. In the past 6 months, the number of people reading Compensation Insider has grown from 12-15 per day to about 100 per day. I am very happy and hope to continue to see growth in my readership as I believe in sharing information and points…

Comparing salary ranges? Really?

I was recently approached by a well-meaning Organisation Development specialist working for a governmental organisation. This gentleman emailed me the following : “I have been requested to benchmark our salary grades with other (semi-)government entities. Therefore we are approaching some organizations to see what they can share with us. We are mainly interested in the…

How to create a drop-down list in Excel

In this edition of Sunday Skills, I want to show you how to create a drop-down list in your Excel sheets. This is really useful when you are collecting information from multiple sources and you want to ensure that the data you collect is easy to compile and use for analysis. For example if you…