Manually styled ranges create hidden spreadsheet risks, while structured tables keep data connected and reliable.
Bad spreadsheet habits create hidden data problems that break calculations and make files harder to maintain.
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 ...
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 ...
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 ...
One thing I found especially interesting about Adobe's new Acrobat.com announcements this week (Techmeme coverage here) is its hybrid spreadsheet/database application called Tables. I already ...