Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

From competitive spreadsheeting to office-skill tournaments, everyday tasks are being gamified. Is this playful innovation, cultural burnout — or both? Maths, math or mathematics, depending on where ...

Have you ever opened an Excel file and felt a pang of unease? Rows upon rows of data, cryptic formulas sprawled across cells, and a tangle of manual formatting that seems one misstep away from chaos.

Wouldn’t it be great if you could be an Excel wizard without putting in all the time and effort needed to learn how to get around Excel and make it do what you want it to do? Formulas are one of the ...

If you have multiple pivot tables in the table and try to export to pivoted excel one of them, no matter what you choose it exports the first table.

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

Have you ever felt like your Excel skills hit a ceiling, no matter how many pivot tables you create? You’re not alone. While standard pivot tables are a reliable tool for summarizing data, they often ...