Released for Office 365 recently, the new LET function brings clarity and transparency to spreadsheets by assigning names to the results of calculations.
XLOOKUP brings numerous improvements over VLOOKUP: Returning values without regard to column relative position, predictable error handling and the ability to return an array of results.
SEQUENCE provides the ability to create dynamic sequences of numbers or dates. This function is helpful with setting up amortization tables or forecasting models. It can even be used at the core of a dynamic calendar.
One of the most useful dynamic array functions, UNIQUE returns a list of unique values from a longer list. Used in combination with SORT and FILTER, it is useful in a wide variety of situaitons.
SORT does exactly what its name suggests. However, because it updates automatically, it is often a superior choice than a pivot table.
FILTER is used to return a subset from a larger set of data based on specific criteria.
An intro to the new functions and capabilities of Excel’s updated calculation engine.