Excel Lookups: VLOOKUP Alternative — Power Query (ACVQ)


'
Discussion Leader
Jeff Lenning

Registering...
{{ successMessage }}
{{ errorMessage }}


Excel Lookups: VLOOKUP Alternative — Power Query (ACVQ)

Customer Rating

Field of Study

Technology

Level

Basic

Credits

1

Qualifies For

CPE

Overview

Believe it or not, Power Query provides a compelling alternative to VLOOKUP. In this webinar, we’ll explore how to use Power Query to accomplish tasks typically performed with VLOOKUP. Plus, we’ll see how Power Query even supports multi-column lookups.

Major Topics

  • VLOOKUP function arguments
  • Power Query introduction
  • How to perform lookups using Power Query

Learning Objectives

  • Recall the arguments of VLOOKUP
  • State the process for using Power Query to perform lookups
  • Identify the steps to perform multi-column lookups

Designed For

Groups learning about computer software and applications

Prerequisite

None

Advanced Preparation

None


'
Discussion Leader
Jeff Lenning

Registering...
{{ successMessage }}
{{ errorMessage }}