50559-A: LOOKUP FUNCTIONS Certification Training Course Overview

Enroll for the 2-days Course 50559-A: LOOKUP FUNCTIONS training and certification course from Koenig solutions accredited by Microsoft.

This course provides students with the knowledge and skills to write basic Excel lookup formulas as well as in depth nesting of advanced array and reference functions. The purpose of the course is not only to show that certain functions exist and how they look like, but to show the diversity and usefulness of those functions. This is a very hands-on approach with constant examples, practices and problem solving provided to the audience.


This course is intended for both novice and experienced information worker who have the understanding and knowledge of basic Excel formulas and functions. A minimum one-year experience with Excel is recommended before attending.

Learning Objectives

Upon completion of this course, participants will be able to:

  • List LOOKUP function in Excel.
  • Recognize the opportunities for LOOKUP function use.
  • Decide which lookup function is best in the given scenario.
  • Always keep in mind a wide range of functions and have the ability to combine their use.

50559-A: LOOKUP FUNCTIONS (Duration : 16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 850
22 - 23 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 950
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Introducing LOOKUP functions
  • Example by using the IF function
  • Which LOOKUP functions are at our disposal
  • Other functions we will use during this course
  • What knowledge should we possess before moving on
Module 2: The LOOKUP Functions Basics
  • LOOKUP function
  • VLOOKUP function
  • HLOOKUP function
Module 3: Advanced LOOKUP examples with function nesting
  • MATCH function
  • How can we use MATCH with VLOOKUP
  • INDEX function
  • Combining MATCH and INDEX functions
  • INDIRECT function
  • CHOOSE function
  • CELL function
  • OFFSET function
  • ROW and COLUMN functions
Download Course Contents

Request More Information

Course Prerequisites

Before attending this course, students must have:

  • Basic knowledge of Excel formulas and functions.