CPA Australia

•

Kanal • 4 program

Utbildning

Utbildning

1 juni
Affärsnyheter

Affärsnyheter

Varannan vecka
Karriär

Karriär

Varje månad
Näringsliv

Näringsliv

2 juni

1 juni

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 juni

•

10 min
1 maj

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 maj

•

8 min
3 feb.

Cognitive bias in decision-making

Cognitive bias. It quietly shapes many of the decisions made in accounting and finance – often without you realising it. This unintended bias can become a risk if left unchecked – especially in professions built on precision, trust and ethical responsibility. Drawing on real-world examples, this episode explores the diverse types of cognitive bias, and how they can impact accounting and finance professionals in our day-to-day work. Key learnings include: Why cognitive bias exists and when it becomes a professional risk How common biases affect financial judgement The ethical consequences of bias in accounting and finance How organisational culture can reduce or reinforce biased thinking Practical steps individuals can take to challenge assumptions and improve decisions How the rise of AI and automation adds a new layer of complexity to decision-making The discussion also shows how biases such as confirmation bias, anchoring and overconfidence quietly influence decisions, often without conscious awareness. Host: Tahn Sharpe, Editor, CPA Australia Guest: Dr Victor Goh Weng Yew, a PhD in applied psychology and Associate Professor at the Department of Psychology at HELP University in Malaysia, where he is also the acting dean. For more, head to HELP University online and to its page on LinkedIn. And there is a CPA PD course on AI and Ethics in Malaysia featuring expert local speakers, case studies and examples. Loving this episode? Listen to more INTHEBLACK episodes and other CPA Australia podcasts on YouTube. 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 INTHEBLACK INTHEBLACK Out Loud Excel Tips Search for them in your podcast platform. Email the podcast team at podcasts@cpaaustralia.com.au

3 feb.

•

21 min
2022-08-31

The risks of using a pay-on-demand service

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. INTHEBLACK Out Loud is presented by CPA Australia. CPA Australia also publishes three podcasts, providing commentary and thought leadership across business, finance, and accounting: With Interest, INTHEBLACK and Excel Tips. Search and subscribe on Spotify, Apple Podcasts, Amazon Music, Google Podcast or your favourite podcast app. You can email the podcast team at podcasts@cpaaustralia.com.au

2022-08-31

•

11 min
2025-11-03

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

2025-11-03

•

8 min
1 apr.

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 apr.

•

7 min
2024-08-31

Learn a smart way to hide blank or zero rows

Looking to improve your report-building skills? If so, this is the episode for you. Uncover tips on how to leverage multiple Excel features to create a system that effortlessly hides blank and zero rows in your reports. Also in this episode, you'll discover the subtotal function's superpower and learn how you can use it to help identify if a filter needs reapplying. You can use these handy skills to boost your report-writing efficiency. For fast access, use these timestamps: 0:20 – Using formatted tables instead of macros for hiding rows 2:38 – About the example and tutorial file 5:10 – Applying the filter and slicer 6:35 – The subtotal function superpower Listen now. 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

2024-08-31

•

10 min
1 jan.

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 jan.

•

14 min
2025-12-23

With Interest: Attracting accountants - How to future-proof the profession

How can we attract more accountants and future-proof the profession? In this episode we take a deep dive with IFAC into this pressing question. You'll learn about accounting's talent pipeline – its challenges and possible solutions. Key takeaways include: What's really driving the talent shortage and how firms, educators and policymakers can respond. Simple ways to position accounting as a dynamic, valued career choice. Why reaching future accountants in primary school – and harnessing gamification – sparks lifelong curiosity. How AI is reshaping (not replacing) accounting jobs, and what skillsets are essential for today's graduates. Real-world strategies to build an engaged and future-proofed accounting team. If you're in business or accounting leadership, don't miss these actionable insights to help understand and elevate the profession's future. Host: Elinor Kasapidis, Chief of Policy, Standards and External affairs, CPA Australia Guest: Bruce Vivian, Head of Accountancy Education, IFAC You can learn more about Bruce Vivian's career and his role with IFAC. And read IFAC's story on possible incentives for attracting accounting talent. Also, check out IFAC's website for its attractiveness of the profession hub which includes resources on preparing a future-ready profession and roles for the next decade. You can listen to more With Interest episodes and other CPA Australia podcasts on YouTube. 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

2025-12-23

•

27 min
2023-10-03

Master 10 new and revamped Excel features

Do you want an Excel edge? Whether you're a seasoned pro or starting out, master these 10 new and revamped features to help streamline your workflow and boost your spreadsheet efficiency. For fast access, use these timestamps: Web based version of Excel: 0:30 Position of the blanks option in filter dropdown: 3:02 Power Query import updates: 4:13 CTRL key and mouse updates: 4:54 Formula bar value display: 6:06 Office Scripts: 7:14 Vertical sheet tabs: 9:25 Notes and threaded comments: 10:31 Notes and threaded comments continued Show changes: 12:38 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: 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

2023-10-03

•

15 min

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

Webbplats

CPA Australia

Topprogram

Why Excel macros still matter in 2026

Template tips to boost workflows

Cognitive bias in decision-making

The risks of using a pay-on-demand service

How to simplify complex calculations with custom functions

Increment dates easily in Excel

Learn a smart way to hide blank or zero rows

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

With Interest: Attracting accountants - How to future-proof the profession

Master 10 new and revamped Excel features

Om

CPA Australia

Topprogram

Toppavsnitt

Om