Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Automate Excel using Python – Xlwings | Series 2

Master yourself to automate Industry-level datasets in Excel with hands-on experience on "3 Case Studies" using Python
(0 reviews)
36 students
Created by


CourseMarks Score®







Platform: Udemy
Video: 3h 1m
Language: English
Next start: On Demand

Table of contents


This course teaches how to automate Industry-level datasets maintained in Excel sheets using Python programming language.
MS Excel is a very helpful tool for record-keeping. But the language that comes by default for macro is VBA, which is dated. And in the field of Data Analysis, Python has a lot of interesting packages which makes a job easy. Package like xlwings links any Excel with Python macros. Packages like Pandas, takes data into tabular format i.e. dataframe and also has customized filtering of rows or columns for complex data analysis. Packages like Matplotlib, Plotly enables to create different plots – line plot, Scatter plot, Heat map for finding the correlation b/w different parameters. You would learn the most modern interactive chart with required customization.
In the Series, 3 Case studies has been picked from Industry process line. And correspondingly, Python macros are created to:
•reduce time in analysis
•enable customization using python packages
•reduce macros code lines in VBA codebase.
•create customized User-defined modules by python functions.
The “Data Science” field is mainly composed of 3 stages:
a. Data Acquisition: The method of fetching data from the storage like Excel here.
b. Data Wrangling: The method of filtering, extracting the required data from the raw dataset.
c. Data Visualization: The method of visualizing the data in the best possible form of chart. Here, we target at showing the most modern interactive chart.

You will learn

✓ Writing macros (in python) for their Excel sheets
✓ Automate Excel without any VBA code (installed by default)
✓ Build your own Formulas by coding User-defined Functions (UDFs) in Python
✓ Practical hands-on experience with Industry level datasets
✓ Automate, streamline and completely revolutionize your Excel workflow with Python macros
✓ Master unique concepts, tools and case studies, which you won’t find ANY other course, guaranteed
✓ Get LIFETIME access to course materials and a 1-on-1 expert support
✓ Continuous course updation when python packages updated with new features


• Python Fundamentals
• Excel (version 2007 or later)
• Word (2007 or later)

This course is for

• Beginner developers who want to make their career on Data Science
• People working as an Analyst, using Excel mostly
Data Science, Bots, Blockchain, C++, Python
Block.Hub is an Academy which aims at educating people through courses on Data Science, Bots, Blockchain, Cryptography, Smart contracts, Programming languages (C++, Python) and related topics.
The Academy is aimed at giving students, an industrial experience of Software development. It’s more about practical programming rather than just sticking to theoretical concepts.
In the last few years, data has literally exploded. In fact, 95% of the total data has been created in the last few years. And of course, that’s followed by the increasing no. of Software jobs & it’s requirements.
Getting a college degree is not going to be the only way of examining talent. But, rather it’s going to be more about programming experience in real world case studies. And that’s where this academy comes into picture.
The Academy is highly committed to release course(s) — at least two per month. So, that students can get a faster way to learn newer & unconventional ways of coding.
This will make a student confident enough to work solo as a freelancer, if needed. We believe in making every student as ‘Independent’ Software Developer.

“Programmers of tomorrow are the wizards of the future…” – Gabe Newell
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 3h 1m
Language: English
Next start: On Demand

Students are also interested in