XLOOKUP Courses and Certifications

ExcelIsFun

Excel 365 for Teaching: Dynamic Arrays, XLOOKUP, Power Query and PivotTables

Streamline teaching tasks with Excel 365: master dynamic arrays, XLOOKUP, Power Query, and PivotTables for efficient gradebooks, budgets, and data analysis.

• YouTube
• 52 minutes
• Self-Paced
• Free Video

Excel Tables and Formulas: SUMIF, XLOOKUP and GROUPBY

3952 ratings at Udemy

Build Excel tables and write SUMIF, date, text and XLOOKUP formulas - and stop rebuilding reports by hand

• Udemy
• 4 hours 28 minutes
• Self-Paced
• Paid Course

ExcelIsFun

Fixing N/A Errors in XLOOKUP and VLOOKUP - Hidden Characters Problem

Master troubleshooting techniques for #N/A errors in Excel lookups by identifying and fixing hidden characters using functions like CODE, CHAR, REGEXREPLACE, and advanced formulas.

• YouTube
• 17 minutes
• Self-Paced
• Free Video

Intermediate Excel for Business (Live Online)

749 ratings at CourseHorse

Bring your Excel skills past the basics through hands-on projects in this Intermediate Excel course.

• CourseHorse
• 7 hours
• Self-Paced
• $299.00

Master NEW Excel Functions in Office 365 & Office 2021+

5246 ratings at Udemy

Complete guide to dynamic arrays, spill behavior, and the new calculation engine in Microsoft 365

• Udemy
• 7 hours 7 minutes
• Self-Paced
• Paid Course

Coursera

Excel for Beginners: Advanced Functions

77 ratings at Coursera

Build advanced spreadsheet formulas in Excel on the Web: conditional functions countif, sumif and averageif, plus lookup functions vlookup, xlookup and index & match.

• Coursera
• 1 hour 59 minutes
• Self-Paced
• Paid Course

Mastering Excel Essentials to Enhance Business Value

37 ratings at Coursera

Build professional Excel workbooks: navigate the Ribbon, apply IF, SUMIFS and XLOOKUP functions, clean large datasets, and design charts, conditional formatting and interactive dashboards.

• Coursera
• 4 weeks, 12 hours a week
• Self-Paced
• Paid Course

Excel Advanced 2: Advanced Formulas (Live Online)

33 ratings at CourseHorse

Take your Excel skills to the next level and master complex formulas with Accelerate Computer Training's advanced Excel course.

• CourseHorse
• 3 hours
• Self-Paced
• $149.00

Packt

Excel Analysis: Formulas, Functions, and Data Visualization

Build dynamic Excel analyses with nested formulas, lookups, and Office 365 functions that clean, reshape, and visualize complex datasets.

• Coursera
• 14 weeks, 1 hour a week
• Self-Paced
• Paid Course

ExcelIsFun

Excel 365 and Power BI Intermediate to Advanced - Calculations and Data Analysis

Master advanced Excel 365 and Power BI with comprehensive training covering formulas, data analysis, Power Query, DAX, and dashboard creation from MVP instructor Mike Girvin.

• YouTube
• 1 day 2 hours 19 minutes
• Self-Paced
• Free Video

Technology for Teachers and Students

Intermediate Excel Skills, Tips, and Tricks

Master intermediate Excel techniques including pivot tables, macros, conditional formatting, data analysis, and advanced functions to boost productivity and efficiency.

• YouTube
• 16 hours 24 minutes
• Self-Paced
• Free Video

Excel Formulas and Functions You Should Know

A compact Excel guide to matching and retrieving data with VLOOKUP, XLOOKUP, and HLOOKUP, including exact, approximate, and partial matches.

• freeCodeCamp
• 1 hour 13 minutes
• Self-Paced
• Free Video

Learnit Training

Excel for HR Full Course

1 rating

Master Excel for HR data management, cleaning, visualization, and analysis with XLOOKUP, dashboards, and advanced functions tailored for human resources professionals.

• YouTube
• 4 hours 8 minutes
• Self-Paced
• Free Video

Simon Sez IT

Microsoft Excel Advanced Excel Training Course

1 rating

Advanced Excel training centered on dynamic arrays, flexible XLOOKUP/XMATCH lookups, filtering, and statistical formulas with hands-on exercises.

• YouTube
• 3 hours 44 minutes
• Self-Paced
• Free Video

Kevin Stratvert

Excel for Beginners

Master Excel fundamentals in 2+ hours: interface navigation, data entry, formulas, functions, charts, pivot tables, and collaboration features for strong analytical skills.

• YouTube
• 2 hours 10 minutes
• Self-Paced
• Free Video