It’s the end of the month, and you’re staring at a mountain of Excel spreadsheets that need updating. You sigh, knowing that hours of tedious work lie ahead. But what if I told you there’s a way to ...

Excel table formulas shift from cell positions to named columns with #All-style tags, keeping calculations readable when layouts change.

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...