CPA Australia

•

Kanal • 4 program

Näringsliv

Näringsliv

−2 d
Utbildning

Utbildning

1 juli
Karriär

Karriär

Varje månad
Affärsnyheter

Affärsnyheter

Varannan vecka

−2 d · Video

The essential career skill you'll need in the AI era

The data doesn't lie. With 40 per cent of workers' current skill sets expected to be transformed or obsolete by 2030, it leads to a question many are asking: How do professionals working in finance and accounting become indispensable in the coming years? In this episode, INTHEBLACK tries to answer that by exploring the one skill that professionals can focus on to help them remain valuable. The expert insights in this episode include: Why AI widens the gap between average and exceptional professionals The human skills that are becoming more valuable, not less How critical thinking protects against AI errors and hallucinations Why emotional intelligence and communication remain competitive advantages How to build a career that evolves alongside AI Practical advice for accountants, finance professionals and business leaders planning the next decade If you're looking to stay indispensable in an AI-enabled workplace, this episode offers practical guidance grounded in real-world leadership experience. Host: Tahn Sharpe, editor, INTHEBLACK, CPA Australia. Guests: David Carney and Amanda Kenafake. David is executive director of the Career Industry Council of Australia, and CPA Amanda is CEO and executive director of financial services provider Power Tynan. Learn more about the the Career Industry Council of Australia (CICA) at its website. Similarly, head online for more information on the services provided by Power Tynan. 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

−2 d · Video

•

17 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
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 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
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
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
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
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
2024-01-04

How to master using different Excel techniques together

Do you want to improve your Excel skills in 2024? Start the new year on a positive note with these essential tips that can help you master a couple of Excel techniques together. In this episode, we show you how to build custom lists and use range names. For fast access, use these timestamps: Custom lists explained – 0:29 Creating custom lists – 1:34 Automating lists with range names – 4:08 Creating range names (method 1) – 4:52 Transpose function – 7:30 The downside of using range names (method 1) – 7:59 Using formatted tables for range names (method 2) – 8:33 Array based range names – 10:08 Special values keyboard shortcut – 11:37 Examples using the range names – 12:43 Using helper cells and the index function – 13:45 Repeating the range name sequence – 14:48 Recap and benefits of automated custom lists 15:46 Tune in 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: With Interest INTHEBLACK INTHEBLACK Out Loud Excel Tips Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

2024-01-04

•

17 min

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

Webbplats

CPA Australia

Topprogram

The essential career skill you'll need in the AI era

Template tips to boost workflows

Why Excel macros still matter in 2026

Increment dates easily in Excel

Cognitive bias in decision-making

The risks of using a pay-on-demand service

Learn a smart way to hide blank or zero rows

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

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

How to master using different Excel techniques together

Om

CPA Australia

Topprogram

Toppavsnitt

Om