https:\/\/www.mrexcel.com\/products\/master-your-data-with-power-query-in-excel-and-power-bi\/<\/a><\/p>\nTable of Contents
\n(0:00:00) Welcome
\n(0:00:12) #1 Congratulations Leila for 1 Million Subs
\n(0:00:17) #2 Excel is loading much faster
\n(0:00:25) #3 New way to open Browse
\n(0:00:32) #4 Find dialog shows options automatically
\n(0:00:40) #5 PivotTable Fields now will collapse like other task panes
\n(0:00:48) #6 Chris Webb shows how Cube Functions can now spill
\n(0:01:02) #7 Smooth Scrolling
\n(0:01:26) #8 Data Types Refresh Every 5 Minutes
\n(0:01:42) #9 Arrange workbooks in Windows 11
\n(0:02:29) #10 Sequel to M is for (Data) Monkey<\/p>\n","protected":false},"excerpt":{"rendered":"
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<\/p>\n","protected":false},"author":1,"featured_media":2394,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2021\/08\/W0vU24qx8aQ.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-Cl","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2377"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=2377"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2377\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/2394"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=2377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=2377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=2377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}