Whether you're assigning random shifts, anonymizing a study, or shuffling a deck, randomizing rows in an Excel table manually ...

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

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

Studies, including those by spreadsheet researcher Raymond Panko, estimate that up to 90% of all spreadsheets contain at ...

Everyone in Silicon Valley seems to be talking about Airtable, a user-friendly spreadsheet app that makes it super easy to build custom applications — no coding experience required. Airtable has ...

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

When you want to turn that giant spreadsheet into an HTML table without wrangling too many TD's and TR's by hand, you can use a formula to generate the HTML tags for you. The Design Intellection blog ...