Community Course

LOOKUP FUNCTIONS

50559AC (Class Pack)
Based on student feedback via 'Metrics that Matter'
LOOKUP FUNCTIONS
This two-day instructor-led 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.
Please contact your Learning Partner in order to take this course
Author: Kompas Xnet

Course Duration: 2 Days

SATV: No

About This Course

This two-day instructor-ledcourse 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.

Audience Profile

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.

At Course Completion

After completing this course, students 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.