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 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!
Mar, 4th 2018: Added Tutorial 7
Feb, 25th 2018: Added Tutorials 5 & 6