Snakes in a Grid: Python in Excel

From the creator

Spreadsheets are one of the most common ways to share data, and thankfully Python has lots of tools to help! In this tutorial, we will cover some helpful packages like openpyxl and pandas that make working with spreadsheets in Python a breeze. We will also approach the task from the other direction and explore how you can use Python directly in a spreadsheet in Excel to analyze and visualize your data. The session will include practical exercises where attendees will learn how to load, manipulate, and export spreadsheet data using Python. By the end of this tutorial, participants will be equipped with the skills to efficiently handle spreadsheet tasks in Python as well as leverage Excel to run and share Python code directly in a spreadsheet. By the end of this tutorial, participants will be equipped with the skills to efficiently handle spreadsheet tasks in Python as well as leverage Excel to run and share Python code directly in a spreadsheet. By the end of this tutorial, participants will be equipped with the skills to efficiently handle spreadsheet tasks in Python as well as leverage Excel to run and share Python code directly in a spreadsheet. https://microsoft.github.io/python-community/pycon-us https://www.linkedin.com/in/sckaiser1/ 00:00 — Intro: Python in Excel Overview 00:14 — Why Use Python Instead of VBA 01:15 — Security Benefits of Cloud Execution 02:00 — How Python Runs in Excel via Anaconda 03:23 — Excel Module and Jupyter Kernel Explained 04:27 —

Published 2025-06-24 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.