CPA Australia

•

Canal • 4 programas

Educación

Educación

3 ago
Noticias de negocios

Noticias de negocios

Dos veces al mes
Economía y empresa

Economía y empresa

27 ago
Profesiones

Profesiones

Cada mes

1 sep

Create interactive Excel charts (part 2)

Can 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 charts this time using financial year calculations and checkboxes. This is useful for finance pros because the techniques allow users more control. You will learn: How to convert calendar year calculations into financial years How to use checkboxes to control ascending or descending chart order How checkboxes can figure out which metrics appear on a chart How PIVOTBY creates two-dimensional reports for chart data How FILTER, HSTACK and VSTACK can combine chart components How formatted tables allow charts to update when new monthly data is added How to build safeguards for accidentally deleted checkboxes 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
3 ago

Create interactive Excel charts

Wouldn'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 techniques behind flexible charting in Excel, with practical examples. Key takeaways: Create charts that automatically adjust the number of months displayed Use SEQUENCE to build flexible dynamic array calculations Combine data for charts with the HSTACK function Find the latest reporting period using MAX and EOMONTH Extract and summarise data with INDEX, MATCH and GROUPBY Fix a common dynamic array date bug using a simple formula adjustment Learn why helper cells make complex formulas easier to understand This is the first episode in a two-part series on interactive Excel charts, with the next instalment in September covering more advanced reporting techniques, including financial year reporting. 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
1 may

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 jul

How to create accounting reports with DAX

From 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 Expressions) formulas and Power Pivot to build more powerful accounting reports in Excel. Learn how to create scalable, maintainable reporting models using Excel's data model, while applying techniques that can also be used in Power BI. Some of the key learnings: Understand the relationship between Power Pivot and DAX Build accounting reports using multiple related tables Overcome financial year limitations in pivot tables Correct debit and credit sign issues in trial balances Test and validate DAX measures using pivot tables Use AI to write, explain and review DAX formulas 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 YouTube video of this episode. Read more of Neale's Excel articles on INTHEBLACK, including this story that explains DAX in further detail. 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 jun

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

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

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
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
06/02/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.
30/09/2024

6 ways a manager can coach their team to success

If you are a manager wanting your team to kick more goals, it may be time to put on your coach's hat. Coaching requires a different skill set to traditional management, but there are certain rules that can help you put coaching into action. Listen to the full episode. Click to read the article INTHEBLACK Out Loud brings you a curated selection of audio articles from CPA Australia's award-winning magazine, INTHEBLACK. Stories span a wide range of topics, including business, career development and the economy, and offer key insights into strategic thought leadership and expert analysis. 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 app. You can email the podcast team at podcasts@cpaaustralia.com.au

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

Sitio web

CPA Australia

Top programas

Create interactive Excel charts (part 2)

Create interactive Excel charts

Template tips to boost workflows

How to create accounting reports with DAX

Why Excel macros still matter in 2026

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

Master your messy data

Unlock 7 underused Excel features you still need today

Excel tips: how to improve your formatting

6 ways a manager can coach their team to success

Acerca de

CPA Australia

Top programas

Top episodios

Acerca de