About this episode
This episode explores practical applications of Python in Excel, focusing on using the Pandas library for data manipulation.
In this second episode of a three-part series, y ou will build on the basics from part one to gain a clear understanding of how to use Python directly within Excel cells . This includes using the Pandas library, for example, to merge datasets and create data-rich outputs with minimal code. You'll gain the skills to : Learn key differences between Excel formulas and Python syntax Discover practical coding shortcuts and structure for writing Python in Excel Deploy a step-by-step process to create a merged table with sales and GST calculations U se the P andas library to work with Excel tables ( called 'data frames ' in P andas ) Understand how Excel loads other common libraries like NumPy and Matplotlib Whether you're an accountant, analyst or finance leader, this episode will help you unlock more value from your Excel spreadsheets by integrating efficient Python-powered workflows. Tune in now. Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants. You can li sten to part one of this three-part series on Python in…
People in this episode
Host: Neale Blackwood CPA
Topics covered
- Python in Excel
- data analysis
- Pandas library
- Excel formulas
- coding shortcuts
- data merging
Keywords
- Python
- Excel
- Pandas
- data frames
- data merging
- sales calculations
- GST calculations
Mentioned in this episode
Organizations: CPA Australia
Products: Pandas, NumPy, Matplotlib
More episodes of Excel Tips
- Template tips to boost workflows · May 1, 2026 · 8 min
- Increment dates easily in Excel · April 1, 2026 · 7 min
- Master your messy data · March 2, 2026 · 6 min
- Build Better Excel Models · February 2, 2026 · 12 min
- Smarter, faster, easier: Here's what's new in Excel · January 1, 2026 · 14 min
- Unlock 7 underused Excel features you still need today · December 1, 2025 · 16 min
Explore listener stats, chart rankings, contacts and more on the Excel Tips podcast page.