50559-A: LOOKUP FUNCTIONS - example by example

Course Modality

Instructor-led (classroom)

Course Level

Intermediate

Course Time

2 days

Course Language

English

Course Overview

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.

Prerequisites

Before attending this course, students must have:

  • Basic knowledge of Excel formulas and functions.

Intended 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.

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

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.

Get In Touch

Course Curriculum

Introducing LOOKUP functions

In this module students are shown a variety of lookup function and examples where lookup functions are needed. The basic knowledge given here is then extended throughout the course. The whole spectrum of functions that are explained in detail in future Modules are introduced here.

Lessons

  • 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

After completing this module, students will be able to:

  • What are we trying to accomplish.
  • Why should we use LOOKUP functions.
  • What LOOKUP functions are at my disposal.
  • Which reference functions should I know.
  • Which Array functions should I know.
  • Recognize the situations where lookup functions are used.

The LOOKUP Functions Basics

In the course of this module, all lookup functions will be introduced step by step. With the knowledge of the syntax, we will examine examples of use and then test our knowledge in Lab 1.

Lessons

  • LOOKUOP function
  • VLOOKUP function
  • HLOOKUP function

Lab : LOOKUP function

Lab : VLOOKUP function

Lab : HLOOKUP function

After completing this module, students will be able to:

  • Recognize a LOOKUP function syntax.
  • Recognize situations when we use the LOOKUP function.
  • List how does LOOKUP differ from other lookup functions.
  • Recognize a VLOOKUP function syntax.
  • Recognize what kinds of examples are solved using VLOOKUP function.
  • List all differences from other lookup functions.
  • Recognize a HLOOKUP function syntax.
  • Tell when to use HLOOKUP.

Advanced LOOKUP examples with function nesting

This module will be instructor led example by example upgrading of lookup functions with other functions and data validation. Each function will be followed by practices. Also array functions and their use will be mentioned.

Lessons

  • 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

After completing this module, students will be able to:

  • Enhance lookup formulas with many new functions and tools.
  • Recognize the need for MATCH function.

Face any situation where lookup functions are required at their daily faceoff with Excel.

Reviews

Get in touch, enquire now!


By submitting this form, I consent to the processing of the personal data that I provide The Data Tech Labs Inc. in accordance with and as described in the Privacy Policy.

© 2020 The Data Tech Labs Inc. All rights reserved.

TDTL-arrow
[glt language="Arabic" label="Arabic" image="yes" text="yes" image_size="24"]
[glt language="English" label="English" image="yes" text="yes" image_size="24"]
[glt language="French" label="French" image="yes" text="yes" image_size="24"]
[glt language="German" label="German" image="yes" text="yes" image_size="24"]
[glt language="Hindi" label="Hindi" image="yes" text="yes" image_size="24"]
[glt language="Marathi" label="Marathi" image="yes" text="yes" image_size="24"]
[glt language="Spanish" label="Spanish" image="yes" text="yes" image_size="24"]

Microsoft Power Platform App Maker

Designing & Implementing Azure AI Solution

Microsoft Azure Administrator

Developing Solutions For Microsoft Azure

Microsoft Azure Architect Design Exam

Implementing Azure Data Solution

Administering Relational Databases On Microsoft Azure