Microsoft isn't trying to confuse you—Excel's three ranking functions balance flexibility, compatibility, and tie handling.

Excel in 2026 is more than just formulas—it’s a powerhouse for automation, data transformation, and real-time insights. With tools like Office Scripts, Power Query, and modern dynamic formulas, you ...

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