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