Study Learn Grow
Automate Excel using Python - Xlwings | Series 1

Automate Excel using Python - Xlwings | Series 1

This course teaches how to automate Industry-level datasets maintained in Excel sheets using Python programming language.

Overview

About this Course
Master yourself to automate Industry-level datasets in Excel with hands-on experience on "2 Case Studies" using Python

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 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.

In the Series, 2 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
Basic knowledge
Python Fundamentals
Excel (version 2007 or later)
Beginner developers who want to make their career on Data Science
People working as an Analyst, using Excel mostly

Course Information

Python Fundamentals
Excel (version 2007 or later)
Beginner developers who want to make their career on Data Science
People working as an Analyst, using Excel mostly

Students learn to:

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

Beginner developers who want to make their career on Data Science
People working as an Analyst, using Excel mostly

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

Plan your future in engineering with courses including MSc Engineering Management.

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs