Xcpmr7ubtoimy5vowtmm

xlwings: Python for Excel

The Official Course

xlwings is the most popular open-source library to program Excel with Python instead of VBA. This on-demand course is a series of video tutorials that guide the student step by step through the possibilities, lesser known features and pitfalls with xlwings. The current runtime is approx. 4:20 hours.

The tutorials are split into short videos (usually between 5 and 10 minutes) so that it is easy to quickly find the topics of interest. The course material comes in the form of Jupyter notebooks and is available for download.

There are free preview videos available from almost all sections, so make sure to check out the class curriculum!

Changelog:

Nov, 12th 2018: New video: Asynchronous Functions (Part of Tutorial 4)

Nov, 12th 2018: New video: xlwings REST API (Part of Tutorial 5)

Nov, 8th 2018: Updated Tutorial 1 to reflect the breaking change with xlwings 0.13.0 on how to index app instances

Oct, 19th 2018: New video: Call Python functions from VBA in other office apps (e.g. MS Access) (Part of Tutorial 5)

Mar, 4th 2018: Added Tutorial 7

Feb, 25th 2018: Added Tutorials 5 & 6


Your Instructor


Felix Zumstein
Felix Zumstein

Felix is CEO at Zoomer Analytics, the company behind xlwings (Python for Excel) and xltrail (Git for Excel). He created xlwings in 2014 and has been its maintainer ever since. He is also the top answerer on Stack Overflow with regards to xlwings questions.


Class Curriculum


  Course Introduction
Available in days
days after you enroll
  Tutorial 2 (BEGINNER, Win & Mac): Converters and Options (12:17)
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.

Get started now!