•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Do you use VBA regularly or have you moved entirely to Power Query and formulas?
I have been using Excel for years and VBA was always my go to for automation. Lately I have been seeing more people say they barely touch VBA anymore because Power Query and dynamic arrays cover most of what they need. I still use VBA for things like automating reports across multiple files or generating custom email bodies from data. But I am wondering if I am behind the curve. For those of you who work in data heavy roles, what is your current workflow? Do you still use VBA regularly or have you replaced it with other tools? Curious if I should be spending more time learning Power Query and the newer formula features instead of maintaining my VBA skills.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#real-time data collaboration
#data visualization tools
#data analysis tools
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#intelligent data visualization
#workflow automation
#enterprise data management
#big data performance
#Excel alternatives
#data cleaning solutions
#rows.com
#AI formula generation techniques
#self-service analytics tools
#machine learning in spreadsheet applications
#business intelligence tools