Since 2013 and the introduction of Power Query, and possibly with the exception of Python, the biggest changes to Excel have been the Dynamic Arrays. The introduction of Dynamic Arrays literally changed the way Excel's calc engine (the heart of Excel) works. And with the introduction of new Dynamic Arrays functions such as SEQUENCE, SORT, UNIQUE, FILTER, CHOOSECOLS, VSTACK... Excel can now do SQL-like Queries with the use of native formulas. Come and be amazed :)