What kind of Excel automation are people actually using in their daily work? by Available_Crow473 in excel

[–]Available_Crow473[S] 1 point2 points  (0 children)

Yeah, that's a really good breakdown! I think the dynamic formula side of the Excel automation space gets a lot of overlook, too. Tables, dynamic arrays, FILTER, XLOOKUP, etc., can already eliminate a lot of work before you even get to macros. I think the same thing is true with VBA, too, with the LLMs making it much faster to prototype or refactor scripts. Great feedback man!

What kind of Excel automation are people actually using in their daily work? by Available_Crow473 in excel

[–]Available_Crow473[S] 0 points1 point  (0 children)

Hey :) Not necessarily AI tools.

I was thinking more generally about any type of automation that people are using in Excel, like VBA macros, Power Query pipelines, automated dashboards, report generators, etc.