MS Excel Data Cross Referencing using VLOOKUP and HLOOKUP

Mastering the use of LOOKUP'S will allow you to manipulate, extract and distribute information like never before!

JOIN MY COMMUNITY OF OVER 14,000 STUDENTS AND LEARN AMAZING TECHNIQUES, TIPS, TRICKS AND SECRETS THAT I’VE ACCUMULATED OVER 15 YEARS OF ACADEMIC AND PROFESSIONAL TRAINING!
-------------------------------------------
Created: 25 February 2015
Last Updated: 25 February 2015
--------------------------------------------
Course Description
When you reach the stage where tables are getting larger and becoming more difficult to sift through, it is time to upgrade your tool set. The use of Lookup's is absolutely essential for the user trying to extract information from long rows or columns of data. This means, that for large or complex sets of data, especially recurring data, one formula can organise/calculate different types of information in one go.
Too many times I see people manually searching for what they need for hours rather than simply creating a Lookup formula. Stop wasting your time doing manual searching. Learn this simple function and make your life easier.
In this course, I'll teach you everything from the internal structure of the formula, to linking it between columns to even creating your own search engine.
And you'll learn all this in around 30 minutes!!
--------------------------------------------
About The Instructor

1. Academically and Professionally trained Aerospace Engineer
2. My courses have helped +14,000 students
3. Over 400 Reviews
4. Average of 5 reviews per day
5. Over 16 Live courses.....AND COUNTING
6. 15 Years of Microsoft Office Experience

--------------------------------------------
Course Details

1. This course has the shortest and simplest tutorial video’s you will ever see! Clear, concise and to the point!
2. It is designed for all levels
3. I’ve intentionally made the video’s around 2 minutes or less so that you get your information instantly. NO MORE USELESS CHATTER!!
4. FULL AND FREE LIFETIME ACCESS
5. All future lectures, videos, documents and upgrades included FREE

--------------------------------------------
What Udemy has said about me and my courses
'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust!'
--------------------------------------------
Enrol Now and Experience the Benefits

1. I’ll show you step-by-step, I’ll explain and highlight every single button I press, I’ll draw around important area’s and icons with on-screen drawing tools, I’ll zoom into small and hard to see area’s so you don’t miss a single thing!
2. With over 15 years of experience using Microsoft Excel, I’ll let you look over my shoulder as I teach you the fundamentals.
3. I’ll show you exactly how to master this technique in a fraction of the time it takes the average person to learn on their own from books, YouTube videos, blogs and forums!
4. By mastering this technique you’ll become the most productive and most efficient person at your job and at home!
5. New doors and opportunities will begin opening up for you personally and professional with each new technique you acquire!

Click the “TAKE THIS COURSE” button, top right, NOW!!...every hour you delay you're missing out on huge opportunities!!

Get this Udemy Course for Free