Not sure about Word or other apps, but in Excel there are many useful functions added in the later versions like XLOOKUP, LAMBDA, LET, FILTER, MAP, REDUCE, GROUPBY.