CPA Australia

•

Канал • Подкастов: 4

Образование

Образование

1 июн.
Бизнес

Бизнес

9 июн.
Деловые новости

Деловые новости

Каждые две недели
Карьера

Карьера

Ежемесячно

1 июн.

Why Excel macros still matter in 2026

Excel 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 accountants and finance professionals. Key learnings: Why macros still matter in modern Excel workflows How VBA compares with Power Query The limits of Power Query for in-situ data fixes How AI can help write and debug VBA code How to automate data cleansing tasks in Excel Why VBA is a useful entry point into programming How to store macros in the personal macro workbook Ways to run macros from the quick access toolbar Listen now to help level up your Excel skills with macros. 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? Don't forget to subscribe to EXCEL TIPS and share this episode with your colleagues and friends in the business community. 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

1 июн.

•

10 мин.
1 мая

Template tips to boost workflows

Most 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 month's version of the file. This is where templates can help. In this episode, explore how Excel templates solve that problem while also improving consistency across your reporting. Main learnings: How Excel templates prevent accidental file overwrites The difference between workbook, sheet and task-based templates Where to find and manage built-in and personal templates How to create blank templates with pre-set formats and settings Using templates to embed headers, footers and branding Managing template storage, including system and shared folders How to apply templates across teams for consistency and control 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. For more, check out the accompanying video - https://youtu.be/RJdT6FF-w58 Read more of Neale's Excel articles on INTHEBLACK. Loving this content? Don't forget to subscribe to EXCEL TIPS and share this episode with your colleagues and friends in the business community. 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

1 мая

•

8 мин.
30.09.2024

How to add a user interaction into Power Query

Reports are crucial to your work, aren't they? Power Query is a valuable tool for importing many types of data into Excel to help you create these reports. However, it does have limitations. In this episode, you'll learn how to address one of Power Query's key shortcomings: user interactions. By using staging queries, reference techniques and range names, users can dynamically filter data within Power Query based on user-selected criteria. For fast access, use these timestamps: 0:17 – About the variable Power Query function 3:37 – Implementing the query function 5:46 – Using a range name for a table 7:07 – Using a query to read the variable input 9:43 – Refreshing the power query 10:11 – Recap and use cases Listen now to learn how to add a user interaction into Power Query. Host: Neale Blackwood CPA has more than 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. CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting: INTHEBLACK INTHEBLACK Out Loud With Interest Excel Tips Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

30.09.2024

•

12 мин.
01.12.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

01.12.2025

•

16 мин.
9 июн.

Crime By Numbers: AML reforms and the gatekeepers preventing money laundering

