Can it handle dynamic array formulas and LET, LAMBDA etc?

Yep :)

We fully support the formula language, and workbook semantics.

The main deficiency we have right now is not letting people create / edit pivot tables. We support what-if scenario analysis, conditional formatting, cycles, lambdas, arrays, spills, lets, etc.