Excel's VLOOKUP, XLOOKUP, MATCH & INDEX | Over 20 Functions
What you'll learn
- Efficiently combine data across tables
- Quickly compare data across tables
- Deep dive into the New XLOOKUP Function (Office 365 and Excel Online only)
- Perform lookups across different sheets and workbooks
- Lookup data based on multiple criteria
- Lookup a complete record
- Lookup duplicates
- Effectively prepare data for lookup using Text Functions
Requirements
- Students will need a copy of Excel version 2007 or later
- For the XLOOKUP section students will require Office 365 or Excel Online
Description
This course will teach you how to use lookup functions in Excel. Lookup functions are used frequently to compare and combine data. In our experience as workplace IT trainers, lookups are the most frequently requested training topic. Each lecture includes 2 sample Excel files: one for you to complete and one that has the solution already supplied.
What Do Lookups Do?
Lookups allow you to search for a value in one column and return the corresponding value in another column – for example search for a name to return a telephone number.
Lookups allow you to combine data from several tables so that all the information is one place.
Lookups allow you to compare date – for example sales of a product across three different stores or across three years.
Why Learn About Lookups?
I have 20 years experience of teaching Excel in the workplace across hundreds of different companies and lookup is the number one requested topic.
You need to be competent in lookup formulas to have any credibility as an Excel professional.
Companies are increasingly using Excel to manage huge amounts of data and lookup formulas are one of the skills you definitely need if you want to be able to contribute.
This Course Covers the Following Excel Functions
VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, IFERROR, ISNA, IFNA, LEFT, RIGHT, MID, FIND, SEARCH, LEN, SUBSTITUTE, REPLACE, TRIM, CLEAN & INDIRECT.
It Also Covers...
The Intersection operator
Concatenation
Creating drop down lists
PivotTable creation
Naming ranges
Converting ranges to Excel tables
****Now updated to include the new XLOOKUP Function***
For Office 365 or Excel Online users, this course now covers the new XLOOKUP function.
Who this course is for:
- This course is suitable for students who need to fast track their lookup skills. No previous knowledge of lookup functions is required but a grasp of basic Excel concepts is.
Course content
- Preview01:04
Instructor
![Chester Tugwell](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 24 Reviews
- 1,045 Students
- 2 Courses
I am a self-employed software trainer with over 25 years' experience in a commercial and public sector context. I have run MS Office courses in literally hundreds of companies, providing tailored training made relevant to the workplace.
I am also a Microsoft Office tips and tricks YouTuber, covering Excel, Word, PowerPoint, Access and Visio.