Recently, I have delivered a talk on Python Meets Excel: Smarter Workflows for Analysts and Data Teams at PyData Global 2025. Here's what inspired me to choose this talk: Python drives modern data workflows, yet Excel remains the lingua franca of business.
Many Python-based data teams struggle when the “last mile” of delivery still involves exporting results to Excel for business users. This talk explores practical ways for Python users to automate, scale, and enhance Excel-heavy processes using open-source libraries.
If you are an Excel user, you will learn smarter ways to use Python's capabilities (even if you do not have Excel 365). You can bring any custom python function in Excel with a small set-up.
This talk will help you bridge the gap between code and the business-facing spreadsheet world.
We have discussed real-world use cases for report generation, and dashboard templating, xlwings UDFs, all from a Python-first perspective. You can watch the talk here If you have any questions regarding the same, feel free to ask in the comments there, I'll try to answer. You might enjoy my other talks as well, specially data storytelling & chart lie talk (watch it even if you are a non-technical person)
