CPA Australia

•

Channel • 4 Shows

Education

Education

Updated Jan 1
Business

Business

Updated Jan 6
Business News

Business News

Updated Semimonthly
Careers

Careers

Updated Monthly

12/01/2025

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 this episode highlights some of the overlooked Excel features that are still valuable to your spreadsheet work today. Tips include: How multiple windows make it easier to copy and compare How the grouping feature works well with rows and columns How auto outline and subtotals automate structure and hierarchy in datasets Techniques for selecting visible cells to avoid errors during copying How custom lists save time and support non-alphabetic sorting This is a practical guide for anyone looking to sharpen their Excel capability, streamline reporting and improve their workflow efficiency. Listen 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. For more, check out the accompanying YouTube video of this episode. Read more of Neale's Excel articles on INTHEBLACK. Loving this content? Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? Head to CPA Australia's YouTube channel. And don't forget to subscribe to the channel. You can find a CPA at our custom portal on the CPA Australia website. 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

12/01/2025

•

16 min
JAN 1

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 and accounting professionals. Listeners will learn: How to use TRIMRANGE for flexible range selection What's new with pivot table formatting and an exciting update on auto-refresh How the TRANSLATE function works for multilingual data The simplified syntax for BYROW and BYCOL functions How three new Regex (regular expressions) functions can use patterns to identify data. Packed with practical insights, this episode helps you explore Excel's latest upgrades 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. The companion video and Excel file will go into more detail to demonstrate these techniques. 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

Jan 1

•

14 min
JAN 20

With Interest: Payday Super explained ahead of 2026 rollout

Did you know that one of Australia's biggest superannuation reforms in decades is starting in July 2026? Are you prepared for the change? In short, with legislation moving through Parliament, Australia will move from quarterly to payday-based superannuation payments – a significant shift with implications across business. This expert-led episode, featuring three guests, explores the systems issues and regulatory implications as well as why Payday Super is happening and the benefits of this change to employees. Key takeaways include: How cash flow, payroll systems and compliance will be affected by this change The closure of the Small Business Super Clearinghouse (SBSCH) How the seven-day payment rule will work for missing payments Practical steps accountants can take to help prepare clients early Listen now for expert advice to help you prepare for the changes coming soon to superannuation in Australia. Host: Tahn Sharpe, Editor, INTHEBLACK Guests: Kristen Yarbrough, Product Manager at CloudPayroll Gavan Ord, Business Investment and International Lead, Policy and Advocacy, CPA Australia Richard Webb, Superannuation Lead, Policy, Standards and External Affairs, CPA Australia Learn more about CloudPayroll at its website and its LinkedIn account. And you can read an article about Payday Super on INTHEBLACK. Loving this episode? Tune in to more With Interest episodes and other CPA Australia podcasts on YouTube. And don't forget to subscribe. 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

Jan 20

•

18 min
12/30/2025

INTHEBLACK: Private credit - Risks and rewards explained

Private credit is booming. But do investors fully understand the risks? In this episode, learn the mechanics of private credit, its place within the private capital universe and why it's suddenly everywhere - from retail portfolios to billion-dollar super funds. Key takeaways include: Why private credit is not the "bond-like risk" some claim it is How super funds allocate private credit under regulatory pressure Why borrower type, loan structure and economic cycles matter What needs to change in how private credit is marketed The potential regulatory interventions on the horizon Whether you're an institutional investor or private wealth adviser, this episode is a must-listen. Host: Tahn Sharpe, Editor INTHEBLACK, CPA Australia Guest: Michael Block, CIO, Bellmont Securities You can learn about Bellmont Securities at their website and find them on LinkedIn. Additionally, discover more with this overview of private credit from the RBA. And you can read Michael's contributions on Investor Strategy News: The four-letter word private credit investors have forgotten Credit's day of reckoning is upon us You can find a CPA at our custom portal on the CPA Australia website. Would you like to listen to more INTHEBLACK 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

12/30/2025

•

20 min
10/01/2025

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 to use TRIMRANGE for flexible range selection What's new with pivot table formatting and an exciting update on auto-refresh How the TRANSLATE function works for multilingual data The simplified syntax for BYROW and BYCOL functions How three new Regex (regular expressions) functions can use patterns to identify data. Packed with practical insights, this episode helps you explore Excel's latest upgrades 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. The companion video and Excel file will go into more detail to demonstrate these techniques. 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

10/01/2025

•

14 min
11/03/2025

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 maintain. You'll also learn practical ways to document, test and reuse these functions for consistent results. In this episode, an Excel expert will: Explain how to create custom functions using the LAMBDA function Outline how the LET function works Demonstrate creating a loan schedule "mega formula" Cover useful functions like HSTACK and VSTACK Perfect for accountants, analysts and finance professionals ready to take Excel mastery to the next level. 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. There is a useful companion video to go with this episode of Excel Tips. 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. Loving this content? Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? 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

11/03/2025

•

8 min
JAN 6

With Interest: Digital reporting - Why it's time for Australia

