Getting started with Python in Excel
Excel Tips1 Heinä 2025

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 basics of integrating Python code directly into Excel cells.

Learn how Python enhances Excel's capabilities for data handling and visualisation without replacing core Excel functions.

You'll discover how Python in Excel works and how code is processed using Microsoft's Azure platform.

Understand the key steps to get started, including how to enter code using the =PY function and the role of the new Python editor in the Formulas tab.

Also explained is how Python variables behave across sheets, the concept of data frames and how Python's popular Pandas library comes into play when working with datasets.

You'll also learn how to manage calculation options and understand the new dependency logic within Python-enabled workbooks.

Whether you're completely new to Python or already familiar with this programming language, this episode gives you the foundational knowledge needed to begin using Python confidently inside Excel.

And don't miss the fun trivia at the end to learn the surprising origin of Python's name.

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 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

INTHEBLACK Out Loud

Excel Tips

Search for them in your podcast platform.

Email the podcast team at podcasts@cpaaustralia.com.au

Jaksot(45)

Master your messy data

Master your messy data

Messy, unstructured data.  It slows reporting, creates errors, and tests everyone's patience. Right?  This episode breaks down how the new Regular Expressions (REGEX) work and how they help you fi...

2 Maalis 6min

Build Better Excel Models

Build Better Excel Models

You may know The Seven Habits of Highly Effective People as a cornerstone of modern business thinking.  But what happens when those same principles from this book are applied to one of the most wide...

2 Helmi 12min

Smarter, faster, easier: Here's what's new in Excel

Smarter, faster, easier: Here's what's new in Excel

Excel Tips Summer Season Encore presentation from October 2025 In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance...

1 Tammi 14min

Unlock 7 underused Excel features you still need today

Unlock 7 underused Excel features you still need today

Handy new Excel features are added regularly – but some "older" functions are still particularly useful to your workflows. Smart power users know these older functions and their value – which is why...

1 Joulu 202516min

How to simplify complex calculations with custom functions

How to simplify complex calculations with custom functions

Did you know that you can transform the way you can build models, reports and schedules with custom functions?  This episode guides you on how they make complex calculations cleaner and easier to ma...

3 Marras 20258min

Smarter, faster, easier: Here's what's new in Excel

Smarter, faster, easier: Here's what's new in Excel

In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance and accounting professionals. Listeners will learn: How ...

1 Loka 202513min

Unleash the power of Python in Excel

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 Py...

1 Syys 20259min

Python in Excel: Practical applications

Python in Excel: Practical applications

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 Pa...

1 Elo 202511min

Suosittua kategoriassa Liike-elämä ja talous

sijotuskasti
mimmit-sijoittaa
rss-rahapodi
psykopodiaa-podcast
ostan-asuntoja-podcast
herrasmieshakkerit
rss-seuraava-potilas
rahapuhetta
rss-rahamania
rss-40-ajatusta-aanesta
rss-porssipuhetta
rss-merja-mahkan-rahat
rss-lahtijat
rss-20-30-40-podcast
rss-levosta-kasin-yrittajyys
rss-draivi
rss-ma
raksapodi
rss-laakispodi
rss-paasipodi