•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What do you use python for in Excel?
I currently use Power Query to combine files and transform the data. I also have macros to create folders and rename files. Recently I noticed our company finally have python available in excel. I'm just curious what have people here used the python for that Power query or vba script can't do or python just does better. Just FYI, I mostly vibe code my stuff.
[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
#Excel compatibility
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#no-code spreadsheet solutions
#Python
#Excel
#Power Query
#Macros
#VBA
#Transform data
#Combine files
#Automate
#Data analysis
#Data manipulation