Sobre este podcast
Excel Tips is a podcast for accounting, business and finance professionals who are looking to sharpen their spreadsheet skills and learn new hacks and tricks from Neale Blackwood FCPA, a Microsoft Excel expert. Excel Tips helps spreadsheet users discover Excel's hidden features and shortcuts and understand how best to apply the newest features and functionality.
The podcast is a companion to regular articles in INTHEBLACK, CPA Australia's award-winning business magazine. Every podcast episode includes links to the accompanying Excel Tips digital magazine article. Neale Blackwood FCPA has more than 25 years of experience as a Microsoft Excel educator. He is the author of more than 250 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants. Subscribe today to stay up-to-date with the latest episodes. Excel Tips is presented by CPA Australia, one of the world's largest accounting bodies, with core services that include education, training, technical support and advocacy.
CPA Australia publishes four podcasts: With Interest, INTHEBLACK, INTHEBLACK Out Loud and Excel Tips. To find out more about our podcasts, visit https://www.cpaaustralia.com.au/tools-and-resources/podcasts - or search for the shows in your podcast service. To contact the podcast team email us at [email protected].
Episódios
Os 20 episódios mais recentes de 53
- Is Copilot a reliable tool for Excel? · 12 minAI is reshaping business workflows, including how we use Excel. Copilot — Microsoft's AI-powered assistant — can help finance professionals work more efficiently in Excel, from…
- How to use Python in Excel for sentiment analysis · 8 minExcel's core strength is working with numbers. And we love how it makes our data work more efficiently. However, what happens when the data is words? Python in Excel closes…
- Create interactive Excel charts (part 2) · 9 minCan you make Excel reporting more interactive? Yes, you can. And it's all to do with dynamic arrays. In the second of this two-part series, discover how to create dynamic Excel…
- Create interactive Excel charts · 8 minWouldn't it be useful to learn how to build interactive Excel charts that respond automatically to user input using dynamic arrays? This expert-led episode introduces the core…
- How to create accounting reports with DAX · 9 minFrom trial balances to profit and loss statements, reporting sits at the centre of modern finance. This episode explores how finance professionals can use DAX (Data Analysis…
- Why Excel macros still matter in 2026 · 10 minExcel macros are far from obsolete. And here's why. This episode explores why VBAs (Visual Basic for Applications) still play an important role in workflow efficiency for…
- Template tips to boost workflows · 8 minMost finance professionals have made this mistake at least once. You open last month's file, update the numbers, hit save, and only then realise you should have saved it as this…
- Increment dates easily in Excel · 7 minWhat if you could simplify Excel date calculations with one powerful custom function? Well, this episode explains how. You'll learn: • How to handle different date increments…
- Master your messy data · 6 minMessy, 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…
- Build Better Excel Models · 12 minYou 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…
- Smarter, faster, easier: Here's what's new in Excel · 14 minExcel 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…
- Unlock 7 underused Excel features you still need today · 16 minHandy 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…
- How to simplify complex calculations with custom functions · 8 minDid 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…
- Smarter, faster, easier: Here's what's new in Excel · 14 minIn 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…
- Unleash the power of Python in Excel · 9 minIn 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…
- Python in Excel: Practical applications · 11 minIn 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…
- Getting started with Python in Excel · 9 minUnlock 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…
- Excel's GROUPBY and PIVOTBY explained · 13 minExcel'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…
- Better share price reports with Excel's new tool · 13 minNeed 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…
- Elevate your Pareto analysis skills with Excel · 11 minThe 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…
