CPA Australia

•

Kanaal • 4 programma’s

Carrières

Carrières

Tweemaal per maand
Onderwijs

Onderwijs

Bijgewerkt 1 jul
Zakelijk

Zakelijk

Bijgewerkt 3 dgn geleden
Zakelijk nieuws

Zakelijk nieuws

Tweewekelijks

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 jul

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

1 jul

•

9 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.
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.
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.
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.
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.
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.
23-09-2025

Excel at 40: The spreadsheet that changed everything

For four decades, Microsoft Excel has been a cornerstone of accounting and finance. From basic calculations to complex modelling, it has transformed how professionals analyse data, solve problems and make decisions. To mark Excel's 40th birthday, Neale Blackwood CPA reflects on Excel's legacy and its impact on the profession. He shares his personal journey with Excel, explores its evolution from the early Mac days to the rise of AI and Python, and offers insights into why Excel remains essential in a tech-driven world. Listen now to learn: How Excel revolutionised accounting and finance workflows Key milestones in Excel's 40-year journey, including the rise of VBA, PivotTables and Power BI What Excel's future looks like in the age of AI, automation and cloud collaboration Why Excel is still a must-have skill for finance professionals Whether you're building financial models, exploring automation or simply aiming to sharpen your Excel skills, this episode offers insights into the past, present and future of the world's most important app for accounting and finance professionals. Host: Tahn Sharpe, editor, INTHEBLACK, CPA Australia Guest: Neale Blackwood CPA, accountant, author and Excel traine Listen to our Excel Tips podcast here https://www.cpaaustralia.com.au/tools-and-resources/podcasts/excel-tips You can read Neale Blackwood's Excel Tips column on the INTHEBLACK website here https://intheblack.cpaaustralia.com.au/technical-skills 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

23-09-2025

•

22 min.
01-08-2023

Unlock 14 expert tips for Excel formulas

Unleash your Excel skills by using the valuable functionality of formulas. Go straight to episode sections: The formula bar – 1:06 Starting formulas – 1:41 Using functions – 2:58 Function arguments – 4:09 Relative and absolute cell and range references – 7:15 The calculation sequence – 9:46 Parentheses (brackets) – 10:39 Colours in formulas – 12:37 Entering cell and Range references – 13:50 The Function Wizard – 15:57 Formula auditing – 17:01 IF error – 19:12 REF error – 20:01 Dynamic arrays and the SPILL error – 20:26 Tune in now to level up with these expert shortcuts and techniques. 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

01-08-2023

•

24 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

How to create accounting reports with DAX

Template tips to boost workflows

Excel tips: how to use the new data types feature

Unlock 7 underused Excel features you still need today

Productivity tips for busy finance professionals

AQ for finance leaders

How to master using different Excel techniques together

Excel at 40: The spreadsheet that changed everything

Unlock 14 expert tips for Excel formulas

Info

CPA Australia

Topprogramma’s

Topafleveringen

Info