loader from loading.io

Excel Yourself: Use LET function to solve tricky Excel challenges

CPA Australia Podcast

Release Date: 11/05/2021

COVIDChat: Navigating the impact of Omicron on the workplace show art COVIDChat: Navigating the impact of Omicron on the workplace

CPA Australia Podcast

As we enter the third year of the pandemic, employers across Australia have once again had to backtrack on their reopening plans due to the spread of the Omicron variant. In this episode, we explore how employers can adapt to the rapidly changing rules and regulations around COVID-19, and the role of employers in the provision of RATs for employees, booster mandates, flexibility around sick leave, and creating a safe work environment. 

info_outline
Excel Yourself: How to handle formula errors in Excel using IFERROR show art Excel Yourself: How to handle formula errors in Excel using IFERROR

CPA Australia Podcast

As part of the Excel Yourself CPA Australia Podcast series, hear how If you create a formula and then realise it needs to handle errors, you need to insert the IFERROR function at the start of your formula.

info_outline
COVIDchat: Survey results - Business concerns intensify amid strong recovery show art COVIDchat: Survey results - Business concerns intensify amid strong recovery

CPA Australia Podcast

In this week’s episode, our experts discuss the results of a recent CPA Australia survey of business and economic sentiment. Despite restrictions easing and a strong economic recovery, businesses are concerned about workforce shortages, increasing costs, supply difficulties and uncertainty about the management of future COVID-19 outbreaks.

info_outline
Audit failings: Implications for Halifax collapse show art Audit failings: Implications for Halifax collapse

CPA Australia Podcast

In this podcast episode, join our experts as they discuss how a Sydney auditor and an audit firm’s failure to comply with auditing standards contributed to the collapse of Halifax Investment Services. You will hear why auditors are important gatekeepers within the wider financial reporting system.

info_outline
COVIDChat: Current trends in accounting recruitment show art COVIDChat: Current trends in accounting recruitment

CPA Australia Podcast

In this week’s episode of COVID Chat, we’re joined by Peter Bourke, a senior talent acquisition lead with Accountancy Options. Peter gives us an insider’s perspective on current trends in accounting recruitment, his tips for employers and employees, as well as his predictions for 2022. Listen now.

info_outline
Professional indemnity insurance: how to lower your risk profile  show art Professional indemnity insurance: how to lower your risk profile

CPA Australia Podcast

In this podcast episode, you’ll get insights into the changing risk profile of accounting firms that cope with the impact of the pandemic on their day-to-day operations, and managing clients in financial difficulty.

info_outline
COVIDchat: COVID-19’s impact on commercial insurance  show art COVIDchat: COVID-19’s impact on commercial insurance

CPA Australia Podcast

In this podcast, our special guest Tony Jackson from QBE Insurance Group shares his insights into the challenges posed by the pandemic on commercial insurance, including which sectors were hit hardest. You'll also hear about business interruption claims, a global upswing in insurance premiums and government subsidised insurance.

info_outline
COVIDchat: Should you worry about inflation? show art COVIDchat: Should you worry about inflation?

CPA Australia Podcast

In this episode, we take a deep dive into the reasons driving inflation in Australia and across the globe and its potential impacts on consumer confidence, business and interest rates. We also share suggestions for businesses on managing the impact of inflation. 

info_outline
Insights from the NZ FMA’s Audit Quality Monitoring Report 2021 show art Insights from the NZ FMA’s Audit Quality Monitoring Report 2021

CPA Australia Podcast

In this episode, Jacco Moison from the FMA talks with Claire Grayston FCPA about how well audit firms managed under the restrictions of COVID-19, the uptake of technology, how firms have responded to the key findings and examples of best practice.

info_outline
International Accounting Day: The role of accountants in 2021 and beyond show art International Accounting Day: The role of accountants in 2021 and beyond

CPA Australia Podcast

On International Accounting Day we speak to three professional accountants operating in diverse sectors. In this episode, you will hear about the changing role of professional accountants in 2021. Our guests share how Covid-19 has expanded the role of an accountant to that of a trusted advisor, the importance of staying relevant in an age of automation and enhancing their complementary skills.

info_outline
 
More Episodes

As part of the Excel Yourself CPA Australia Podcast series, hear how the LET function offers useful solutions to tricky Excel challenges.