qcasares / automate-excel-with-python

Automate Excel Reporting Using Python

There’s a lot of pain points in Excel that make it a tool that’s cumbersome and repetitive for data manipulation. But did you know that you can also use Python to automate repetitive tasks in Excel? In this video, I will be sharing my favorite ways to automate Microsoft Excel using Python. In particular, we will be using the open-source tools: Pandas, xlwings & plotly. After this video, you will be able to create a custom Python script that allows you to combine excel files & create charts out of them.

Video Tutorial

Author

• Sven from Coding Is Fun
• YouTube: https://youtube.com/c/CodingIsFun
• Website: https://pythonandvba.com

Feedback

If you have any feedback, please reach out to me at [email protected]