Master Lookup Formula and Functions in Excel

Course Description

Click here to access a free preview of the Master Lookup Formula and Functions in Excel  course!

Course Description

Master Lookup Formula and Functions In Excel. A comprehensive course for those that wish to up skill in Excel and Learn advanced lookup formula.

In This Course You Will Learn How Lookup To The Right and the Left, Use Index and Match, Use Combinations of Index, Match and Vlookup, Carry out Lookups with Text And Use The Choose Function.

Do you need to understand and carry out basic or complex lookups in Excel? Then this course is for you!

********************************************************************************************

REGISTER NOW and get Master Lookup Functions and Formula in Excel in no time

*******************************************************************************************

What are the requirements?

• You should have a basic knowledge of Excel

After taking this course, you will be able to:

• Carry out basic V-lookups and H-lookups in Excel
• Use the Index and Match functions in isolation and combined
• Combine V-lookup with Match for a more dynamic formula
• Carry out a lookup to the left
• Use the V-lookup function with Text
• Use the Choose function to lookup values
• Workbooks to download
• Activities to complete

This course is for professionals within the following business functions:

• For those interested in becoming more efficient in your daily Excel and Spreadsheets tasks
• For those that wish to improve their Excel skills and Master Lookup functions\
• These functions work in all versions of Excel

1. Introduction

   1. Course Overview
   2. Example workbook
   3. Pre-Quiz

2.  Master Lookups

   1. Basic VLookups
   2. Index and Match
   3. More Dynamic Vlookup
   4. Lookups to the left
   5. Lookups with Text
   6. The Choose function

3.   Conclusion

   1. Activity Workbook
   2. Course Conclusion
   3. Final Quiz