Li emphasizes using dependent dropdown lists, custom formulas in validation rules, and combining data validation with INDIRECT or XLOOKUP to create interactive, database-like behavior inside a spreadsheet.
Where charts and summaries live. 2. Making Spreadsheets Better Through Automation
Each module explicitly contains the formulas and reference code sections (such as ASCE 7-22 or ACI 318-11 ) used for calculations. daniel t li spreadsheets better
Remove default gridlines on dashboard tabs to make them look like clean web apps. Use intentional spacing to let the data breathe.
Tools for everything from retaining walls to deep beam design. Tools for everything from retaining walls to deep
You can explore the full Software Overview or Resume of Daniel T. Li to see which tools fit your current project.
Stick to one professional font family (like Aptos, Segoe UI, or Arial) and use size variants strictly to denote headers, subheaders, and data rows. Eliminate Hardcoded Values in Formulas Li emphasizes using dependent dropdown lists
Meanwhile, his coworker, Rachel, was struggling to make sense of a particularly complex dataset. She had been staring at it for hours, but the numbers just wouldn't add up. That's when she noticed Daniel's remarkable efficiency.
A spreadsheet that only the creator understands is a liability. Making spreadsheets "better" means ensuring they are transparent and robust.
Is this system resilient enough to handle 10,000 rows without breaking?
: Ensure all user-defined data is entered in one clearly marked section to avoid hunting through the sheet for variables.