Excel created pivot tables to improve upon its convoluted, weak reporting features (which are still available). The pivot table is actually a collection of tools that Excel uses to help you create ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

Quip, a startup with mobile apps for crafting and collaborating on documents, has turned on some useful capabilities when it comes to working with spreadsheets. Now you can click a couple of buttons ...

This is a proof of concept that I put together out of curiosity today, and it’ll likely break for some documents or Microsoft Excel, but it’s been working well for me, and I thought I’d share it.

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

Change Excel 2007 spreadsheets to tables for easier data analysis Your email has been sent Excel spreadsheets may be good for calculations, but reading them can be challenging. Here's how to convert ...

Google Fusion Tables is a great tool to map (and chart) data easily. But one of its drawbacks is the difficulty in updating the data tables that power your map. Unless you’re very comfortable ...

Posts from this topic will be added to your daily email digest and your homepage feed. is a senior correspondent and author of Notepad, who has been covering all things Microsoft, PC, and tech for ...