In this microlearning module we look at the powerful VLOOKUP function in Excel. You may have heard of VLOOKUP but not know exactly what it is. It’s a really versatile function which can look up and pull out key pieces of data and information from large lists. In this module we use the best example we could think of to explain it – pizza!
– Understand the principles of VLOOKUP;
– Use VLOOKUP in Excel to manipulate data quickly.
Module Length: 5 minutes