An update to the subscription version of Microsoft Excel has the LAMBDA function, which addresses a key challenge when using dynamic arrays.
To explain more about this functionality is Excel expert, Neale Blackwood CPA.
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:
Search for them in your podcast provider.
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 .