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, We will We will share our favourite 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.
🌎 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦:
Download the Jupyter Notebook here: https://github.com/Sven-Bo/automate-excel-with-python