Daniel T Li Spreadsheets Better File

The firm used a 50MB Excel file. It crashed twice a day. Three analysts spent 15 hours a week reconciling inventory because the master sheet used volatile functions ( OFFSET , INDIRECT ) that recalculated every time you scrolled.

For decades, the spreadsheet has been the unsung workhorse of the global economy. Whether you are in Excel, Google Sheets, or a niche platform like Airtable, the core mechanics have remained surprisingly static since the 1980s: a grid of cells, formulas beginning with an equals sign, and the eternal struggle of manual data cleaning.

Instead of hardcoding labels or constants, Li advocates for dynamic named ranges and what he calls "Semantic Arrays." For example, instead of =SUM(A1:A100) , he would write =SUM(Filter(Transactions, Month = "March")) .