•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Automated data pull into excel
Hey! I recently got assigned a project at work which requires me to build a model that extracts certain data from a companies annual report (pdf) into a table. This needs to be done for various companies to create a market analysis model. I’ve tried using power query through using the get data from pdf and link options, the issue is they won’t automatically update once the company updates the pdf on their website. It’s also kinda tricky to pick out/scrape the pdf for certain data. Just started my internship, any help would be amazing.
[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
#conversational data analysis
#data analysis tools
#big data management in spreadsheets
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data cleaning solutions
#natural language processing for spreadsheets
#Excel compatibility
#rows.com
#Excel alternatives
#automated anomaly detection
#automated data pull
#excel
#annual report
#data extraction