Suitable for both simple beam calcs and complex high-rise embedded design. Used in professional offices for over 15 years.
Convert your data ranges into (Ctrl+T). Tables automatically expand when you add new data, provide structured references that are easier to read than cell addresses, and keep formulas consistent across rows. This is a foundational practice for building models that are both robust and easy to maintain. daniel t li spreadsheets better
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. Suitable for both simple beam calcs and complex
If you're interested in taking your spreadsheet skills to the next level, here are some steps you can take: Tables automatically expand when you add new data,
As the CEO departed, Rachel turned to Daniel with a grin. "You know, Daniel T. Li, you're the spreadsheet whisperer. You're better than magic."
Using PivotTables to summarize massive datasets into actionable summaries.