How to use Concatenate in Excel

In the previous instalment of Sunday Skills, I shared how to use Text to Columns in order to “split” columns of information. Today, let me demonstrate the “opposite”, using the Concatenate function in order to “merge” multiple cells, with text and/or numbers, into a single cell. This will be useful if you have a first…

Share the knowledge – September 2011

Once again I want to share with you some of the best articles, news and blog posts that I read during the month. I’m covering general Compensation & Benefits, compensation articles that are more closely linked to the Middle East region, and some general articles that relate to management, leadership, governance or social media. I…

Essential considerations for managing international careers

Today’s question is one that I answered about a year ago from one of my contacts on LinkedIn, who wanted some background information on what to think about when designing their first policy for sending employees abroad. I think there are a number of things that need to be checked when designing this kind of…

Boards and quotas – For or against them ?

There was an excellent blog post from Nilofer Merchant at Harvard Business Review recently, entitled Quotas for women on Boards are wrong. In it, she argues against quotas for women to access company Boards. Some of her arguments are very convincing. In particular, I agree that we should focus on bringing more “board readiness” for…

Calibration of employee ratings – a rigid rule ?

Year-end is approaching fast, and with it comes the time for performance appraisals, which my friend Clare and I were discussing a few days ago. Clare was recently appointed as HR Business Partner and this year will be her first time to support multiple Business Units through the year-end appraisals process. Our discussion focused mostly…

What do you think of the new look and feel of my blog ?

Soooo… Today if you are reading this post on my blog, you can’t miss seeing the change of look and feel to it. If you are reading this by email or in your RSS reader, I really encourage you to go and check my new graphics and let me know what you think in the…

7 steps to compensation programme design – the basics

I am often asked how to go about a new plan design, or a total revamp of an existing one. How should one approach it ? Is there a methodology ? In my mind there are 7 basic steps to take in order to design a good plan in Compensation & Benefits. They apply whether…