HR and Compensation pros often receive data from many different sources, and one of the first challenges is often the fact that the names of the employees have been input with spelling mistakes, which makes the use of the information almost impossible. My first comment, as usual, is to use the Employee ID number as…
How do I learn Compensation & Benefits for free ?
December 6, 2012 by 7 Comments
New readers or people who connect with me on LinkedIn frequently ask me what to do in order to learn Compensation & Benefits for free and get a job in the function. If you want to work in C&B your best shot is to change job within your own company. As an HR professional you…
How to make management look into real inflation for salary budgets
December 4, 2012 by 5 Comments
Ayesha joined my readership recently and asked : “I would love to hear some suggestions on what to do when market inflation rates are far higher than what the official sources as well the generally accepted sources like the The Economic Intelligence Unit magazine report… and we have to convince the organization to allocate higher…
2012 – A year of Compensation links for the UAE
December 2, 2012 by 4 Comments
Here is a gift for my readers: one year ago I wrote a piece describing the challenges facing HR and Compensation professionals in the UAE. I have compiled the most relevant articles published since, in order to update you on the latest trends affecting the work environment in the UAE. The information is compiled by…
One day with Dave Ulrich at the IIRME 2012 Middle East HR Summit
November 27, 2012 by 1 Comment
So… My friends from IIRME organised the 2012 Middle East HR Summit and Expo in Dubai last week. It was by far the largest HR event in the Middle East, with a few hundred delegates from all over the region attending the conference. Unfortunately, other commitments prevented me from attending, but 2 of my team members…
Use the Left or Right function in Excel to extract text from a cell
November 25, 2012 by Leave a Comment
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…
