Python for Excel

Learn about Python's read/write packages for Excel, how to use xlwings, how to write your own User Defined Functions with Python.

This training is a part-time online training taking place over the course of one week. It is comprised of 4 modules. Classes are two times during the training week for about three hours during which 2 modules are covered. This represents the equivalent of 1 full training day.

The price for this training is
349 EUR (net of VAT).
Receive a discount of 10% (15%) when booking two (three) trainings.
This training is available in the form of
self-paced video classes.

Reading & Writing

Learn how to read & write Excel spreadsheets with Python:
Module 1 — the xrld, xlwt, xlsxwriter, openpyxl packages
Module 2 — introducing xlwings, setup & configuration, fundamentals (Workbook & Range objects)

Advanced Topics

Making the most out of Python & Excel:
Module 3 — combining NumPy, matplotlib, pandas with Excel spreadsheets, command line client, calling Python functions from Excel
Module 4 — User Defined Functions (UDFs), debugging, application development




Python Best Practices

Learn about Python best practices and code quality when it comes to application developement, documentation, logging, debugging, profiling, testing, packaging.

This training is a part-time online training taking place over the course of one week. It is comprised of 4 modules. Classes are two times during the training week for about three hours during which 2 modules are covered. This represents the equivalent of 1 full training day.

The price for this training is
349 EUR (net of VAT).
Receive a discount of 10% (15%) when booking two (three) trainings.
This training is available in the form of
self-paced video classes.

Development & Debugging

Important development & code quality topics:
Module 1 — Zen of Python, development tools, syntax (PEP 8), linting, structuring code, documentation
Module 2 — logging, code debugging, profiling code for performance

Testing & Packaging

Important testing & packaging topics:
Module 3 — testing strategies, testing libraries (e.g. nose), automated testing
Module 4 — building applications/libraries/packages, distribution (e.g. via pip, conda)