Daniel T Li: Spreadsheets Better Best

In an era of increasingly complex 3D modeling and black-box software, there is a quiet revolution happening at the intersection of traditional engineering rigor and digital efficiency. For structural engineers, the name , and his platform, Engineering International , represent a shift toward transparent, accessible, and high-utility design tools.

Daniel cracked his knuckles. The sound was like a gunshot in the quiet room. daniel t li spreadsheets better

What is the or business context you are writing for? Are you focusing on Google Sheets or Microsoft Excel ? In an era of increasingly complex 3D modeling

Tools for everything from retaining walls to deep beam design. The sound was like a gunshot in the quiet room

He imported the messy data into Power Query. He wrote a custom M-code script to strip the noise. He used Text.Remove to delete the non-numeric characters that were clogging the arteries of the dataset. He applied a Left Join to reconcile the missing transaction IDs from the backup server.

Spreadsheets are better because they adapt to you, rather than forcing you to adapt to them. By mastering the grid and applying strict organizational principles, your business can move faster, spend less, and maintain total control over its data.

In 2024 and 2025, Li became the unofficial evangelist for Excel’s LAMBDA function and Google Sheets' LAMBDA helper functions ( MAP , SCAN , REDUCE ).