Would you mind writing down some of the exciting new Excel features? I am asking as an Excel user that 5 years ago used to love this tool (so much so that I would have paid for Excel if my employers did not provide it for free). Excel 2010 was peak Excel for me.
PS. Nobody I know uses Excel's Turing-complete Lambda-calculus. None of my former colleagues in Accounts Receivable, Fixed Assets, Investor Relations, FP&A use it.
XLOOKUP, XMATCH, dynamic arrays and related functions. There are also new regex functions, but it seems that those didn’t make the cut for Excel 2024, unfortunately. I had situations in the past where lambdas would have been handy.
PS. Nobody I know uses Excel's Turing-complete Lambda-calculus. None of my former colleagues in Accounts Receivable, Fixed Assets, Investor Relations, FP&A use it.