Automating excel reports is a very broad topic, but I want to give you a few techniques to get you started.
The go to package to begin automating excel reports is pandas. Pandas is useful for dealing with tabular data - Which is perfect for dealing with data from Excel!
How should we go about beginning to automate excel reporting?
We'll cover all these in the Youtube video below:
These are just a few videos that can help you get started. I'm always adding more and always looking for suggestions. If you're needing help or get stuck, I do user requested videos all the time. Just let me know!