Excel has quietly gained dynamic arrays, XLOOKUP, Power Query, and Python, yet many still work the old way.
Got a confidential news tip? We want to hear from you. Sign up for free newsletters and get more CNBC delivered to your inbox Get this delivered to your inbox, and ...