Study Learn Grow
Excel - VLookup & Hlookup

Excel - VLookup & Hlookup


Looking up data is a very useful and powerful tool to have when working in Excel. Unfortunately, there are common myths going around that Lookups are really difficult and only for the super advanced users!

Overview

About this Course
Looking up data is a very useful and powerful tool to have when working in Excel. Unfortunately, there are common myths going around that Lookups are really difficult and only for the super advanced users!

To 'Lookup' something, in a nutshell, means to search a particular value from one spreadsheet or workbook against another particular value that we already know. Think of it like searching for a phone number in a telephone directory.

The VLookup and HLookup functions provide the easiest way to search and locate values from both Columns and Rows. By the end of this course, you'll be able to match customer details to Purchase Orders, retrieve product information from a stock sheet and so much more!

Basic knowledge
Students are only required to have a basic understanding of how rows and columns are referenced in Excel

Course Information

Students are only required to have a basic understanding of how rows and columns are referenced in Excel

What you will learn
What are Lookups, their structure and how they work in Excel
How to use Range Names with Lookups
Creating a VLookup and HLookup Formula

All Excel users from Beginner to Advanced

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs