Turns out half my old formulas were just dynamic arrays in disguise, written the long way.

Excel can feel like a maze of endless rows, columns, and formulas, especially when you’re trying to create something as detailed as a loan repayment report. If you’ve ever found yourself overwhelmed ...

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