Understanding VLOOKUP and HLOOKUP

In this tutorial of almost 20 minutes, I show you: – Several practical examples of when and how to use the VLookup and HLookup functions – The differences between the 2 functions – The difference between TRUE and FALSE (4th Argument) The video was...

Excel 2013 – Flash Fill

Flash Fill is a new feature in Excel 2013. Flash Fill will save you time. Flash Fill will save you having to write complex formulas in order to extract data from a single column or combine data from several columns. You simply provide an example of what you want it to...