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…
Use the Left or Right function in Excel to extract text from a cell
November 25, 2012 by Leave a Comment
The 3 types of employee engagement at high performing companies
November 22, 2012 by 1 Comment
In this 9-minute video from WorkspanTV, Max Caldwell of Towers Watson discusses employee engagement. (RSS readers may have to click through). He starts by defining 3 types of engagement : rational, emotional and motivational and explains how engagement is a predictor of business performance as engaged employees are willing to go the extra mile. He…
All you need to know : from compensation surveys to salary ranges and salary review
November 20, 2012 by 2 Comments
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…
An interpretation of Seth Godin’s “The End of Should”
November 18, 2012 by 2 Comments
Seth Godin’s posts are notoriously short and to the point. The End of Should is a recent one that I thought Compensation and HR professionals could use : Banks should close at 4, books should be 200 pages long, CEOs should go to college, blogs should have comments, businessmen should be men, big deals should…
CEO for a Day at your company ?
November 13, 2012 by 1 Comment
I caught an interview of Essa Al Mulla, Executive Director of the Emirates National Development Programme (ENDP) on Dubai One’s Emirates 24/7 on Sunday. Mr Al Mulla was explaining the importance of the “CEO for a Day” campaign. As part of emiratisation efforts, the ENDP is targeting some Zayed University undergraduates to make them shadow…
Compensation Geek, hero of the Recruitment team !
November 11, 2012 by 2 Comments
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…
An unexpected career change
November 8, 2012 by 4 Comments
I recently celebrated my 2-year anniversary at my current employer, and it made me reflect. I tried to think of the thing I am most proud of in my career so far. Surprisingly, it is not some of the large-scale projects I implemented such as completely revising the salary structures at France Telecom EGT or…
