Learn how the new XLOOKUP function can replace VLOOKUP or INDEX MATCH. Plus features for partial matches with wildcards and reverse order lookup. +Video| Excel Campus
Master the Excel FILTER function with this guide, from basic lookups to advanced multi-criteria filtering.| Excel Campus
Get workarounds and solutions for 5 key problems that occur when you use PIVOTBY or GROUPBY instead of Pivot Tables.| Excel Campus
Important: This function is currently in Beta and only available to users on the Beta Channel, which is available through the Microsoft 365 Insider program| support.microsoft.com