Excel - VLookup & HLookup
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
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!Who is the target audience?All Excel users from Beginner to Advanced
Facilities
Location
Start date
Start date
About this course
What are Lookups, their structure and how they work in Excel
How to use Range Names with Lookups
Creating a VLookup and HLookup Formula
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 6 years
Subjects
- MS Excel
- Excel
Course programme
Additional information
Excel - VLookup & HLookup
