How to do dynamic arrays (subscription version) - podcast episode cover

How to do dynamic arrays (subscription version)

Mar 16, 202310 min
--:--
--:--
Download Metacast podcast app
Listen to this episode in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episode description

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 .

For the best experience, listen in Metacast app for iOS or Android