Skip to main content
AmigoFish

Bye-Bye Cells as We Know Them? Excel's Big NEW Feature!

From MyOnlineTrainingHub · · 17 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Excel's new Lists and Arrays feature lets a single cell hold multiple values or an entire table. See how to filter individual items and calculate with the data stored inside those cells. ⬇️ Download the example file here and follow along: https://bit.ly/listsarrays26file 👩‍🏫 Become an Excel Expert with my course: https://bit.ly/listsarrays26course

This video was recorded using the Beta Channel preview for Microsoft 365 Insiders. These features may not be available in your version of Excel.

I use supplier categories and candidate skills to show how lists keep related values together while letting you find individual items. You'll also see how to store a CSV dataset in one cell and calculate with its contents.

We start with creating lists using Ctrl+J, then build up to:

- Filtering individual list items, including how OR and AND conditions work. - Expanding lists with FLATTEN and combining it with UNIQUE, SORT and XLOOKUP. - Checking for matches with HAS, HASANY and HASALL. - Returning product lists by category with GROUPBY. - Summarizing customer satisfaction scores with PIVOTBY. - Calculating purchase order totals from nested arrays using LET, MAP and LAMBDA.

I also cover the integration gaps demonstrated in this preview, including PivotTables and Power Query.

LEARN MORE ===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up

🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS ============== 0:00 An entire table inside one Excel cell 0:38 The basics: lists, arrays and nested arrays 2:52 Filter the items inside a cell 4:46 Turn lists into useful results with FLATTEN 7:09 Match one item, any item or every item 9:11 Analyze a dataset stored in one cell 11:48 Summarize survey scores with PIVOTBY 12:54 Advanced: calculate with nested arrays 16:26 What doesn't work with lists and arrays yet

#Excel #ExcelTutorial #ExcelTips

Back to MyOnlineTrainingHub · Report a problem