Self-paced video course · Under 1 hour · Python in Excel
Unlock the power of Python directly inside Excel. A practical, concise crash course for data professionals who want to extend their analytics without leaving Excel behind, with minimal coding required.
Price
$19, one time
Format
Self-paced video
Length
Under 1 hour
Access
Yours to keep
What’s included
- Concise, actionable video lessons, under one hour in total
- Hands-on demonstrations and real-world examples
- Downloadable exercise files and resources
- Links to official Microsoft documentation and resources
What’s inside
Five focused lessons take you from setting up Python in Excel to a working analysis you can reuse. No prior Python knowledge required.
The Python in Excel environment
Get comfortable with how Python runs inside Excel and the key packages it ships with, so you’re ready to write your first code.
Working with Python in Excel objects
Learn how to save and manipulate objects in the Python in Excel environment so your results flow back into the workbook the way you expect.
Getting data into Python in Excel
Master efficient ways to bring Excel data into Python, from a few different starting points.
- From cells
- From Excel tables
- From Power Query
Quick win: a dynamic moving average chart
Put the basics to work right away by building an interactive moving average chart that updates automatically as your data changes.
Python with Advanced Analysis and Copilot
See how Python works alongside Excel’s Advanced Analysis and Copilot features to produce smarter, AI-assisted insights.
Python is built into Excel now. This shows you how to use it.
Python in Excel runs right in the grid, so you can reach for real data libraries the moment formulas start to strain, without leaving the workbook or managing a separate setup. This crash course gets you there in under an hour.
Excel on its own
- Formulas hit a ceiling for heavier analysis
- Exporting to a separate Python setup to do more
- Juggling files between two environments
With Python in Excel
- Write Python directly in the workbook
- Use real data libraries where formulas fall short
- Results return to your cells, nothing extra to install beyond Microsoft 365
Who it’s for
Excel users ready to level up their analytics with Python, with minimal coding.
- Data analysts
- Financial analysts
- Marketing coordinators
- Accountants and controllers
- Operations analysts
No prior Python knowledge required, though familiarity with Excel is recommended.
Your instructor
George Mount is the founder of Stringfest Analytics, a Microsoft MVP, and the author of Modern Data Analytics in Excel and Advancing into Analytics (both O’Reilly). His next book, on Python in Excel, is forthcoming. He holds master’s degrees in finance and information systems from Case Western Reserve University and has more than ten years of data analytics experience.
Before you enroll
Software: An up-to-date Microsoft 365 installation on a Windows machine is recommended, since Python in Excel needs it. No prior Python knowledge is required, and familiarity with Excel will help you get the most out of the lessons.
After you enroll: You get immediate access to the video lessons and the downloadable exercise files. It’s a one-time purchase of $19, yours to keep, with no subscription.
Enroll
Enroll in the Python in Excel Crash Course
Self-paced video, under an hour, $19 one time and yours to keep. Click below to enroll through Gumroad.