Forum Discussion
What was the moment you realized Excel was more powerful than you thought?
I’ll go first. For me, it was when I learned about Power Query. I used to spend hours manually cleaning CSVs removing duplicates, reordering columns, splitting names, etc. I thought that was just ho...
There have been no moments of blinding revelation for me but when LAMBDA appeared, with its claims of Turing completeness, I set out to test the functionality by implementing some of the more complex algorithms that might come to mind. I first implemented a 4th order Runge-Kutta algorithm for integrating ordinary differential equations and then went on to implement a Fast Fourier Transform algorithm. The tasks weren't easy and it still might be better to use a Python library routine, but the fact that it proved possible made be realise that we are now dealing with a serious computing environment.