Unleash the power of Python in Excel
Excel Tips1 Sep 2025

Unleash the power of Python in Excel

In this third and final episode of a three-part series, we explore how the integration of Python unlocks advanced tools for analysis, automation and visualisation.

Listeners will learn:

  • How Python connects with Power Query to extract and transform data

  • Ways to preview and filter information using Pandas functions

  • Techniques for reshaping horizontal data into usable formats with melt()

Python in Excel can really help your data workflows. It allows you to work with connection-only Power Queries, cleanse and reshape messy datasets and generate dynamic charts in just a few lines of code.

And with built-in libraries like Pandas and Matplotlib, you or your finance team can preview, filter and transform data in ways that are faster and more flexible than traditional Excel functions.

Who doesn't love that?

Packed with practical insights, this episode helps you harness Python in Excel to save time, improve analysis and elevate decision-making.

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.

LINKS

Listen to part one of this three-part series which covers the basics. Episode two discusses practical applications of Python in Excel.

And you can read more of Neale's Excel articles on INTHEBLACK.

You can find a CPA at our custom portal on the CPA Australia website.

Would you like to listen to more Excel Tips episodes? Head to CPA Australia's YouTube channel.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:

With Interest

INTHEBLACK

Excel Tips

INTHEBLACK Out Loud

Search for them in your podcast platform.

You can email the podcast team at podcasts@cpaaustralia.com.au

Avsnitt(45)

Getting started with Python in Excel

Getting started with Python in Excel

Unlock the potential of Python in Excel with this essential first episode in a three-part series. Designed for accountants, finance professionals and Excel power users, this episode introduces the...

1 Juli 20259min

Excel's GROUPBY and PIVOTBY explained

Excel's GROUPBY and PIVOTBY explained

Excel's new functions, GROUPBY and PIVOTBY, offer a smarter way to build reports. Instead of relying on traditional pivot tables, these new tools allow you to summarise datasets using dynamic, for...

2 Juni 202512min

Better share price reports with Excel's new tool

Better share price reports with Excel's new tool

Need to turn stock market data into smart, professional reports? Discover how to use Excel's new and powerful Stock History function to quickly transform raw share price data into clear, insightful re...

1 Maj 202512min

Elevate your Pareto analysis skills with Excel

Elevate your Pareto analysis skills with Excel

The Pareto principle is a powerful concept for business. In this episode we'll explore this principle (also known as the 80/20 rule) and learn how to apply it effectively in Excel for smarter, da...

31 Mars 202510min

Unlock the power of Microsoft Forms in Excel

Unlock the power of Microsoft Forms in Excel

What if you could seamlessly collect and analyse data right inside Excel? In this episode, learn more about Microsoft Forms, a powerful tool in Microsoft 365 (which, by the time you read this may ...

3 Mars 202510min

New tool explained: boost your efficiency with checkboxes

New tool explained: boost your efficiency with checkboxes

Ready to unlock a hidden gem in your Microsoft Excel subscription? In this episode you'll discover the power of checkboxes with practical examples to explore how this new function can streamline y...

2 Feb 202510min

Improve your PDF data handling with Power Query

Improve your PDF data handling with Power Query

Ever struggled to extract crucial financial data from PDF files into Excel? As accountants and finance professionals, this can be a regular occurrence. To help you, this episode explores Micro...

2 Jan 202512min

Handy hack to create timeline charts

Handy hack to create timeline charts

Excel doesn't have a built-in timeline chart but we'll show you how to create one. In this episode you'll learn how using a scatter chart can help you build a timeline chart. For easy reference, here ...

1 Dec 202410min

Populärt inom Business & ekonomi

framgangspodden
varvet
badfluence
rss-jossan-nina
rss-borsens-finest
avanzapodden
svd-tech-brief
rss-svart-marknad
uppgang-och-fall
fill-or-kill
rss-dagen-med-di
borsmorgon
kapitalet-en-podd-om-ekonomi
affarsvarlden
rss-kort-lang-analyspodden-fran-di
tabberaset
lastbilspodden
24fragor
bathina-en-podcast
borslunch-2