Software - Micro Learning - Lookups with Duplicates in Excel

Content
2 modules
Difficulty
Basic
Rating
Course Length
15 mins
Instructor
Pantry of Knowledge

Description

A standard VLOOKUP has its limitations. XLOOKUP offers additional search options but fails to provide the desired result. This lesson presents a familiar scenario involving a table with employee names, departments, and countries of residence, showcasing the complexity of traditional lookup functions when faced with duplicates. By combining multiple pieces of information, such as employee names and departments, we create a unique identifier for each record. Using this approach with XLOOKUP, we successfully achieve accurate lookups – highlighting the importance of finding unique identifiers when dealing with duplicate values in your data sets. Join us in mastering this essential skill for effective data management!

Objectives

KEY OBJECTIVES

  • Perform accurate lookups in tables with duplicate values by creating unique identifiers – ensuring precision in data retrieval and management

Certificate

By completing/passing this course, you will attain the certificate POK Software Skills Certificate

Learning Credits

CEU
0.25

Badges

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value') }}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved_for_selected_score_and_over')}}

{{ vm.percentage_badges[vm.selected_badge].greater_than_or_equal }}%

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value')}}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved') }}

{{ vm.helper.t('lup.gamification.learning_awards.on_course_completion') }}
1.
Software - Micro Learning - Lookups with Duplicates in Excel
{{ vm.helper.t('courses.scorm') }}
2.
Software - Micro Learning - Lookups with Duplicates in Excel
{{ vm.helper.t('courses.survey') }}
 
Added 2 months ago, by Tricia

Shopping Cart

Your cart is empty