CPA Australia

•

Chaîne • 4 émissions

Carrière

Carrière

Tous les mois
Éducation

Éducation

-4 j
Affaires

Affaires

9 juin
Actualités économiques

Actualités économiques

Toutes les 2 semaines

-4 j

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

-4 j

•

9 min
2025-05-31

How microcultures can transform your workplace

As workplaces become more diverse and agile, is a monolithic view of culture still fit for purpose? Or is there a place for complementary microcultures that can bring a company's values to life? By Nicola Heath 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

2025-05-31

•

7 min
1 juin

3 ways to build tomorrow's CFOs

The appointment of a new CFO should be relatively straightforward in a well-managed business. Whether this transpires as such depends on long-term planning and an adequate talent pipeline. By Alexandra Cain 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

1 juin

•

10 min
2 juin

Crime By Numbers: How criminals launder money through today's networks

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. Ever wondered how criminal money moves through today's financial systems? The answer is more complex today than ever before. This episode explores the networks, tactics and technologies reshaping money laundering across the world. From romance scams and money mules to crypto and the metaverse, gain practical insight into how organised crime adapts to digital finance and global markets. You will learn: How money mules are recruited and used in laundering operations Why romance scams are still one of the fastest-growing financial crimes How hawala dealers move money across borders without physical transfers The role of jewellery, food, real estate and sport in laundering activity Why cryptocurrency is creating new compliance and detection challenges How criminals are exploiting virtual worlds and the metaverse Listen now. Host: Jacqueline Blondell, editor, CPA Australia Experts: Kris Wilson, from the Australian Federal Police's Joint Policing Cyber Crime Coordination Centre Brendan Thomas, AUSTRAC CEO Dr Milind Tiwari, senior lecturer the Australian Graduate School of Policing and Security at Charles Sturt University in Canberra Geoff Peck, a former fraud squad detective with Victoria Police's major Fraud Group, and managing director Forensic & Integrity Solutions 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. Stay tuned for episode three coming soon where we look at the new gatekeepers being recruited to join the fight against money laundering. 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:20 Could the metaverse and crypto become the next money laundering frontier? 00:43 Welcome to Crime by Numbers Episode 2 01:18 How do fake businesses, cash and invoices help launder money? 02:23 Why are accountants, lawyers, and gold dealers money laundering gatekeepers? 03:36 What is Hawala, and how does it move money without crossing borders? 05:22 How is soccer used for money laundering? 05:53 Why is the food industry vulnerable to money laundering and food fraud? 08:31 What crimes most commonly drive money laundering in Australia? 10:03 What is a money mule, and how are people recruited? 13:34 Why are crypto ATMs a growing money laundering risk? 14:40 Why does cryptocurrency make money laundering harder to detect? 15:26 How could the metaverse enable money laundering in the future? 16:54 What's next: who are the new gatekeepers fighting money laundering?

2 juin

•

17 min
1 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

1 mai

•

8 min
2025-07-15

How Hobart Airport leads on climate and sustainability

Climate change isn't a side issue for Hobart Airport. It's an integral part of its operations. In this episode, discover how the Tasmanian capital's airport integrates sustainability, including: How Hobart Airport identifies and mitigates climate-related risks Why sustainability is embedded across procurement, design and construction The role of circular economy practices in infrastructure projects How EV infrastructure is shaping the passenger experience The value of finance-led scenario planning in managing climate impact Dealing with external partners Future challenges for airports. Explore how the finance and commercial teams are central to planning and decision-making, using their strategic and analytical skills to manage risk and guide sustainable investment. Plus, find out how they know when it's time to bring in external expertise to manage complex risks. This episode is essential listening for those in finance, infrastructure and strategic planning who want to understand how sustainability can be effectively integrated into operational decision-making. Host: Patrick Viljoen, Sustainability Lead, Policy and Advocacy, CPA Australia Guest: Kate Gillies CPA, CFO at Hobart Airport Learn more about the executive leadership team running Hobart Airport, and its climate change adaptation plan. INTHEBLACK produces articles across a wide range of areas, including this story on climate risk and tourism. You can find a CPA at our custom portal on the CPA Australia website. Would you like to listen to more INTHEBLACK 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 INTHEBLACK Out Loud Excel Tips Search for them in your podcast platform. Email the podcast team at podcasts@cpaaustralia.com.au

2025-07-15

•

17 min
2023-09-01

Boost your skills with tips for Excel function updates

