Power users rely on these lesser-known Excel shortcuts to work faster across large datasets, formulas, and worksheets.

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

Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.