Create a Vlookup in Excel

Create a vlookup in Excel

Many people have heard about the Excel vlookup and hvlookup functions but have unsuccessfully attempted to use them. This post is going to solve any confusion you have about using either lookup function. The Lookup Function is a fantastic time-saver. It is a perfect example of how Excel can “do the work for you”. For […]

How to use Concatenate in Excel

How to use Concatenate in Excel

This week I had a request to show how to join text together from different columns in Excel. For this example, the Concatenate function in Excel works perfectly as it allows you to join strings of information together dynamically. The fact that we use a function in Excel to join information means that if any […]