Excel is constantly evolving and improving, and it's crucial to stay up to date with all the latest changes. This companion podcast is here to help you sort quickly through the most relevant function updates. Are you ready to take your Excel skills to the next level? Tune in now. For fast access, use these timestamps: 0:29 Dynamic arrays 2:29 XLOOKUP 3:19 LET function 3:49 LAMBDA 4:56 TEXTAFTER, TEXTBEFORE and TEXTSPLIT 6:15 BYROW and BYCOL 7:00 the IMAGE function 7:45 VSTACK and HSTACK 8:31 TAKE and DROP functions 10:03 CHOOSEROWS and CHOOSECOLUMNS 10:34 DAX functions 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 INTHEBLACK Out Loud Excel Tips Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

2023-09-01

•

13 min
31 mars

From ledgers to the new AI world

Accounting has evolved dramatically, but its core purpose stays unchanged - enabling trust and better decision-making. In this episode, hosted by Australian comedian Lehmo, learn how the profession has moved from manual record keeping to a strategic role centred on judgement, governance and value creation. Additionally, explore why AI is transforming tools rather than replacing expertise. Key learnings from this episode: How accounting has evolved from bookkeeping to strategic decision support Why trust, integrity and governance sit at the centre of the profession How global crises have expanded the role of accountants over time The shift from financial data to broader enterprise data responsibilities Why AI enhances accounting rather than replacing it The growing importance of professional scepticism in an AI-driven world How accountants can contribute to AI governance and auditing Why communication and judgement remain critical skills What the next generation of accountants needs to succeed Listen now for more. Host: Anthony "Lehmo" Lehmann, popular Australian comedian Guests: Dr Jasvinder Sidhu, accounting academic and historian Kaushika Jayalath CPA, principal solutions consultant, Oracle, and a CPA Australia board member Head to Lehmo's site for more information on his services. And learn more about this episode's guests Kaushika Jayalath CPA and Dr Jasvinder Sidhu at his staff profile. Loving this episode? Listen to more INTHEBLACK episodes and other CPA Australia podcasts on YouTube. And don't forget to click subscribe on the channel. 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

31 mars

•

44 min
2024-11-05

Explore the new IFRS 18 and its impact on company reporting

Big changes are coming to financial reporting, and it's essential to stay informed. In this episode, unpack the transition from IAS 1 to IFRS 18, a shift that will significantly impact financial reporting over the coming years. Join two expert guests as they explore what this new standard means for organisations of all sizes. They'll break down the key differences between IFRS 18, which replaces IAS 1, discuss how this change will affect financial transparency, weigh the associated costs and benefits and more. Don't miss out on this crucial information ahead of this change. Tune in now to learn more about the future of financial reporting ahead of IFRS 18's rollout. Host: Tiffany Tan, External Reporting and Assurance Lead, CPA Australia Guests: David Hardidge FCPA, a financial reporting expert and a former Chair of the External Reporting Centre of Excellence at CPA Australia. Shaun Steenkamp CPA, a member of the External Reporting Centre of Excellence at CPA Australia. He works for Transurban and was previously with KPMG and NAB. Discover more insights on IFRS 18 with CPA Australia's External Reporting Centre of Excellence report Redefining the Bottom Line IFRS 18 And you can find a CPA at our custom portal on the CPA Australia website. Would you like to listen to more With Interest 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 INTHEBLACK Out Loud Excel Tips Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

2024-11-05

•

30 min
2023-06-01

22 Excel shortcuts to supercharge your efficiency

Unlock your Excel efficiency with these 22 time-saving shortcuts for everyday work tasks. Tune in now to supercharge your productivity. Timestamps: Files and folders: 1:05 Quick access toolbar: 4:17 Keyboard types: 7:20 Keyboard shortcuts: 9:06 Save as: 12:54 Control key: 13:45 More control key shortcuts: 14:46 Copying: 15:55 Date shortcut: 17:36 Control key combinations: 18:12 The ALT key: 19:46 Grouping: 21:39 Accessing the ribbon with ALT: 22:55 Remove filters: 24:45 Pasting values: 25:01 Queries and connections: 25:07 Digital validation dialog: 25:28 Mouse shortcuts: 25:54 The format painter: 26:42 Border navigation: 27:39 Double clicking the fill: 28:28 Right clicking: 29:14 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. There is also an accompanying online article and video of this podcast, which includes a tutorial and sample formulas. 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 app. You can email the podcast team at podcasts@cpaaustralia.com.au

2023-06-01

•

32 min

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

Site Web

CPA Australia

Meilleures émissions

How to create accounting reports with DAX

How microcultures can transform your workplace

3 ways to build tomorrow's CFOs

Crime By Numbers: How criminals launder money through today's networks

Template tips to boost workflows

How Hobart Airport leads on climate and sustainability

Boost your skills with tips for Excel function updates

From ledgers to the new AI world

Explore the new IFRS 18 and its impact on company reporting

22 Excel shortcuts to supercharge your efficiency

À propos

CPA Australia

Meilleures émissions

Meilleurs épisodes

À propos