Python for Excel in a Week

What you'll get:

• Five live, 60-minute training sessions
• Free ebook copy of Advancing into Analytics: From Excel to Python and R (O'Reilly)
• Clear notes, handouts and resource guides
• Full workshop recordings shared after each session
• Certificate of attendance for professional development or internal documentation

Schedule and curriculum

• Starts Monday, July 20
• All sessions run 12:00–1:00 PM Eastern and are recorded.

Day 1 – Monday, July 20

Foundations: From Excel Cells to pandas DataFrames

You'll learn what Python in Excel actually is, how it fits into your existing spreadsheets, and how to write your first cell that does something formulas can't. You will learn how to:

• Understand how PY() cells calculate and how data flows between Excel ranges and pandas DataFrames
• Work with the libraries that ship with Python in Excel
• Replace clunky multi-formula workarounds with a single Python cell

Day 2 – Tuesday, July 21

Data Cleaning: Hours of Excel Work in Minutes of Python You'll handle the messy data tasks that take hours in formulas and minutes in pandas. You will learn how to:

• Clean dates, split and merge columns, and dedupe with logic Excel can't easily express
• Reshape wide tables into formats that work for analysis and reporting
• Build cleaning steps that are repeatable and auditable

Day 3 – Wednesday, July 22

Visualizations: Charts Excel Cannot Make

You'll see how seaborn and matplotlib let you build the charts Excel either refuses to make or makes ugly. You will learn how to:

• Build faceted plots, heatmaps, and distribution charts inside your workbook
• Use color and layout to communicate clearly with finance and ops audiences
• Choose the right chart for the question you are actually trying to answer

Day 4 – Thursday, July 23

Forecasting and Modeling: Past Trendlines into Real Statistics

You'll move beyond Excel's trendline tools into modeling you can defend. You will learn how to:

• Build regression models with statsmodels and interpret the output
• Generate time series forecasts for revenue, headcount, or other metrics
• Run sensitivity analysis on your assumptions

Day 5 – Friday, July 24

Text Analysis: Working with the Fields No One Touches

You'll close the cohort by working with the text fields most analysts ignore: vendor names, transaction descriptions, customer comments. You will learn how to:

• Clean and standardize messy text data at scale
• Extract patterns and categories from free-text fields
• Apply basic natural language techniques to finance and ops data

Workshop overview

Python is now built into Excel. For the analysts, accountants, and finance professionals who live in spreadsheets, this is the most important upgrade in years. You no longer need to leave Excel to do work that formulas struggle with.

Across five focused sessions, you'll learn how to use Python in Excel for the analysis, cleaning, charting, forecasting, and text work that has always been just out of reach. T

This workshop is designed to make Python in Excel feel approachable, not intimidating, so you can start using it on your own work right away.

What makes this workshop different

• Participative, guided demos and structured practice, not passive watching
• Authoritative, taught by a Microsoft MVP and O'Reilly author
• Practical, focused on workflows you can use immediately

What people are saying

"George has a solid core of knowledge on everything Excel and does excellent webinar training sessions." — Scot H., Analytics Principal

"George is a tremendous teacher. Makes the topics easy to understand and relatable." — Jorge C., Senior Operations Analyst

"Very informative and to the point." — Marcello D., Project Analyst

Who should attend

This workshop is for professionals who want to bring Python into their Excel work without leaving Excel.

It's a great fit for:

• Data analysts and financial analysts
• Accountants and controllers
• Operations and project managers
• BI professionals and IT leads working with Microsoft 365

A basic comfort level with formulas, tables, and PivotTables is ideal. No prior Python experience is required, though some exposure helps.

About your instructor

George Mount is the founder of Stringfest Analytics, a Microsoft MVP, and the author of Modern Data Analytics in Excel (O'Reilly). His next book, on Python in Excel, is forthcoming from O'Reilly. He specializes in helping finance and operations professionals modernize their analytical workflows using the tools already in their Microsoft 365 subscriptions.

Software requirements

• Excel for Windows or Mac with a license that includes Python in Excel. Check availability at https://support.microsoft.com/en-us/office/python-in-excel-availability-781383e6-86b9-4156-84fb-93e786f7cab0.

After you register

You'll receive access details and a setup guide before the workshop begins. Recordings and supporting resources will be shared during the event. Certificates of attendance and ebook be provided to all attendees upon completion of the course.