How to automate Excel using Python - Online Workshop

Published: 11 October 2021
on channel: SK
6,160
162

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, Data Analyst Sven will be sharing his 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 materials:
https://pythonandvba.com/workshop
___________________

🚀 About Sven 🚀

Sven is a Data Analyst and Le Wagon alumni who is passionate about finding ways to use Python and VBA to be more efficient and effective in business settings. Throughout his career, he has been involved in many Data Analytics & Process Automation projects. He also attended the Le Wagon full-time Data Science Coding Bootcamp in Tokyo to sharpen his skills in Machine-/Deep learning with Python.

🚀About Le Wagon Tokyo 🚀

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!


On this page of the site you can watch the video online How to automate Excel using Python - Online Workshop with a duration of hours minute second in good quality, which was uploaded by the user SK 11 October 2021, share the link with friends and acquaintances, this video has already been watched 6,160 times on youtube and it was liked by 162 viewers. Enjoy your viewing!