•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can i automate Web+Excel+AI?
Our take
Automating tasks that involve Web, Excel, and AI can streamline your workflow significantly. As a beginner with a commerce background, focus on tools that simplify the automation process. Start by exploring Microsoft Power Automate, which can help you extract PDF data from the web and convert it to Excel easily. Familiarize yourself with no-code platforms like n8n for creating workflows. Additionally, develop basic skills in Excel functions and formulas to enhance your automation capabilities.
I have a commerce background. I am a beginner (Please guide me like a begginer i can't understand heavy tech language), and I don't have experience with Agentic AI, Automation, or coding. So, I want to know how I can automate Web+Excel+AI and what skills I need to do so, like coding or n8n.
This is how my workflow looks:
- Automate the extraction of PDF from the Web, and convert the data given in the file to Excel
- Creating an AI which act as a brain for automation and does what I want to make them do, like sum, putting different-different formula and functions in each cell as per the requirement.
This is the basic workflow.
And which Automation tool should I use to do the above, like MS Power Automate?
Give me a Roadmap of where I should begin my tech skills.
This will be a plus if you can provide Video links to the playlist.
Thank you for helping in advance!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel Power Automation - Sending Emails to Users Based on Sheet CriteriaHi All! My organization currently uses a website called Smartsheets to create task lists. I've created automations that run each morning that send emails to users if a task becomes past due. It fulfills the intended purpose; however, every single month there seems to be some new issue; therefore, I'd like to transfer over to using functionality in native Excel. My research turned me on to Power Automation. I found the tools I needed until I hit a roadblock: P.A. does not look at the contact within the sheet and send a message to that person. It appears to just go to one designated individual. Any thoughts, recommendations, or solutions? I am almost at the end of my rope and ready to just deal with Smartsheets. A screenshot of our task list can be found in the comments. Maybe it provides some reference that I missed. Thanks! submitted by /u/bltsmith [link] [comments]
- Best way to automate result filtering?Help- I'm just starting to learn about automation within Excel and I'm not sure what I even really need to be asking. The short version is, I need to be able to dynamically sort out blank columns based on filter results for another column. More specifically, one of my job dutirs is pulling and distributing customer satisfaction survey results across our system. Someone along the line decided the best way to do this was with a single, massive survey on Survey Monkey, with location based filters automatically giving the customers site specific questions. What this means for me is that every week I'm using views within the survey monkey analysis screen to pull results individually for each location, then unzipping and naming them, before finally being able to send them out to the various teams. If I pull the entire survey with no views applied, there are a ton of columns, with each location having a certain block of columns containing results. E.g. location a results are in columns d-f, location b results are in columns g-i... Etc. What I would like to do is pull the entire block of results and then use some sort of automation to sort results automatically, taking this from an hours long process down to a matter of minutes. Should I be looking at power query? Macros? Is this functionality built in to an existing tool, like pivot tables or something? Any direction on where I should be going to learn more is appreciated. submitted by /u/Ok_Perception3325 [link] [comments]