Over the last five years, Microsoft has introduced functions to handle problems that have plagued professionals for decades. If you have a Microsoft 365 subscription, you have access to a set of dynamic array functions that can add real functionality to your workbooks, and simplify your daily efforts.

Topics include:

• Replacing VLOOKUP and INDEX / MATCH with XLOOKUP
• Using the FILTER function to generate subsets of data
• Cleaning problematic data in seconds
• Creating custom functions for your daily efforts