My productivity hack: https:\/\/www.magicmind.co\/mrexcel<\/a> Use my
\ncode MREXCEL20 for 20% off #magicmind<\/p>\n

Today, we take a look at analyzing YouTube stats year over year. Along the way, you will see:
\nUnpivoting KPI columns in Excel Power Query
\nCreating a pivot table in Excel
\nUsing the SEQUENCE function
\nXLOOKUP in Excel
\nCharting in Zebra BI for Office<\/p>\n

#productivitytips #productivityhacks #productivityatwork
\n#adhdmanagement #mondaymotivation #lifehack #inspiration #lifetips <\/p>\n

Table of Contents
\n(0:00) Welcome
\n(0:10) Magic Mind Challenge
\n(0:35) Szilvia, Rob, and Matcha
\n(0:51) Magic Mind Ingredients
\n(1:49) How does it taste
\n(2:35) Analyze YouTube Stats
\n(3:10) Power Query
\n(3:40) Unpivot KPI columns
\n(4:10) Pivot Table
\n(4:55) SEQUENCE function
\n(5:40) XLOOKUP function
\n(6:22) Adjust formula by dragging
\n(6:41) Slicer Shape
\n(7:09) Pivot Table Lock Column Widths
\n(7:23) Hide pivot table by grouping
\n(7:57) Comments
\n(8:45) Alt+Enter for 2-line comment
\n(9:16) Zebra BI Charts for Office
\n(9:33) 4 Charts
\n(9:55) Explaining the chart
\n(10:13) Views up 130%
\n(10:35) Using Chart Comments
\n(10:54) Gypsy Stock Arrows
\n(11:21) Impact YouTube Shorts
\n(11:57) Love Zebra BI
\n(12:12) Magic Mind Coupon
\n(12:27) 14 Days Challenge
\n(12:48) Play us out, Nancy!<\/p>\n","protected":false},"excerpt":{"rendered":"

My productivity hack: https:\/\/www.magicmind.co\/mrexcel Use my code MREXCEL20 for 20% off #magicmind Today, we take a look at analyzing YouTube stats year over year. Along the way, you will see: Unpivoting KPI columns in Excel Power Query Creating a pivot table in Excel Using the SEQUENCE function XLOOKUP in Excel Charting in Zebra BI for […]<\/p>\n","protected":false},"author":3,"featured_media":4673,"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,142,138],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2022\/10\/HWAYh4vLaao.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1dk","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4670"}],"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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=4670"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4670\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/4673"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=4670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=4670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=4670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}