As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ...

The improvement comes from Xlookup's ability to search horizontally and vertically, whereas the old Vlookup could only go vertical (there was a separate Hlookup for horizontal search). What all these ...