This repository contains the code, slides, and demo files used in my PyData Global 2025 talk: “Python + Excel: Smarter Workflows for Analysts and Data Teams.”
The session demonstrates how Python can automate, extend, and scale Excel-based workflows using tools like xlwings, xlsxwriter, openpyxl, and pandas.
📁 Demos Included
- xlwings UDFs
Custom formulas in Excel powered by Python
Example: Fetch API data directly into Excel
- xlwings RunMain Scripts
Click a button in Excel to run Python logic
Automated data cleaning + report generation
- XlsxWriter Dashboard
Static KPI dashboard created programmatically
Charts, conditional formatting, styled tables
📦 Requirements
To run the demos:
pip install xlwings xlsxwriter openpyxl pandas
Excel desktop (Windows or Mac) with xlwings add-in added is required for xlwings demos.
📚 About the Speaker
Dr. Nisha Arora is a data professional specializing in analytics, automation, and Excel–Python workflows. She creates practical learning content, delivers trainings, and focuses on making advanced tools accessible to analysts and business users.
📬 Stay Connected
LinkedIn: https://www.linkedin.com/in/drnishaarora
YouTube: https://youtube.com/@DrNishaArora
⭐️ If you found this useful…
Please star the repository or share it with others interested in Python + Excel automation!