Exceljet

Quick, clean, and to the point

Excel tips: functions

These videos come from our accelerated video training.
Tip: How to use VLOOKUP to merge tables
VLOOKUP is a great way to merge data in two tables based on a common ID. This video shows you how in 3 minutes. You can even use this technique to reorder the columns you retrieve.
Run time: 3:10
Tip: How to combine functions in a formula
Combining functions is a core skill you *must* have in order to move beyond the basics in Excel. In this video, we show how to split, manipulate, and reassemble values using multiple...
Run time: 2:53