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)

How to automate report building in Excel

How to automate report building in Excel

Are you an accountant or finance professional looking to enhance your daily workflows? Don't miss this episode, which delves into the exciting capabilities of dynamic arrays, empowering you to effort...

29 Feb 202411min

Master the latest Excel changes: your ultimate guide

Master the latest Excel changes: your ultimate guide

For accounting and finance professionals, it's vital that you keep up-to-date with changes to Microsoft Excel functionality. This episode explains what you need to know, including the latest changes ...

1 Feb 202415min

How to master using different Excel techniques together

How to master using different Excel techniques together

Do you want to improve your Excel skills in 2024? Start the new year on a positive note with these essential tips that can help you master a couple of Excel techniques together.  In this episode, we s...

4 Jan 202417min

Top Excel tips for your first 100 days in a new job

Top Excel tips for your first 100 days in a new job

Starting a new role in accounting and finance? We understand it can be stressful as you try to make a good first impression.  This Excel Tips episode is specially designed with your first 100 days in ...

1 Dec 202314min

How to create improved data visualisations in Excel

How to create improved data visualisations in Excel

If you're looking for ways to display diverse types of data using Excel's charts and visualisation tools, this podcast, loaded with tips, will show you how. The example in this episode compares one mo...

1 Nov 202314min

Master 10 new and revamped Excel features

Master 10 new and revamped Excel features

Do you want an Excel edge?  Whether you're a seasoned pro or starting out, master these 10 new and revamped features to help streamline your workflow and boost your spreadsheet efficiency.  For fast a...

3 Okt 202314min

Boost your skills with tips for Excel function updates

Boost your skills with tips for Excel function updates

Excel is constantly evolving and improving, and it's crucial to stay up to date with all the latest changes. This companion podcast is here to help you sort quickly through the most relevant function ...

1 Sep 202313min

Unlock 14 expert tips for Excel formulas

Unlock 14 expert tips for Excel formulas

Unleash your Excel skills by using the valuable functionality of formulas. Go straight to episode sections: The formula bar – 1:06 Starting formulas – 1:41 Using functions – 2:58 Function arguments –...

1 Aug 202323min

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