CPA Australia

•

Channel • 4 Shows

Education

Education

Updated Aug 3
Business News

Business News

Updated Semimonthly
Business

Business

Updated Aug 27
Careers

Careers

Updated Monthly

Jul 1

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
12/17/2024

Unlock the power of structured philanthropic giving

Explore the transformative world of structured philanthropic giving. Discover the strategies, benefits and tax implications of this impactful approach, paired with real-life stories showcasing how structured giving creates meaningful change. Unpack how to measure social impact effectively and learn actionable tips for integrating philanthropy into your financial or organisational plan. Whether you're an individual passionate about making a difference or a business aiming to drive social impact, this episode provides the inspiration and knowledge to amplify your giving. Tune in to learn how structured philanthropy can align your values with measurable results. Host: Ram Subramanian, external reporting lead, policy and advocacy, CPA Australia Guest: Judith Fiander, CEO of Australian Philanthropic Services (APS) a not-for-profit organisation specialising in structured giving and philanthropy. You can learn more about APS services at its website. 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
12/22/2024

INTHEBLACK: Uncovering the staggering cost of food waste

Did you know that in Australia alone 312kg of food per person, per year is thrown away? In fact, food waste costs the Australian economy around $36.6 billion each year. Australian households spend around $2500 every year on food that's wasted. And most of that ends up in landfills. This episode explores the underlying causes that contribute to such shocking food waste and looks at some effective solutions that can be implemented to address the problem. Tune in now. Host: Garreth Hanley, CPA Australia Guest: Terence Jeyaretnam, an environmental engineer and Partner at EY in the Climate Change and Sustainability practice, based in Melbourne For more on today's topic, head to the National Food Waste Strategy, which aims to halve Australia's food waste by 2030. Further guidance is available on the Department of Climate Change, Energy, the Environment and Water site. Additional information: Reducing Australia's Food Waste by half by 2030 Food waste costs Australian households up to $3,000 a year Coles promised to feed Australian families for $10 in 2017. Can it still be done in 2023? 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
03/01/2023

International Women's Day 2023 special

Today's episode explores this year's International Women's Day theme, "Cracking the code: innovation for a gender-equal future". Offering her thoughts on how women can #crackthecode to success at work is special guest Georgie Williams, board president of UN Women Australia. Listen now. Host: Jackie Blondell, CPA Australia Editor Guest: Georgie Williams, a professional director who serves on several boards. She has over 25 years' experience in banking and superannuation including roles as Group Executive Engagement, Advocacy and Brand at Australian Super, and Head of Brand and Marketing at the Bank of Melbourne. She has also held executive positions at NAB in Australia and the UK, including roles in the commercial banking, wealth, strategy and marketing departments. 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 provider. You can email the podcast team at podcasts@cpaaustralia.com.au International Women's Day (IWD) is a global day celebrating the social, economic, cultural and political achievements of women. And head online for more information on UN Women Australia
02/20/2023

How to give your career a boost

Today's episode explores expert strategies for rebooting and refreshing your accounting and finance career. We share advice and tips on how you can leverage skills and experiences to give your career a boost. Offering their insights are our two guest experts. Dan Auerbach, Founder and CEO of leading Australian corporate psychology consultancy EAP and Michelle Gibbings, a workplace expert and former transformation manager at retail wealth management and banking business AMP, and National Australia Bank (NAB). Listen now. To further help guide your career, CPA Australia's Career Navigator Tool is a useful resource to discover in-demand skills. Additionally, there are CPA Australia micro-credentials relevant to this podcast episode that will fast-track your learning and sharpen your skills for an evolving industry. And for insightful reading, delve into the INTHEBLACK digital magazine special careers edition to help elevate your career today. Host: Jessica Mudditt, book author, freelance journalist and regular contributor to CPA Australia's award-winning INTHEBLACK magazine. Guests: Dan Auerbach, Founder and CEO of leading Australian corporate psychology consultancy EAP Michelle Gibbings, a workplace expert and former transformation manager at retail wealth management and banking business AMP and National Australia Bank (NAB). 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
03/29/2023

Meet the "hacker" protecting you from cyber threats

Penetration testers hack into your company servers. Don't worry – these are friends who can help your company stay safe from the dark web's cyberthreats. "Pen testers" do it to protect you from the real hackers out there trying to steal your data. In this episode we meet a lead penetration tester. Learn what he does, how he does it and how you can improve your own organisation's cyber security. Don't miss this episode if data security is a priority in your company. Host: Garreth Hanley, podcast producer, CPA Australia Guest: Dan Weis, Practice Lead - Penetration Testing, Nexon Asia Pacific For more CPA Australia has its own cyber security resources and support. You can also check out the Australian Cyber Security Centre (ACSC) which has useful information for small and medium businesses. If you have been hacked there is online support and you can phone 1300CYBER1 For global news and security events Linkedin.com scamwatch.gov.au AusCERT The Hacker News Discord channels and Twitter For vendor security notification feeds SANS @RISK Microsoft Security Blog Microsoft security intelligence Google Online Security Blog (googleblog.com) Safety & Security | Google Blog Cybersecurity Alerts & Advisories | CISA 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 platform. You can email the podcast team at podcasts@cpaaustralia.com.au
04/07/2025

