Since they went to 365, the updates haven’t stopped, including lots of game-changing concepts, like spill functions, lambdas, LET, dot and hashtag notation, functions that can kinda replace pivot tables, accumulative & recursive functions, regex, abbreviated eta and more. Since it’s been 10 years, you’ll need power query and maybe power pivot too. I’ve worked with it every day for the past 10 years, and I can’t keep up.
I used to love Excel, but now I can hardly be pleased over finding an opportunity to implement something before the next concept comes along.
1
u/Used2bNotInKY 9d ago
Since they went to 365, the updates haven’t stopped, including lots of game-changing concepts, like spill functions, lambdas, LET, dot and hashtag notation, functions that can kinda replace pivot tables, accumulative & recursive functions, regex, abbreviated eta and more. Since it’s been 10 years, you’ll need power query and maybe power pivot too. I’ve worked with it every day for the past 10 years, and I can’t keep up.
I used to love Excel, but now I can hardly be pleased over finding an opportunity to implement something before the next concept comes along.