Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.

Excel automations cover auto-updating charts, deadline flags, and smart links; Ctrl+T table charts expand as new rows appear.

I’ve used Excel, even beyond spreadsheets, for quite some time, and over the years, I’ve naturally developed a few favorite features and shortcuts. They’re probably not the ones you’d expect, though.