Skip to content

stringfestdata/python-in-excel-demo-day

Repository files navigation

Python in Excel Demo Day

A 60-minute live session showing how Python in Excel can automate analysis, build visuals, and extend what spreadsheets can do.

Event: Python in Excel Demo Day Date: Wednesday, August 12, 2026 · 12:00 PM EDT Format: Free, online, 1 hour Host: George Mount · Stringfest Analytics


What's in this repo

File Purpose
python-in-excel-demo-day-deck.pptx The slide deck
python-in-excel-demo-day-workbook.xlsx Follow-along workbook (sales table + starter sheets)
python-in-excel-demo-day-handout.pdf One-page memory aid for attendees
instructor/python-in-excel-demo-day-instructor-script.docx 60-min run-of-show with SAY/DO blocks and pasteable code
assets/ Stringfest branding files (logo + chevron)

The starter "first hour" workshop materials (python-in-excel-first-hour-*, 01-your-first-py-cell*, 02-explore-with-pandas*) are kept for reference — they're the long-form classroom version of the same three demos.


The three demos

  1. A single cell that surprises — your first PY() cell and the calc-order rule.
  2. Summarize what formulas can'tdescribe(), value_counts(), groupby().
  3. A chart formulas can't draw — a one-line seaborn heatmap.

The instructor script paces these over 35 minutes, with 10 minutes for the CTA block and 10 for Q&A.


Where this leads (for attendees)

The session is free. The recording, the long-form versions of each demo, and the workbooks that built them all live in the membership.


Pre-flight (for George)

Before the session:

  • Confirm Python in Excel is enabled in your Excel build.
  • Open python-in-excel-demo-day-workbook.xlsx to the follow-along sheet.
  • Open the deck in presenter view; workbook visible as a second window.
  • Have the membership link ready to paste in chat at the 40:00 mark: https://stringfestdata.gumroad.com/l/mxlais?layout=profile

Pacing watchdog: if you're past 12:00 minutes during the opener, you're losing the room.

About

Python in Excel demo day resources

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors