Description

In the last several years, Microsoft developers have been hard at work introducing powerful and useful new functions, and very few of us have picked up the new skills to match. At one end of the scale, Microsoft created a replacement for VLOOKUP in XLOOKUP, simplifying and making the lookup feature more flexible. On the other end, functions like LET and LAMBDA give us astonishing capabilities that allow us to rethink everything we do in Excel. In this webinar, you'll learn some of the most valuable and dynamic new functions available today.

Topics include:

• Improve lookup flexibility with XLOOKUP and XMATCH
• Leverage dynamic array functions to find data subsets
• Reshape data with stacking and splitting functions
• Create custom functions for your business and job function