Overview A concise review of newer Excel functions from Microsoft, demonstrating how to use them and when they’re useful.

A vendor export landed in my inbox with phone numbers in four different formats, customer names stored last-first, and order IDs, where five of twelve rows broke the house format. I'd already swapped ...