Python in Excel: Practical applications

Excel Tips

In this second episode of a three-part series, you 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

• Use the Pandas library to work with Excel tables (called 'data frames' in Pandas)

• 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 listen to part one of this three-part series on Python in Excel as well as read the accompanying article for part one.

The article for this episode is also available online at INTHEBLACK.

And you can read more of Neale's Excel articles for 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 [email protected]