How-To Geek on MSN

Excel finally fixed its worst problems—but you're still using the old workarounds

Excel has quietly gained dynamic arrays, XLOOKUP, Power Query, and Python, yet many still work the old way.