CPA Australia

•

Kanal • 4 programmer

Utdannelse

Utdannelse

-2 d.
Økonomi

Økonomi

9. juni
Karriere

Karriere

Månedlig
Næringslivsnyheter

Næringslivsnyheter

Annenhver uke

1. juni

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. juni

•

10 min
30.09.2024

How to add a user interaction into Power Query

Reports are crucial to your work, aren't they? Power Query is a valuable tool for importing many types of data into Excel to help you create these reports. However, it does have limitations. In this episode, you'll learn how to address one of Power Query's key shortcomings: user interactions. By using staging queries, reference techniques and range names, users can dynamically filter data within Power Query based on user-selected criteria. For fast access, use these timestamps: 0:17 – About the variable Power Query function 3:37 – Implementing the query function 5:46 – Using a range name for a table 7:07 – Using a query to read the variable input 9:43 – Refreshing the power query 10:11 – Recap and use cases Listen now to learn how to add a user interaction into Power Query. 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: INTHEBLACK INTHEBLACK Out Loud With Interest Excel Tips Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

30.09.2024

•

12 min
12.08.2025

Hays 2025 Salary Guide reveals top finance job trends

Today's finance job market trends are revealed with key findings from the Hays 2025 Salary Guide explored in this episode. Key takeaways include: Which finance roles and industries offer the best rewards in Australia and New Zealand Trends in finance job satisfaction across salary levels and generations The impact of AI on the recruitment process The gender pay gap Current skills shortages Advice for job seekers Whether you're a finance professional navigating career choices or a recruiter adapting to new hiring realities, this episode offers practical insights, advice and strategies. Host: Jacqueline Blondell, Content Editor, CPA Australia Guest: Shane Little, Managing Director, Enterprise Solutions APAC, Hays Links: The Hays 2025 Salary Guide is available online. And you can listen to more INTHEBLACK episodes and other CPA Australia podcasts on YouTube. 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

12.08.2025

•

20 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
29.02.2024

How to automate report building in Excel

Are you an accountant or finance professional looking to enhance your daily workflows? Don't miss this episode, which delves into the exciting capabilities of dynamic arrays, empowering you to effortlessly build automated reports. For fast access, use these timestamps: The tutorial example report, and companion file 1:50 Dynamic array calculation and spill ranges 3:12 Referring to a spill range 4:05 Building a structure to avoid spill errors 6:59 Dynamic array formula tips 8:22 Benefits of range formulas in limiting formulas 8:47 Changing table structure to suit ranges and reporting 9:35 Overview of the benefits of dynamic arrays 10:31 Tune in now to learn more about this exciting addition to Excel's subscription version. 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: INTHEBLACK INTHEBLACK Out Loud With Interest Excel Tips Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

29.02.2024

•

12 min
02.02.2025

New tool explained: boost your efficiency with checkboxes

Ready to unlock a hidden gem in your Microsoft Excel subscription? In this episode you'll discover the power of checkboxes with practical examples to explore how this new function can streamline your workflow. This includes how to use TRUE/FALSE values in formulas and conditional formatting to dynamically control calculations and visuals. Learn from examples such as inflation adjustments in a budget model and applying a strikethrough format to a to-do list. Additionally, gain insight into how checkboxes are used in the logical test of the IF function and learn essential keyboard shortcuts for an efficiency boost. For fast reference, use the episode timestamps: 00:21 Introducing the new checkbox feature  01:03 How checkboxes work in Excel  02:35 Using checkboxes in budget models  03:23 Keyboard shortcuts for checkboxes  04:19 Protecting checkbox cells 04:50 Checkboxes with the IF function 05:32 Using checkboxes for task management 07:55 Checkboxes in formatted tables 09:20 Conclusion and further resources You'll find the new checkboxes function in the insert ribbon between illustrations and charts in the subscription version. Level up your Excel game by tuning 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: INTHEBLACK INTHEBLACK Out Loud With Interest Excel Tips Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

02.02.2025

•

10 min
23.03.2023

How to use custom functions without macros

Along with the LAMBDA function, other new functions make Excel's function language behave more like a programming language. Which can help you in various ways. Want to learn more? Excel expert Neale Blackwood CPA steps you through. Listen 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 three podcasts, providing commentary and thought leadership across business, finance, and accounting: With Interest INTHEBLACK Excel Tips Search for them in your podcast platform. Email the podcast team at podcasts@cpaaustralia.com.au And you can read the accompanying online article of this podcast. Other Excel articles by Neale can be read on the INTHEBLACK website .

23.03.2023

•

12 min
31.03.2025

Elevate your Pareto analysis skills with Excel