AI and cybersecurity: penetration tester reveals key dangers

As organisations big and small integrate artificial intelligence into their operations, understanding the vulnerabilities that come with AI systems is essential. In this episode, we'll explore the crucial intersection between AI and cybersecurity. You'll gain insights on AI systems, common pitfalls in AI security and specialist tips for businesses to navigate this dynamic landscape. This episode covers areas such as: Adversarial machine learning (AML) The fundamental difference between AI and IT security AI model vulnerabilities Expanded attack surface via unstructured inputs Key pitfalls in AI adoption Risk mitigation Tune in now for specialist advice from a leading expert in the field. Host: Garreth Hanley, Podcast Producer, CPA Australia Guest: Miranda R, an offensive security team manager at Malware Security, and an AI vulnerability researcher and a trainer with Mileva, where she conducts penetration testing for various sectors, including government and private industry. Want to learn more? Head online to Malsec and Mileva. And you can read an insightful post by Miranda R on her LinkedIn, as well as a news story about an ID system failure in the US involving a fraudster and how a North Korean hacker duped a cybersecurity firm. 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
02/15/2023

How to never stop learning

Today's episode looks at how accounting and finance professionals can upskill across their careers, with tips and strategies on how to overcome common roadblocks to learning. Offering their insights and advice are our two guest experts. Shelley Laslett, CEO and co-founder of Vitae Coach, which uses brain-based coaching based on neuroscience. And Huw Thomas, Director, Head of Offerings, Thought Leadership and Capability Development at Blue Seed Consulting Listen now. To further help guide your career, CPA Australia's Career Navigator Tool is a useful resource to discover in-demand skills. Additionally, there are CPA Australia micro-credentials relevant to this podcast episode that will fast-track your learning and sharpen your skills for an evolving industry. And for insightful reading, delve into the INTHEBLACK digital magazine special careers edition to help elevate your career today. Host: Jessica Mudditt, book author, freelance journalist and regular contributor to CPA Australia's award-winning INTHEBLACK magazine. Guests: Shelley Laslett, CEO and co-founder of Vitae Coach, which uses brain-based coaching based on neuroscience. Huw Thomas, Director, Head of Offerings, Thought Leadership and Capability Development at Blue Seed Consulting 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
08/21/2024

Ethical intelligence for accountants

Ethics are a cornerstone of the accounting profession. In this episode, an ethical intelligence specialist explores the challenges accountants and finance professionals face in relation to ethics. Gain practical advice on how you can avoid common ethics pitfalls and how to develop and apply ethical intelligence to ensure compliance with the APES 110 code. Dive into real-world examples of how accountants have violated key principles – integrity, objectivity, competence, confidentiality and professional behaviour – and learn how to avoid these scenarios. Listen now for an expert ethics guide. Host: Belinda Zohrab-McConnell, regulations and standards lead, CPA Australia Guest: Brendan O'Connell FCPA, an expert in corporate governance, ethics, and accounting with experience in academia and industry. He is a member of the Ethics and Governance Centre of Excellence at CPA Australia and has conducted extensive research and provided consulting services to both government agencies and corporations. For more guidance on APES 110 Code of Ethics for Professional Accountants (including Independence Standards) head to the APESB 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
05/20/2024

Exploring National Reconciliation Week

In this in-depth discussion, CPA Australia leaders share their perspectives and explore ideas around ways that we can achieve reconciliation together. They outline why an organisation like CPA Australia is involved in this issue and explain the relevance of reconciliation to accountants and finance professionals. Listen now. Host: Adrienne Biscontin, external affairs adviser, policy and advocacy, CPA Australia Guests: Dale Pinto FCPA, CPA Australia president and chair and John Curtin distinguished professor, and Shane Miller CPA, deputy chair of CPA Australia's Indigenous Advisory Group For more information on today's topic, head to CPA Australia's reconciliation page and to the Reconciliation Australia homepage. 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

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

Website

CPA Australia

Top Shows

How to create accounting reports with DAX

Unlock the power of structured philanthropic giving

INTHEBLACK: Uncovering the staggering cost of food waste

International Women's Day 2023 special

How to give your career a boost

Meet the "hacker" protecting you from cyber threats

AI and cybersecurity: penetration tester reveals key dangers

How to never stop learning

Ethical intelligence for accountants

Exploring National Reconciliation Week

About

CPA Australia

Top Shows

Top Episodes

About