Python in Excel

Episode #446, published Fri, Jan 26, 2024, recorded Thu, Nov 16, 2023

Transcript

Why is Python so popular? There is plenty of room for debate on this but one solid reason is it's easy to adopt, easy to use, and caters to people who are not quite developers/data scientists but need to do some computing. Do you know where there largest untapped set of that group hang out? Excel. That's why it's super exciting that Python is now going to be built directly into Excel. Just go into a cell and type =PY and you're off writing full Python 3 code that is backed by a lite Anaconda distribution of Python. And we have Dr. Sarah Kaiser here to give us the rundown on Python in Excel.
Links from the show

Sarah's website: sckaiser.com
Sarah on Mastodon: @crazy4pi314@mathstodon.xyz

Get started with Python in Excel: microsoft.com
Python in SQL Server: microsoft.com
8 of the Biggest Excel Mistakes of All Time: blog.hurree.co
Security and Python in Excel: microsoft.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to us on YouTube: youtube.com
Follow Talk Python on Mastodon: talkpython
Follow Michael on Mastodon: mkennedy

Want to go deeper? Check out our courses

Course: Python for the Absolute Beginner course

Course: HTMX + Flask: Modern Python Web Apps, Hold the JavaScript

Course: Modern APIs with FastAPI and Python

Sarah Kaiser

Dr. Sarah Kaiser is a Senior Cloud Developer Advocate @ Microsoft. She talks about #oss, #python, #community, #quantumsoftware, and #quantumcomputing. Sarah currently lives in Seattle, Washington, United States.

Episode sponsored by

Ads served ethically