VLOOKUP, MATCH, INDEX, INDIRECT, TRIM Excel Functions & More

Course details

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