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...
I agree with Hans. Pivot Tables were an enormous breakthrough in the mid-nineties of the previous century. I've come to love PQ as well but missed out on it's introduction as I had switched to a Mac in 2011, hating everything that was Windows based :).
A couple of years ago I moved back to the PC for 'real' Excel work and 'found' Power Query and Power Pivot. Now I'm using it all the time. And the (more recent) introduction of dynamic array functions was another life-changer.