Software - Micro Learning - XLOOKUP with Multiple Criteria in Excel

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

Description

Have you ever needed to quickly find data based on two distinct conditions? This one’s for you. Get the most out of Excel's XLOOKUP function and learn about two-way lookups with multiple criteria. We’ll introduce a scenario involving sales data spread across months, showing how XLOOKUP handles a two-way lookup. We’ll examine named ranges and data validation dropdowns too. We’ll use practical examples to support your learning and enhance your spreadsheet proficiency. Finding the data you need doesn’t have to be a challenge.

Objectives

KEY OBJECTIVES

  • Efficiently perform two-way lookups with XLOOKUP in Excel to optimise spreadsheet navigation

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 - XLOOKUP with Multiple Criteria in Excel
{{ vm.helper.t('courses.scorm') }}
2.
Software - Micro Learning - XLOOKUP with Multiple Criteria in Excel
{{ vm.helper.t('courses.survey') }}
Currently no reviews submitted

Shopping Cart

Your cart is empty