Back to podcast

#7. Ep. 007 Array Functions with Alan Murray

Listen on Apple music

Ep. 007 Array Functions with Alan Murray

Alan Murray is a trainer, consultant, and community leader in Excel and Power BI. His resource site, https://www.computergaga.com/, and YouTube channel, https://www.youtube.com/computergaga, are some of the most valuable and respected on the Internet. In this conversation, we explore the benefits and possible use cases for a new suite of Excel functions – the Dynamic Array Functions. These functions – UNIQUE, SORT, SORTBY, FILTER, SEQUENCE, and RANDARRAY – work differently than any other function you’ve used before, and they represent a HUGE leap forward.

To see Alan in action as a trainer, check his playlist of tutorial videos about Dynamic Array Functions: https://www.youtube.com/watch?v=X2ybRZbvR5k&list=PLxv7tqbNjU9WP3oMeRKwNXwDYQilKjF-s

Enroll in Computergaga’s excellent online courses at: https://www.computergaga.com/online-courses/

Contact Alan directly at: admin@computergaga.com

For questions about the show, contact Neil at help@knacktraining.com

View more about this topic

Related everyday office posts

Youtube videos Building a Color-Coded Calendar Grid in Excel

Building a Color-Coded Calendar Grid in Excel

People are always badmouthing Excel and working in various new and powerful data visualization tools. In this video, we duplicate...

Youtube videos Going Text to ROWS with Power Query

Going Text to ROWS with Power Query

Text to Columns is a common tool in Excel (although the Text to Columns feature in Power Query, called Split...

Related recources

A Beginner’s Guide to Power Query

A Beginner’s Guide to Power Query

Power Query is Excel's new ETL tool - whether you’re talking about Excel or Power BI, when you extract, transform, and load the data into a report, you’re doing it with Power Query.