Earlier quoted context omitted.
Excel is a disaster. It will randomly corrupt input that happens to fit certain patterns by parsing it into "dates" or "numbers", unless you go to the trouble of explicitly setting the right "cell properties" via the incredibly clunky UI. It hides the code that's input in cells, lets it randomly mix with input data and does not support any kind of source control for it. It's not even fit for purpose as a prototyping…
Yup, but you can make it do the job and that's enough for the majority.
"If the only tool you have is a hammer, you tend to see every problem as a nail."