Turns out half my old formulas were just dynamic arrays in disguise, written the long way.
Power users rely on these lesser-known Excel shortcuts to work faster across large datasets, formulas, and worksheets.