Shopping Cart

Become a Learning.ly Instructor

Preview of Master Lookup Formula and Functions in Excel

Review course syllabus

Free

100% money-back guarantee  |  Click here to read more

Share this course:
Facebook Google LinkedIn Pinterest Twitter

Course Description

This is a free preview (13 minutes) of the Master Lookup Formula and Functions in Excel course. The description of the full course (55 minutes) is provided below.

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

          About the Expert

          Paula Guilfoyle

          Paula Guilfoyle

          Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accounts, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has online courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
          Read more