How to use vlookup in Excel

In today’s Sunday Skills I will cover one of the most useful functions in Excel for the Compensation Manager. Vlookup is like an advanced copy/paste function, which automatically copies for you only the information for data which is present in both files  (the main file and the source file). For example, imagine you are participating…

What is your approach to aging ?

… I’m referring to aging salary survey data, of course 🙂 The big compensation providers are starting to return the results of their 2011 surveys, and now is the time to get started on the analysis of the data. So, a few months ago, you participated to the survey. The data you submitted was dated…

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…

How to use Text to Columns in Excel

The text to column function in Exel lets you “split” a column of organised data into multiple ones. Let’s take the example of participating to a compensation survey. You need to provide employee name, employee title and employee date of birth. The date of birth should be in format YY, ie only 2 digits for…

Compensation surveys – the ultimate buyer checklist

Maybe you are expanding into a new country, or you need complementary information on top of the one you already possess in your markets. So you are considering participating to a compensation survey. Beyond the price and reputation of the provider of compensation data, here is a checklist, in no particular order, of what you…