The analysts I knew at my last job would use Excel to prototype huge, incredibly complex business logic and calculations, and then have programmers (or the skilled ones would do it themselves) implement this stuff in SQL or whatever language made the most sense when it came to analysing billions of rows of real data.

It's an exceptionally powerful tool for prototyping.