We wrote a static optimizer for spreadsheets - this looks at the entire sheet and reduces computational complexity where it can.

Excel's built-in functions are optimized to run fast individually, not to work in concert. (Also, some of them are just slow for no good reason.)