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…

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…