CPA Australia no Apple Podcasts

1 de set.

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

1 de mai.

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

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

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

23 de jun. · Vídeo

Tax Time 2026: Property investor tips

If you're a property investor or managing investment assets, this episode features expert ATO guidance to help guide you through tax time in 2026. Want an example? Rental property tax can be straightforward until ownership structures, short-term rentals, loan redraws and capital gains tax enter the picture. This episode explores the tax issues investors most commonly get wrong and the practical steps that can help avoid costly mistakes. You'll learn: Common mistakes involving interest deductibility and loan redraws The difference between repairs, maintenance and capital improvements Understanding the rules around apportionment Why record keeping matters throughout the life of an investment Overlooked capital gains tax triggers that investors should understand How data matching helps identify discrepancies in tax returns Practical steps to stay compliant and avoid unnecessary errors Tune in now. Host: Jenny Wong, Tax Lead, CPA Australia Guest: Anita Challen, Assistant Commissioner, ATO For more, head to CPA Australia's tax time tools and resources page. And of course, you can head to the ATO website or you can download the ATO app. The ATO also has online services and you can go on the ATO website and search verify or report a scam or how to stay scam safe for more information. And you can phone the ATO on 1800 008 540. You can revisit the first three episodes of the tax time 2026 series at our website, with episodes on the ATO's main focus areas, SME guidance and the ATO's counter-fraud program. Loving this episode? Listen to more With Interest 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

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

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

1 de abr.

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

2 de fev.

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 widely used tools in finance: Excel? In this episode, we explore how the seven habits framework can be applied by accountants and finance professionals to design and build Excel models. The focus is practical and grounded in real work, with key learnings including: How asking better questions leads to stronger Excel models Why planning and prioritisation matter before building anything Designing reports first and working back to the data Building proactive features that reduce errors and improve usability Using automation and AI thoughtfully to support the process The episode also looks at where Excel fits alongside tools such as Power BI, and why judgement and planning still matter even as AI becomes more capable. 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. 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. Read more of Neale's Excel articles on INTHEBLACK. 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

CPA Australia

Principais podcasts

Create interactive Excel charts (part 2)

Template tips to boost workflows

Unlock 7 underused Excel features you still need today

Why Excel macros still matter in 2026

Tax Time 2026: Property investor tips

Create interactive Excel charts

How to create accounting reports with DAX

Master your messy data

Increment dates easily in Excel

Build Better Excel Models

Sobre

CPA Australia

Principais podcasts

Principais episódios

Sobre