In this 30 minute course, you will learn how to write simple, effective vlookup formulas, turning those headache inducing, hours long admin tasks into a 5 minute breeze

Just started a role in data analysis or finance and don't know how to do a vlookup formula? Don't worry you're just 30 minutes away from remedying that and wowing your teammates

This course will take you through the theory, the construction of the formula, the jargon, and the common pitfalls of writing a vlookup formula. With hands on exercises and a "follow along with me" style structure, you'll be writing your own vlookups with ease after just 30 minutes

Course structure:

The purpose behind the vlookup formula

How the vlookup formula is constructed, including the jargon Excel uses, and what this translates to in real life situations

Writing vlookup formulas, a step by step guide to how to write the vlookup formula, reinforced with multiple examples, exercises, and the "follow along with me" style lectures

The importance of unique identifiers in data. This is an often overlooked part of vlookup formulas and good data structure in general. We go through what happens when there is not a unique identifier to link the 2 data sets together and how to fix this

Troubleshooting vlookup formulas. Sometimes mistakes are made, or you receive a file from someone else which contains errors. We go though the common errors made when using vlookups, from formatting issues to using absolute referencing

Interaction:

The lectures and exercises are designed to be all that you need, however not everyone learns the same way. If there is anything which is not clear from the lectures, or you have a query on a particular vlookup you're working on then my inbox is always open. If the problem can't be solved through email, then Zoom, Teams, Skype etc can be used to go through the issue on a one to one basis