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 workshop, 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 workshop, you will be able to create a custom Python script that allows you to combine excel files & create charts out of them.
👉 WORKSHOP LINK: https://www.meetup.com/de-DE/Le-Wagon-Tokyo-Coding-Station/events/281134340/
Le Wagon Tokyo (https://www.lewagon.com/tokyo) is a top ranked coding school for startups, creative people and tech entrepreneurs. Our Web Development and Data Science bootcamps are designed for individuals who want to change their career, become freelancer, or launch their own venture!
I've developed some handy Excel add-ins that you might find useful:
- 📊 Dashboard Add-in: Easily create interactive and visually appealing dashboards.
- 🎨 Cartoon Charts Add-In: Create engaging and fun cartoon-style charts.
- 🤪 Emoji Add-in: Add a touch of fun to your spreadsheets with emojis.
- 🛠️ MyToolBelt Add-in: A versatile toolbelt for Excel, featuring:
- Creation of Pandas DataFrames and Jupyter Notebooks from Excel ranges
- ChatGPT integration for advanced data analysis
- And much more!
- 📺 YouTube: CodingIsFun
- 🌐 Website: PythonAndVBA
- 💬 Discord: Join the Community
- 💼 LinkedIn: Sven Bosau
- 📸 Instagram: sven_bosau
If you appreciate the project and wish to encourage its continued development, consider supporting my work.
For feedback, suggestions, or potential collaboration opportunities, reach out at contact@pythonandvba.com.