Excel offers a *grid of code* model. That's hard to see, visualise, debug, QC, validate, etc.
It's *possible* to write Very Robust Excel. It's not *easy* to do so.
I'll also note that I'm talking of my own personal use: I'm not saying that *everyone* who has an Excel-like task should use Excel. I'm saying that when I've got a simple "accumulate a store of values, compute something, kick out report", I prefer awk.