Australia remains one of the few advanced economies still using PDFs for financial reporting – a format most global markets have already left behind. In this episode, you'll gain expert-led insights on why adopting digital financial reporting in Australia is critical to supporting trust, transparency and competitiveness in global markets. Explore how structured data allows regulators, investors and businesses to analyse and compare information more efficiently, driving better decision-making and reducing capital costs. Listeners will learn: How structured data improves accountability and investor confidence Why global markets already mandate digital reporting standards The link between digital disclosure and lower capital costs How AI will enhance – not replace – digital reporting workflows What Australian policymakers can learn from global peers Learn why CPA Australia is recommending a mandate for digital reporting by listed entities in this expert-led discussion. Listen now. Host: Ram Subramanian, External Reporting Lead, Policy, Standards and External Affairs, CPA Australia Guest: John Turner ,CEO of XBRL International, a global, non-profit standards body dedicated to improving business performance through enhanced transparency and accountability in reporting. With a background in law, IT, and government, he has led innovation in business model design, systems development and data standards for over two decades. For more, INTHEBLACK has an article on why digital reporting should be mandatory in Australia. Additionally, this interim report from 2025 by the Productivity Commission provides broader context to digital reporting. And you can find out John Turner's organisation XBRL at its website. Loving this episode? Listen to more INTHEBLACK episodes and other CPA Australia podcasts on YouTube. And don't forget to click subscribe on the 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

Jan 6

•

23 min
01/31/2023

Excel Tips: New text functions for Excel

In this episode, we look at three new text functions released in the latest (subscription) version of Microsoft Excel. The functions are: "Text Before", "Text After" and "Text Split" To explain this is CPA Australia's Excel expert Neale Blackwood CPA. Listen now. Host: Neale Blackwood CPA Excel Tips is for accounting, business and finance professionals looking to sharpen their spreadsheet skills and learn new hacks and tricks from Neale Blackwood CPA, a Microsoft Excel expert. Excel Tips helps spreadsheet users discover 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. Neale Blackwood CPA has over 20 years of experience as a Microsoft Excel educator. He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants. 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 three podcasts providing commentary and thought leadership across business, finance and accounting. With Interest INTHEBLACK (coming soon) Excel Tips Search for them in your podcast service. To find out more about our podcasts, visit our podcast page. Or search for the shows in your podcast service. To contact the podcast team, email podcasts@cpaaustralia.com.au

01/31/2023

•

12 min
02/06/2023

Excel tips: how to improve your formatting

Today's episode will help with your formatting in Microsoft Excel. Want to know how to make your files easier to read, understand and use? To explain is CPA Australia's Excel expert, Neale Blackwood. Listen 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. CPA Australia publishes three podcasts, providing commentary and thought leadership across business, finance, and accounting: With Interest INTHEBLACK Excel Tips Search for them in your podcast service. You can email the podcast team at podcasts@cpaaustralia.com.au And you can read more of Neale's Excel articles online, including the accompanying article to this podcast.

02/06/2023

•

9 min
06/02/2025

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, formula-based solutions that update automatically when the underlying data changes. In this episode: Understand the key differences between GROUPBY and PIVOTBY See how these tools can save time and reduce manual errors Explore practical applications for accountants and analysts Discover how to modernise reporting with flexible, auto-updating formulas For fast reference use the episode timestamps.  00:17 - Two new functions that can change report creation 00:35 - PivotTables can create summary report based on a data set 00:52 - The limitation of PivotTables – Refreshing the data 01:06 - New functions GROUPBY and PIVOTBY 01:12 - Use a function to create a PivotTable report – no Refresh needed 01:36 - GROUPBY reports – row-based reports 01:41 - PIVOTBY reports - row and column-based reports 01:59 - Best practice data source – a formatted table 02:14 - GROUPBY arguments listed and explained 02:46 - Multiple columns and subtotals are possible but require other functions 03:09 - Two functions that combine columns – HSTACK and CHOOSECOLS 04:03 - Structured references include table names and column names 04:18 - Formatted tables automatically expand when new data is added 04:35 - Formatting subtotal rows differently using conditional formats 05:05 - Filtering and sorting is possible in the GROUPBY report 05:25 - Companion video has an example of a Slicer as filter 05:43 - Controlling sorting 06:18 - New function to add percentages to reports called PERCENT OF 06:42 - Companion video has a hack to easily combine SUM and PERCENT OF 07:02 - Multiple calculations add headings to the report – they can be removed 07:09 - Remove heading with the DROP function 07:25 - PIVOTBY function description and explanation 08:09 - Dates can be problematic as you want to group them by month 08:31 - Companion video shows the TEXT function solving the problem 08:53 - Allowing the user to modify the report 09:15 - INDIRECT function solution 10:05 - Explanation of the INDIRECT function 10:38 - Adding extra calculations to the report 11:07 - The LET function allows you to capture and modify the report Whether optimising month-end processes or improving team workflows, GROUPBY and PIVOTBY help turn complex datasets into clear, actionable reports. Listen now to stay up to date with these Excel capabilities. 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

06/02/2025

•

13 min

CPA Australia podcasts provide commentary and thought leadership across business, finance and accounting.

Website

CPA Australia

Top Shows

Unlock 7 underused Excel features you still need today

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

With Interest: Payday Super explained ahead of 2026 rollout

INTHEBLACK: Private credit - Risks and rewards explained

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

How to simplify complex calculations with custom functions

With Interest: Digital reporting - Why it's time for Australia

Excel Tips: New text functions for Excel

Excel tips: how to improve your formatting

Excel's GROUPBY and PIVOTBY explained

About

CPA Australia

Top Shows

Top Episodes

About