Build flexible Excel functions that automatically handle blanks, defaults, and overrides without messy nested IFs.
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.