Free Online Microsoft Training

Free tips and tricks for using Microsoft Office and Windows

How to create a Vlookup in Excel

How to create a Vlookup in Excel

Are you wondering how to create a Vlookup in Excel? The Vlookup function in Excel is one of those very popular functions but sometimes can be a little tricky to master. The Excel Vlookup function is a fantastic time-saver. It is a perfect example of how Excel can “do the work for you”. This Vlookup […]

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 term “dynamically” means that if any data in the original location changes, our Concatenate function […]