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