Unlike one-off tools, Column From Examples records transformation steps so results remain stable as new data is added.

Automate repetitive data entry and fix broken sorting hierarchies using Excel's powerful, hidden Custom Lists tool.

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