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...
Agreeing with both Hans and Riny. As an old-timer with spreadsheets (I was even working with multi-dimensional arrays in the early '70s, pre-dedicated-spreadsheet software, using APL)...it was first Pivot Tables, which enabled amazing summaries of extensive transactional tables--I still use it for my personal income and expense tracking workbook.
But then the far more recent introduction of Dynamic Array functions, enabling more nuanced summarization of data.
I've resisted VBA and macros, for the most part--granted I'm long retired from work anyway--but resisted those methods, because in general I find that if it can be programmed, it already has been, in one or more of the Functions and Tools built-in.