CPA Australia

•

Kanaal • 4 programma’s

Carrières

Carrières

Tweemaal per maand
Onderwijs

Onderwijs

Bijgewerkt 1 jun
Zakelijk nieuws

Zakelijk nieuws

Tweewekelijks
Zakelijk

Zakelijk

Bijgewerkt 2 jun

1 jun

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 jun

•

10 min.
1 mei

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 mei

•

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.
02-03-2023

Excel tips: how to use the new data types feature

Today's episode examines the new data types feature in Microsoft Excel. There are four data types you can now import from the data ribbon, and that includes stock prices. To explain how you do all this is CPA Australia's Excel expert, Neale Blackwood. Listen 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. 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. You can email the podcast team at podcasts@cpaaustralia.com.au And you can read more of Neale's Excel articles online.

02-03-2023

•

16 min.
3 mrt

AQ for finance leaders

What do you do when there is no playbook? Many finance leaders have built their careers on accuracy, clarity and control. But today's operating climate is defined by uncertainty rather than stability. Market turbulence, rapid advances in AI, organisational redesign and ongoing talent constraints are converging at the same time. In this context, success depends on more than just IQ or EQ. It now also hinges on your adaptability quotient (AQ). In this episode, explore how finance professionals can build the capability to work confidently through ambiguity while preserving the discipline and standards that underpin strong accounting practice. You will learn: the difference between adaptability quotient (AQ) and adaptive leadership why change feels harder today and how complexity affects performance how to use the observation, interpretation and intervention model practical ways to avoid common thinking traps such as catastrophising and blame how to create psychological safety without lowering standards tools such as the balcony and dance floor perspective and the productive zone of disequilibrium. If you want to strengthen resilience, improve decision-making and lead confidently through uncertainty, this episode offers practical steps you can apply immediately. Host: Tahn Sharpe, Editor, CPA Australia. Guests: Catherine Althaus, professor at UNSW Canberra, and Kathryn McEwen, organisational psychologist. For more information, head to Kathryn McEwen's website. 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 mrt

•

21 min.
03-06-2025

Productivity tips for busy finance professionals

Time. It's one thing many busy professionals wish we had more of in our working days. Whether you're drowning in meetings or struggling to tick off your daily tasks, this episode is here to help. You'll find clear, actionable tips to help you work smarter and achieve your goals. You'll learn: Why "I'm busy" isn't the answer, and what you should focus on instead How to set realistic, achievable goals that drive real progress What professionals get wrong about productivity and how to fix it How to make meetings more meaningful – or remove them entirely The power of "Red Brick Thinking" and how it can change your day-to-day work How to use AI tools to boost efficiency If you're a CPA Australia member, business owner, finance lead or corporate professional, this episode will provide you with relevant tools to help you take back control of your calendar. Host: Christine Gounder, Digital Content Lead, Design and Build, CPA Australia Guest: Donna McGeorge, author and expert on productivity, meetings and time management For more information on this episode's guest and her books, head to Donna McGeorge's website. 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

03-06-2025

•

18 min.
01-12-2025

Unlock 7 underused Excel features you still need today

Handy new Excel features are added regularly – but some "older" functions are still particularly useful to your workflows. Smart power users know these older functions and their value – which is why this episode highlights some of the overlooked Excel features that are still valuable to your spreadsheet work today. Tips include: How multiple windows make it easier to copy and compare How the grouping feature works well with rows and columns How auto outline and subtotals automate structure and hierarchy in datasets Techniques for selecting visible cells to avoid errors during copying How custom lists save time and support non-alphabetic sorting This is a practical guide for anyone looking to sharpen their Excel capability, streamline reporting and improve their workflow efficiency. Listen 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 YouTube video of this episode. Read more of Neale's Excel articles on INTHEBLACK. 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. 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

01-12-2025

•

16 min.
04-01-2024

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

04-01-2024

•

17 min.
02-07-2023

Why Excel can be a university student's secret weapon

Are you a university student or recent graduate? Are you looking to gain a competitive edge in the job market, specifically in the fields of accounting and finance? Then this episode is what you need! Packed with practical advice tailored to your needs, it will equip you with valuable Excel tips that will enhance your employability as you move into your first accounting or finance role. Delve into the world of Excel and hear expert insights on how to leverage this powerful spreadsheet tool. Tune in now and unlock the secrets to succeeding with Excel. 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 Excel Tips Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

02-07-2023

•

26 min.
30-09-2024

Banishing the fear: A leader's guide to social media

Social media is here to stay, especially for leaders in today's digital world. But many still feel anxious about how to navigate it. In this episode, we'll explore the significance of personal branding and address some common concerns leaders have about social media. Our expert guest shares valuable insights on the relationship between personal and business social media, the evolving importance of social media guidelines in organisations and how enterprise social networks can enhance productivity and connection in a hybrid work environment. Join us to discover how you can confidently embrace social media, banish fears and elevate your leadership today. Host: Garreth Hanley, podcast producer, CPA Australia Guest: Rita Zonius, a strategic communication management professional (SCMP). She is a career communicator and digital workplace expert who specialises in helping people overcome their fear of social media. You can learn more about Rita on LinkedIn. Would you like to listen to more INTHEBLACK episodes? Head to CPA Australia's YouTube channel. And 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 INTHEBLACK Out Loud Excel Tips Search for them in your podcast platform. Email the podcast team at podcasts@cpaaustralia.com.au

30-09-2024

•

22 min.

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

Website

CPA Australia

Topprogramma’s

Why Excel macros still matter in 2026

Template tips to boost workflows

Increment dates easily in Excel

Excel tips: how to use the new data types feature

AQ for finance leaders

Productivity tips for busy finance professionals

Unlock 7 underused Excel features you still need today

How to master using different Excel techniques together

Why Excel can be a university student's secret weapon

Banishing the fear: A leader's guide to social media

Info

CPA Australia

Topprogramma’s

Topafleveringen

Info