This publication provides general information only and is not legal or professional advice. CPA Australia gives no warranties as to its accuracy, completeness or suitability and disclaims all liability for reliance on it. Listeners should seek their own independent advice for their circumstances. What does Australia's biggest AML (anti-money laundering) reform in years mean for accountants, lawyers, advisers and business owners? This episode breaks down the tranche 2 anti-money laundering reforms, the growing role of AUSTRAC, and why professional service firms are becoming critical gatekeepers in the fight against financial crime. The discussion explores how money laundering really works, why criminals target trusted advisers, and the practical steps businesses need to take to prepare for new compliance obligations. Main learnings: Why Australia is expanding AML reporting obligations How accountants and lawyers help identify suspicious activity What suspicious matter reporting involves in practice Why knowing your customer is central to AML compliance The role of AUSTRAC as regulator and intelligence agency Common red flags linked to financial crime and tax evasion How smaller businesses can approach AML compliance practically This episode offers practical guidance for accounting, finance and advisory professionals navigating Australia's evolving AML landscape. Listen now. Host: Jacqueline Blondell, editor, CPA Australia Experts: Brendan Thomas, AUSTRAC CEO Geoff Peck, a former fraud squad detective with Victoria Police's major Fraud Group, and managing director Forensic & Integrity Solutions Amanda Wood, managing director, Kroll's Investigations, Diligence and Compliance Practice For more, head to the Australian Institute of Criminology website. Need help with your AML/CTF obligations? AUSTRAC and CPA Australia have a host of resources. AUSTRAC's guidance for small business is another useful resource. And head to the Crime By Numbers homepage to catch up on earlier eps in this second series as well as series 1. Loving this episode? Listen to more INTHEBLACK episodes and other CPA Australia podcasts on YouTube. https://www.youtube.com/@CPAaustralia/podcasts And don't forget to click subscribe to the channel for a wide range of content that will help your career. CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance and accounting: With Interest https://www.cpaaustralia.com.au/tools-and-resources/podcasts/with-interest INTHEBLACK https://www.cpaaustralia.com.au/tools-and-resources/podcasts/intheblack INTHEBLACK Out Loud https://www.cpaaustralia.com.au/tools-and-resources/podcasts/intheblack-outloud Excel Tips https://www.cpaaustralia.com.au/tools-and-resources/podcasts/excel-tips Search for them in your podcast platform. Email the podcast team at podcasts@cpaaustralia.com.au Chapters: 00:00 Disclaimer 00:21 The social purpose of anti-money laundering 00:45 Introduction to Crime By Numbers Episode 3 01:28 AUSTRAC's role in Australia's AML/CTF regime 02:44 History of money laundering laws and Tranche 2 reforms 03:22 Why Australia is catching up with global AML standards 04:20 Why accountants and lawyers see risks banks can't 05:23 Core obligations for new AML gatekeepers: KYC and reporting 07:05 Comparing Tranche 1 and Tranche 2 compliance challenges 08:15 Embedding AML compliance into professional practices 09:37 Knowing your customer and hidden criminal risk 11:03 Business benefits of stronger AML processes 11:37 Common misconceptions about money laundering and cash 12:39 AUSTRAC guidance, starter kits, and industry support 14:29 Enforcement approach, penalties, and expectations 15:13 The real victims behind money laundering crimes 16:32 Resources for new gatekeepers and closing remarks

9 июн.

•

17 мин.
01.08.2023

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 – 4:09 Relative and absolute cell and range references – 7:15 The calculation sequence – 9:46 Parentheses (brackets) – 10:39 Colours in formulas – 12:37 Entering cell and Range references – 13:50 The Function Wizard – 15:57 Formula auditing – 17:01 IF error – 19:12 REF error – 20:01 Dynamic arrays and the SPILL error – 20:26 Tune in now to level up with these expert shortcuts and techniques. Host: Neale Blackwood CPA has more than 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. 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 platform. You can email the podcast team at podcasts@cpaaustralia.com.au

01.08.2023

•

24 мин.
2 мар.

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 find patterns in unstructured text, from email addresses to dates and hidden white space. You will learn: what REGEX is and why it matters for accountants and analysts how to use REGEXEXTRACT, REGEXTEST and REGEXREPLACE when to combine REGEXTEST with FILTER for smarter analysis how REGEX now works inside XLOOKUP and XMATCH ways to manage white space and non-standard characters why building a reusable pattern library will save time. Programmers have been using REGEX patterns for decades, but they've only just come to Excel. The good news is Excel's new REGEX functions give finance teams a practical way to take back control. Listen now to help improve your Excel skills. 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? Don't forget to subscribe to EXCEL TIPS and share this episode with your colleagues and friends in the business community. 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

2 мар.

•

6 мин.
1 апр.

Increment dates easily in Excel

What 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 including days, weeks and months in one function Using the SWITCH function to create a lookup table How the LAMBDA function can be deployed Best practice tips for this custom function Listen now to improve your Excel skills. 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 video for this episode. Read more of Neale's Excel articles on INTHEBLACK. Loving this content? Don't forget to subscribe to EXCEL TIPS and share this episode with your colleagues and friends in the business community. 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

1 апр.

•

7 мин.
25.11.2025

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

25.11.2025

•

17 мин.
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

1 янв.

•

14 мин.

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

Сайт

CPA Australia

Популярные подкасты

Why Excel macros still matter in 2026

Template tips to boost workflows

How to add a user interaction into Power Query

Unlock 7 underused Excel features you still need today

Crime By Numbers: AML reforms and the gatekeepers preventing money laundering

Unlock 14 expert tips for Excel formulas

Master your messy data

Increment dates easily in Excel

Payday Super explained ahead of 2026 rollout

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

Об этом подкасте

CPA Australia

Популярные подкасты

Популярные выпуски

Об этом подкасте