Coffee Break Learning - The VLOOKUP Function Premium class
- 1x (Normal)
Vlookup Function Explained11:16
Using Vlookup for an Approximate Lookup5:13
About This Class
Welcome to another episode in the Coffee Break Learning series. Bite-sized learning that can be achieved over a short coffee break.
The VLOOKUP function is Excel's most well-known lookup function. It is often misunderstood and causes problems for Excel users.
This function is heavily used in business. It is often found linking data between sheets, comparing two lists or speeding up date entry and accuracy through lookup tables.
In this class VLOOKUP is explained inside-out. Two examples are demonstrated to get a feel for why this function is so important.
The Excel files used during the class are provided so that you can follow along. You can then take on the project exercises to test your skills in action.
Please post any questions, queries in the discussion area and I will get back to you.
Hello, my name is Alan Murray and I have been training and consulting in Excel now for over 17 years. I have had the pleasure in helping individuals and businesses from all around the world improve their Excel skills.
I set up Computergaga about 8 years ago to help spread the latest Excel tips and to engage with other Excel experts and learners. It has grown beyond my expectations and I hope to get the chance to speak with many of you soon.
I have a real passion for Excel and I hope that it comes across in my classes. I believe that it helps if you enjoy what you are learning.
I currently live in Ipswich, on the east coast of England. I am married with two beautiful children. So they take up most of my time away from Excel. If I'm not with my family or Excel, I can probably be found running.
View the latest FREE Excel Tips >>
Speak to you soon. Have fun learning.