The Pareto principle is a powerful concept for business. In this episode we'll explore this principle (also known as the 80/20 rule) and learn how to apply it effectively in Excel for smarter, data-driven decisions. Discover how to pinpoint vital data – such as the 20 per cent of clients generating 80 per cent of your revenue as an example – to create valuable insights. We'll also dive into Excel's powerful analytical tools, including Pareto charts, the UNIQUE function, SUMIFS, and the power of PivotTables to bring your Pareto analysis data to life. You'll understand how to combine these features with techniques such as conditional formatting and custom charting to segment your data, visualise the 80/20 distribution and prioritise your efforts for maximum effect. For fast reference, use the episode timestamps: 0:07 – Introduction to the Pareto principle and Excel 0:40 – Explanation of the 80/20 rule 1:10 – Background on Pareto and the principle 1:40 – Overview of Excel features related to Pareto analysis 2:25 – Explanation of the Pareto chart 3:25 – Limitations of the built-in Excel Pareto chart 4:00 – Creating a combo chart to mimic the Pareto chart 4:15 – Use of UNIQUE, SORT and SUMIFS functions in Pareto analysis 4:45 – Overview of pivot tables and their role in Pareto analysis 5:10 – Adding cumulative percentage to pivot tables 6:25 – Tracking client progression over time with Pareto analysis 6:55 – Using pivot table filters to identify top 80% clients 7:45 – Introduction to slicers in pivot tables for segmentation 8:22 – Segmentation with formulas and the FILTER function 8:43 – Overview of conditional formatting related to Pareto analysis 9:05 – Adding interaction to conditional formats 9:44 – Importance of investigating the universality of the 80/20 rule 10:00 – Conclusion and encouragement to focus on key factors in analysis Listen to this episode now to gain practical tips and techniques to apply the Pareto principle across various business scenarios, helping you work smarter, not harder. 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. You can find a CPA at our custom portal on the CPA Australia website. Would you like to listen to more Excel Tips 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

31.03.2025

•

11 min
01.08.2025

Python in Excel: Practical applications

In this second episode of a three-part series, you will build on the basics from part one to gain a clear understanding of how to use Python directly within Excel cells. This includes using the Pandas library, for example, to merge datasets and create data-rich outputs with minimal code. You'll gain the skills to: Learn key differences between Excel formulas and Python syntax Discover practical coding shortcuts and structure for writing Python in Excel Deploy a step-by-step process to create a merged table with sales and GST calculations Use the Pandas library to work with Excel tables (called 'data frames' in Pandas) Understand how Excel loads other common libraries like NumPy and Matplotlib Whether you're an accountant, analyst or finance leader, this episode will help you unlock more value from your Excel spreadsheets by integrating efficient Python-powered workflows. 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. You can listen to part one of this three-part series on Python in Excel as well as read the accompanying article for part one. The article for this episode is also available online at INTHEBLACK. And you can read more of Neale's Excel articles for INTHEBLACK. You can find a CPA at our custom portal on the CPA Australia website. Would you like to listen to more Excel Tips 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 Excel Tips INTHEBLACK Out Loud Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

01.08.2025

•

11 min
02.01.2025

Improve your PDF data handling with Power Query

Ever struggled to extract crucial financial data from PDF files into Excel? As accountants and finance professionals, this can be a regular occurrence. To help you, this episode explores Microsoft Excel's Power Query feature. You'll uncover how to seamlessly import data from system-generated PDFs like invoices and statements. From tackling tricky formatting issues to cleaning up messy rows, learn through real-world examples using an Australian Tax Office (ATO) PDF as a case study. Additionally, you'll gain smart strategies for handling regularly updated PDFs to automate your workflows. For fast access, use these timestamps: 0:17 - Introduction to Importing Data from PDFs using Excel's Power Query feature. 0:37 - Types of PDFs and Their Reliability 1:05 - Use Cases for Importing PDF data 3:17 - Accessing Power Query and Importing a PDF 4:15 - Tables vs. Pages in PDFs 5:40 - The Complexity of Importing PDF Data 6:25 - Removing Repeated Headers 7:05 - Addressing Errors and Dealing with Extra Rows 9:20 - Creating a Filter Column 9:45 - Reversing Rows Again 10:05 - PDF File Names 11:20 - Reusing Power Queries 11:42 - Conclusion If you're ready to save time and streamline your data handling processes, this episode is a must-listen. 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

02.01.2025

•

13 min

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

Nettsted

CPA Australia

Populære programmer

Why Excel macros still matter in 2026

How to add a user interaction into Power Query

Hays 2025 Salary Guide reveals top finance job trends

How to master using different Excel techniques together

How to automate report building in Excel

New tool explained: boost your efficiency with checkboxes

How to use custom functions without macros

Elevate your Pareto analysis skills with Excel

Python in Excel: Practical applications

Improve your PDF data handling with Power Query

Om

CPA Australia

Populære programmer

Populære episoder

Om