Create a Vlookup in Excel

Many people have heard about Excel’s VLOOKUP and HLOOKUP functions but have unsuccessfully used them. This Vlookup tutorial will solve any confusion you have about using either of these lookup functions and provide you with some tips to master these like a pro. The VLookup and Hlookup function are fantastic time-savers. They are a perfect […]
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 term “dynamically” means that if any data in the original location changes, our Concatenate function […]