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

Some of Excel’s most powerful modern features simply do not work inside tables. Dynamic array formulas, often called spill ...

Zoho continues its quest to build the most comprehensive online productivity suite, adding support for macros and pivot tables in its spreadsheet, Zoho Sheet. The new version includes support for ...

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

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

A new no-code spreadsheet with the functionality of a database has just launched, giving users an alternative to the likes of Airtable and Google Tables. JotForm Tables allows users to collect, ...

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.

Is it the end of an era if virtually no one notices? That question seemed relevant last fall when IBM officially ended support for Lotus 1-2-3, which was once the world’s dominant spreadsheet program.

I became a member of II earlier this year and now look forward to receiving/reading your regular e-mails and newsletters. I have been buying/selling (mainly buying) small parcels of share over the ...