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 ...

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 ...