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