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 breezeJust 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 teammatesThis 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 minutesCourse structure:The purpose behind the vlookup formulaHow the vlookup formula is constructed, including the jargon Excel uses, and what this translates to in real life situationsWriting 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 lecturesThe 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 thisTroubleshooting 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 referencingInteraction: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