Free Online Microsoft Training

Free tips and tricks for using Microsoft Office and Windows

Create a Vlookup in Excel

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

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 […]