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...
IMHO, Excel always gave lot of possibilities in addition to usage it as calculator. Lot of other functions with tips and tricks of using them not standard way. Which with time becomes more or less standard way. VBA was and is on the top. Each new functionality added more flexibility and possibilities. Introduction of data model (Gemini project, now Power Pivot) with Power View (retired with introduction of Power BI). Next Data Explorer (now Power Query). Next introduction of Turing-complete formula language (Lambdas, dynamic arrays), Office.js, Office Scripts, Python in Excel.
Is it boarding complete? Nope, we are looking for improvements of existing functionality and introduction of new one/