Ten really short Excel topics jammed into one 188-second video.
Cube Functions spill – article by Chris Webb is at https://blog.crossjoin.co.uk/2021/07/28/excel-cube-functions-dynamic-arrays-and-lambdas-part-1-getting-all-the-items-from-a-set/
Read more about the new Power Query book at https://www.mrexcel.com/products/master-your-data-with-power-query-in-excel-and-power-bi/
Table of Contents
(0:00:00) Welcome
(0:00:12) #1 Congratulations Leila for 1 Million Subs
(0:00:17) #2 Excel is loading much faster
(0:00:25) #3 New way to open Browse
(0:00:32) #4 Find dialog shows options automatically
(0:00:40) #5 PivotTable Fields now will collapse like other task panes
(0:00:48) #6 Chris Webb shows how Cube Functions can now spill
(0:01:02) #7 Smooth Scrolling
(0:01:26) #8 Data Types Refresh Every 5 Minutes
(0:01:42) #9 Arrange workbooks in Windows 11
(0:02:29) #10 Sequel to M is for (Data) Monkey