How to Simplify Nested IF Functions in Excel using SWITCH

>> DOWNLOAD LINK 🎞️ #1 <<

>> DOWNLOAD LINK 🎞️ #2 <<

>> COPY / PASTE LINK PLEASE 🎵 MP3 <<

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=BLaXRIomA8Y

Disclaimer/Disclosure: Some of the content was synthetically produced using various Generative AI (artificial intelligence) tools; so, there may be inaccuracies or misleading information present in the video. Please consider this before relying on the content to make any decisions or take any actions etc. If you still have any concerns, please feel free to write them in a comment. Thank you. • --- • Summary: Learn how to replace complicated nested IF functions with the SWITCH function in Excel to make your formulas more readable and easier to manage. • --- • How to Simplify Nested IF Functions in Excel Using SWITCH • If you're an intermediate or advanced Excel user, you've likely encountered situations where you needed to employ multiple nested IF functions to handle complex decision-making processes. While the nested IF function is powerful, it can also be cumbersome and difficult to manage, especially when dealing with numerous conditions. Luckily, Excel offers an alternative: the SWITCH function. • Understanding the Nested IF Functions • Nested IF functions are used to handle multiple conditions. A simple nested IF might look something like this: • [[See Video to Reveal this Text or Code Snippet]] • While necessary for complex decisions, such formulas can become difficult to read and debug as the number of conditions increases. • Introducing the SWITCH Function • The SWITCH function is designed to allow more straightforward, readable formulas when dealing with multiple conditions. Unlike nested IF, which tests conditions sequentially, SWITCH evaluates a single expression and returns a result corresponding to the first matching value. • Syntax of the SWITCH Function • The basic syntax for the SWITCH function is: • [[See Video to Reveal this Text or Code Snippet]] • expression: The value or expression to evaluate once. • value1, value2, ...: Potential values of the expression. • result1, result2, ...: Results corresponding to each value. • default: An optional value to return if no match is found. • Example of SWITCH in Action • Let's consider how to rewrite the earlier nested IF example using SWITCH: • [[See Video to Reveal this Text or Code Snippet]] • Here, if the value in cell A1 is Apple , the function returns Fruit . If A1 is Carrot , it returns Vegetable . If none of the specified conditions are met, it defaults to Unknown . • Advantages of Using SWITCH • Readability: SWITCH provides a cleaner and more intuitive way to handle multiple conditions compared to nested IF functions. • Reduced Errors: Simplified syntax reduces the risk of errors that are common with multiple nested IF statements. • Maintaining Formulas: Easier to update and manage complex formulas over time. • Comparison: Nested IF vs. SWITCH • To illustrate the practical advantages, let’s look at a more complex example. A nested IF might look like this: • [[See Video to Reveal this Text or Code Snippet]] • The equivalent SWITCH statement is: • [[See Video to Reveal this Text or Code Snippet]] • Even at this relatively simple level, the SWITCH function is noticeably more concise and decipherable. • Conclusion • The SWITCH function is a powerful tool for anyone looking to streamline complex multiple-conditional formulas in Excel. By replacing cumbersome nested IF statements with SWITCH, you achieve better readability, reduce errors, and make your workbooks easier to maintain. • Next time you find yourself embroiled in a cascade of IF statements, consider giving SWITCH a try. Your future self will thank you!","styleRuns":[{"startIndex":0,"length":3507,"styleRunExtensions":{"styleRunColorMapExtension":{"colorMap":[{"key":"USER_INTERFACE_THEME_DARK","value":4294967295},{"key":"USER_INTERFACE_THEME_LIGHT","value":4279440147}]}},"fontFamilyName":"Roboto"}]},"headerRuns":[{"startIndex":0,"length":3507,"headerMapping":"ATTRIBUTED_STRING_HEADER_MAPPING_UNSPECIFIED"}]}},{"itemSectionRenderer":{"contents":[{"continuationItemRenderer":{"trigger":"CONTINUATION_TRIGGER_ON_ITEM_SHOWN","continuationEndpoint":{"clickTrackingParams":"CLkBELsvGAIiEwj63OuNzuqLAxUR0UIFHVbWMFo=","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/next"}},"continuationCommand":{"token":"Eg0SC0JMYVhSSW9tQThZGAYyJSIRIgtCTGFYUklvbUE4WTAAeAJCEGNvbW1lbnRzLXNlY3Rpb24%3D","request":"CONTINUATION_REQUEST_TYPE_WATCH_NEXT"}}}}],"trackingParams":"CLkBELsvGAIiEwj63OuNzuqLAxUR0UIFHVbWMFo=","sectionIdentifier":"comment-item-section","targetId":"comments-section"}}],"trackingParams":"CLgBELovIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},"secondaryResults":{"secondaryResults":{"results":[{"compactVideoRenderer":{"videoId":"DD15w8FFi18","thumbnail":{"thumbnails":[{"url":"https://i.ytimg.com/vi/DD15w8FFi18/hqdefault.jpg?v=672d9568 sqp=-oaymwEbCKgBEF5IVfKriqkDDggBFQAAiEIYAXABwAEG rs=AOn4CLBcUdw3a9gCHboTHTnZYYla95bZjQ","width":168,"height":94},{"url":"https://i.ytimg.com/vi/DD15w8FFi18/hqdefault.jpg?v=672d9568 sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg== rs=AOn4CLDKDDLn_t0kILfxrzhq2oVr7e-s5g","width":336,"height":188}]},"title":{"accessibility":{"accessibilityData":{"label":"432Hz- Fall Into Deep Healing Sleep, Regenerates Body and Mind, Emotional and Physical Healing by Inner Healing Energy 5,809,484 views"}},"simpleText":"432Hz- Fall Into Deep Healing Sleep, Regenerates Body and Mind, Emotional and Physical Healing"},"longBylineText":{"runs":[{"text":"Inner Healing Energy","navigationEndpoint":{"clickTrackingParams":"CLIBEKQwGAAiEwj63OuNzuqLAxUR0UIFHVbWMFo=","commandMetadata":{"webCommandMetadata":{"url":"/@InnerHealingEnergy_","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCp41xIZlfELOgxHMDFAKpRA","canonicalBaseUrl":"/@InnerHealingEnergy_"}}}]},"viewCountText":{"runs":[{"text":"1,861"},{"text":" watching"}]},"navigationEndpoint":{"clickTrackingParams":"CLIBEKQwGAAiEwj63OuNzuqLAxUR0UIFHVbWMFpIxoeY0cjopdsEmgEFCAEQ-B0=","commandMetadata":{"webCommandMetadata":{"url":"/watch?v=DD15w8FFi18","webPageType":"WEB_PAGE_TYPE_WATCH","rootVe":3832}},"watchEndpoint":{"videoId":"DD15w8FFi18","nofollow":true,"watchEndpointSupportedOnesieConfig":{"html5PlaybackOnesieConfig":{"commonConfig":{"url":"https://rr2---sn-nvm-cxb6.googlevideo.com/initplayback?source=youtube oeis=1 c=WEB oad=3200 ovd=3200 oaad=11000 oavd=11000 ocs=700 oewis=1 oputc=1 ofpcc=1 msp=1 odepv=1 id=0c3d79c3c1458b5f ip=2a02%3A27aa%3A0%3A0%3A0%3A0%3A0%3Ad49 initcwndbps=1851250 mt=1740891180 oweuc= pxtags=Cg4KAnR4Egg1MTM5MzE2MA rxtags=Cg4KAnR4Egg1MTM5MzE2MA%2CCg4KAnR4Egg1MTM5MzE2MQ%2CCg4KAnR4Egg1MTM5MzE2Mg%2CCg4KAnR4Egg1MTM5MzE2Mw%2CCg4KAnR4Egg1MTM5MzE2NA"}}}}},"shortBylineText":{"runs":[{"text":"Inner Healing Energy","navigationEndpoint":{"clickTrackingParams":"CLIBEKQwGAAiEwj63OuNzuqLAxUR0UIFHVbWMFo=","commandMetadata":{"webCommandMetadata":{"url":"/@InnerHealingEnergy_","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCp41xIZlfELOgxHMDFAKpRA","canonicalBaseUrl":"/@InnerHealingEnergy_"}}}]},"badges":[{"metadataBadgeRenderer":{"icon":{"iconType":"LIVE"},"style":"BADGE_STYLE_TYPE_LIVE_NOW","label":"LIVE","trackingParams":"CLIBEKQwGAAiEwj63OuNzuqLAxUR0UIFHVbWMFo="}}],"channelThumbnail":{"thumbnails":[{"url":"https://yt3.ggpht.com/aRQoIgB0rTvnb3BOqhWsnEhZWmE7MwaXGqS5cLv_xJUnhZsVWqLnU39SzANzjtByv9p_2uo6Lw=s68-c-k-c0x00ffffff-no-rj","width":68,"height":68}]},"trackingParams":"CLIBEKQwGAAiEwj63OuNzuqLAxUR0UIFHVbWMFpA35aWiry43p4M","shortViewCountText":{"runs":[{"text":"1.8K"},{"text":" watching"}]},"menu":{"menuRenderer":{"items":[{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Add to queue"}]},"icon":{"iconType":"ADD_TO_QUEUE_TAIL"},"serviceEndpoint":{"clickTrackingParams":"CLYBEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CLYBEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"DD15w8FFi18","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CLYBEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["DD15w8FFi18"],"params":"CAQ%3D"}},"videoIds":["DD15w8FFi18"]}},{"clickTrackingParams":"CLYBEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa","openPopupAction":{"popup":{"notificationActionRenderer":{"responseText":{"simpleText":"Added to queue"},"trackingParams":"CLcBELlqIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},"popupType":"TOAST"}}]}},"trackingParams":"CLYBEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Share"}]},"icon":{"iconType":"SHARE"},"serviceEndpoint":{"clickTrackingParams":"CLIBEKQwGAAiEwj63OuNzuqLAxUR0UIFHVbWMFo=","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/share/get_share_panel"}},"shareEntityServiceEndpoint":{"serializedShareEntity":"CgtERDE1dzhGRmkxOA%3D%3D","commands":[{"clickTrackingParams":"CLIBEKQwGAAiEwj63OuNzuqLAxUR0UIFHVbWMFo=","openPopupAction":{"popup":{"unifiedSharePanelRenderer":{"trackingParams":"CLUBEI5iIhMI-tzrjc7qiwMVEdFCBR1W1jBa","showLoadingSpinner":true}},"popupType":"DIALOG","beReused":true}}]}},"trackingParams":"CLIBEKQwGAAiEwj63OuNzuqLAxUR0UIFHVbWMFo=","hasSeparator":true}}],"trackingParams":"CLIBEKQwGAAiEwj63OuNzuqLAxUR0UIFHVbWMFo=","accessibility":{"accessibilityData":{"label":"Action menu"}},"targetId":"watch-related-menu-button"}},"thumbnailOverlays":[{"thumbnailOverlayToggleButtonRenderer":{"isToggled":false,"untoggledIcon":{"iconType":"WATCH_LATER"},"toggledIcon":{"iconType":"CHECK"},"untoggledTooltip":"Watch later","toggledTooltip":"Added","untoggledServiceEndpoint":{"clickTrackingParams":"CLQBEPnnAxgBIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"addedVideoId":"DD15w8FFi18","action":"ACTION_ADD_VIDEO"}]}},"toggledServiceEndpoint":{"clickTrackingParams":"CLQBEPnnAxgBIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"action":"ACTION_REMOVE_VIDEO_BY_VIDEO_ID","removedVideoId":"DD15w8FFi18"}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Watch later"}},"toggledAccessibility":{"accessibilityData":{"label":"Added"}},"trackingParams":"CLQBEPnnAxgBIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"thumbnailOverlayToggleButtonRenderer":{"untoggledIcon":{"iconType":"ADD_TO_QUEUE_TAIL"},"toggledIcon":{"iconType":"PLAYLIST_ADD_CHECK"},"untoggledTooltip":"Add to queue","toggledTooltip":"Added","untoggledServiceEndpoint":{"clickTrackingParams":"CLMBEMfsBBgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CLMBEMfsBBgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"DD15w8FFi18","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CLMBEMfsBBgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["DD15w8FFi18"],"params":"CAQ%3D"}},"videoIds":["DD15w8FFi18"]}}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Add to queue"}},"toggledAccessibility":{"accessibilityData":{"label":"Added"}},"trackingParams":"CLMBEMfsBBgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"thumbnailOverlayNowPlayingRenderer":{"text":{"runs":[{"text":"Now playing"}]}}}],"accessibility":{"accessibilityData":{"label":"432Hz- Fall Into Deep Healing Sleep, Regenerates Body and Mind, Emotional and Physical Healing - - Go to channel - Inner Healing Energy - 1.8K watching - play video"}},"richThumbnail":{"movingThumbnailRenderer":{"enableHoveredLogging":true,"enableOverlay":true}}}},{"compactVideoRenderer":{"videoId":"XVnr4yLkjGE","thumbnail":{"thumbnails":[{"url":"https://i.ytimg.com/vi/XVnr4yLkjGE/hqdefault.jpg?sqp=-oaymwEbCKgBEF5IVfKriqkDDggBFQAAiEIYAXABwAEG rs=AOn4CLAlPQDcskel2BBU_EUyOK6fU097KQ","width":168,"height":94},{"url":"https://i.ytimg.com/vi/XVnr4yLkjGE/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg== rs=AOn4CLC5RFMJyZGYmobkVo-qbxyRsIxuww","width":336,"height":188}]},"title":{"accessibility":{"accessibilityData":{"label":"Agile and DevOps with AWS | CI/CD, IaC, CloudFormation, Monitoring Debugging by TechPrepGuy 32 views 2 weeks ago 3 minutes, 38 seconds"}},"simpleText":"Agile and DevOps with AWS | CI/CD, IaC, CloudFormation, Monitoring Debugging"},"longBylineText":{"runs":[{"text":"TechPrepGuy","navigationEndpoint":{"clickTrackingParams":"CKsBEKQwGAEiEwj63OuNzuqLAxUR0UIFHVbWMFoyB3JlbGF0ZWQ=","commandMetadata":{"webCommandMetadata":{"url":"/@rahizeeshan","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCX3ZQ2O-UmgEgVbh6GDM0Xg","canonicalBaseUrl":"/@rahizeeshan"}}}]},"publishedTimeText":{"simpleText":"2 weeks ago"},"viewCountText":{"simpleText":"32 views"},"lengthText":{"accessibility":{"accessibilityData":{"label":"3 minutes, 38 seconds"}},"simpleText":"3:38"},"navigationEndpoint":{"clickTrackingParams":"CKsBEKQwGAEiEwj63OuNzuqLAxUR0UIFHVbWMFoyB3JlbGF0ZWRIxoeY0cjopdsEmgEFCAEQ-B0=","commandMetadata":{"webCommandMetadata":{"url":"/watch?v=XVnr4yLkjGE","webPageType":"WEB_PAGE_TYPE_WATCH","rootVe":3832}},"watchEndpoint":{"videoId":"XVnr4yLkjGE","nofollow":true,"watchEndpointSupportedOnesieConfig":{"html5PlaybackOnesieConfig":{"commonConfig":{"url":"https://rr1---sn-nvm-cxbz.googlevideo.com/initplayback?source=youtube oeis=1 c=WEB oad=3200 ovd=3200 oaad=11000 oavd=11000 ocs=700 oewis=1 oputc=1 ofpcc=1 msp=1 odepv=1 id=5d59ebe322e48c61 ip=2a02%3A27aa%3A0%3A0%3A0%3A0%3A0%3Ad49 initcwndbps=3400000 mt=1740891180 oweuc= pxtags=Cg4KAnR4Egg1MTM5MzE2MA rxtags=Cg4KAnR4Egg1MTM5MzE2MA%2CCg4KAnR4Egg1MTM5MzE2MQ%2CCg4KAnR4Egg1MTM5MzE2Mg%2CCg4KAnR4Egg1MTM5MzE2Mw%2CCg4KAnR4Egg1MTM5MzE2NA"}}}}},"shortBylineText":{"runs":[{"text":"TechPrepGuy","navigationEndpoint":{"clickTrackingParams":"CKsBEKQwGAEiEwj63OuNzuqLAxUR0UIFHVbWMFoyB3JlbGF0ZWQ=","commandMetadata":{"webCommandMetadata":{"url":"/@rahizeeshan","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCX3ZQ2O-UmgEgVbh6GDM0Xg","canonicalBaseUrl":"/@rahizeeshan"}}}]},"channelThumbnail":{"thumbnails":[{"url":"https://yt3.ggpht.com/276VIJDwINMrSMALGoLRbtJz7dKw8TqP2eeV1puNeqdOHGnrRObLo8TV5tC3LO1TfthBTEzY_A=s68-c-k-c0x00ffffff-no-rj","width":68,"height":68}]},"trackingParams":"CKsBEKQwGAEiEwj63OuNzuqLAxUR0UIFHVbWMFpA4ZiSl7L8-qxd","shortViewCountText":{"accessibility":{"accessibilityData":{"label":"32 views"}},"simpleText":"32 views"},"menu":{"menuRenderer":{"items":[{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Add to queue"}]},"icon":{"iconType":"ADD_TO_QUEUE_TAIL"},"serviceEndpoint":{"clickTrackingParams":"CLABEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CLABEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"XVnr4yLkjGE","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CLABEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["XVnr4yLkjGE"],"params":"CAQ%3D"}},"videoIds":["XVnr4yLkjGE"]}},{"clickTrackingParams":"CLABEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa","openPopupAction":{"popup":{"notificationActionRenderer":{"responseText":{"simpleText":"Added to queue"},"trackingParams":"CLEBELlqIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},"popupType":"TOAST"}}]}},"trackingParams":"CLABEP6YBBgFIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"menuServiceItemDownloadRenderer":{"serviceEndpoint":{"clickTrackingParams":"CK8BENGqBRgGIhMI-tzrjc7qiwMVEdFCBR1W1jBa","offlineVideoEndpoint":{"videoId":"XVnr4yLkjGE","onAddCommand":{"clickTrackingParams":"CK8BENGqBRgGIhMI-tzrjc7qiwMVEdFCBR1W1jBa","getDownloadActionCommand":{"videoId":"XVnr4yLkjGE","params":"CAIQAA%3D%3D"}}}},"trackingParams":"CK8BENGqBRgGIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Share"}]},"icon":{"iconType":"SHARE"},"serviceEndpoint":{"clickTrackingParams":"CKsBEKQwGAEiEwj63OuNzuqLAxUR0UIFHVbWMFo=","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/share/get_share_panel"}},"shareEntityServiceEndpoint":{"serializedShareEntity":"CgtYVm5yNHlMa2pHRQ%3D%3D","commands":[{"clickTrackingParams":"CKsBEKQwGAEiEwj63OuNzuqLAxUR0UIFHVbWMFo=","openPopupAction":{"popup":{"unifiedSharePanelRenderer":{"trackingParams":"CK4BEI5iIhMI-tzrjc7qiwMVEdFCBR1W1jBa","showLoadingSpinner":true}},"popupType":"DIALOG","beReused":true}}]}},"trackingParams":"CKsBEKQwGAEiEwj63OuNzuqLAxUR0UIFHVbWMFo=","hasSeparator":true}}],"trackingParams":"CKsBEKQwGAEiEwj63OuNzuqLAxUR0UIFHVbWMFo=","accessibility":{"accessibilityData":{"label":"Action menu"}}}},"thumbnailOverlays":[{"thumbnailOverlayTimeStatusRenderer":{"text":{"accessibility":{"accessibilityData":{"label":"3 minutes, 38 seconds"}},"simpleText":"3:38"},"style":"DEFAULT"}},{"thumbnailOverlayToggleButtonRenderer":{"isToggled":false,"untoggledIcon":{"iconType":"WATCH_LATER"},"toggledIcon":{"iconType":"CHECK"},"untoggledTooltip":"Watch later","toggledTooltip":"Added","untoggledServiceEndpoint":{"clickTrackingParams":"CK0BEPnnAxgBIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"addedVideoId":"XVnr4yLkjGE","action":"ACTION_ADD_VIDEO"}]}},"toggledServiceEndpoint":{"clickTrackingParams":"CK0BEPnnAxgBIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"action":"ACTION_REMOVE_VIDEO_BY_VIDEO_ID","removedVideoId":"XVnr4yLkjGE"}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Watch later"}},"toggledAccessibility":{"accessibilityData":{"label":"Added"}},"trackingParams":"CK0BEPnnAxgBIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"thumbnailOverlayToggleButtonRenderer":{"untoggledIcon":{"iconType":"ADD_TO_QUEUE_TAIL"},"toggledIcon":{"iconType":"PLAYLIST_ADD_CHECK"},"untoggledTooltip":"Add to queue","toggledTooltip":"Added","untoggledServiceEndpoint":{"clickTrackingParams":"CKwBEMfsBBgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CKwBEMfsBBgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"XVnr4yLkjGE","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CKwBEMfsBBgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["XVnr4yLkjGE"],"params":"CAQ%3D"}},"videoIds":["XVnr4yLkjGE"]}}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Add to queue"}},"toggledAccessibility":{"accessibilityData":{"label":"Added"}},"trackingParams":"CKwBEMfsBBgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"thumbnailOverlayNowPlayingRenderer":{"text":{"runs":[{"text":"Now playing"}]}}}],"accessibility":{"accessibilityData":{"label":"Agile and DevOps with AWS | CI/CD, IaC, CloudFormation, Monitoring Debugging - 3 minutes, 38 seconds - Go to channel - TechPrepGuy - 32 views - 2 weeks ago - play video"}},"richThumbnail":{"movingThumbnailRenderer":{"enableHoveredLogging":true,"enableOverlay":true}}}},{"compactVideoRenderer":{"videoId":"HOmVlf6Bm2g","thumbnail":{"thumbnails":[{"url":"https://i.ytimg.com/vi/HOmVlf6Bm2g/hqdefault.jpg?sqp=-oaymwEbCKgBEF5IVfKriqkDDggBFQAAiEIYAXABwAEG rs=AOn4CLBDVEIxuYXiiQGbBnK_AfeG1Sv7pQ","width":168,"height":94},{"url":"https://i.ytimg.com/vi/HOmVlf6Bm2g/hqdefault.jpg?sqp=-oaymwEcCNACELwBSFXyq4qpAw4IARUAAIhCGAFwAcABBg== rs=AOn4CLDDBKaauqQfjpMuUwAnUtbtg-q8HQ","width":336,"height":188}]},"title":{"accessibility":{"accessibilityData":{"label":"Make Excel Formulas Dynamic with the Hash Sign by Kenji Explains 384,394 views 4 months ago 10 minutes, 54 seconds"}},"simpleText":"Make Excel Formulas Dynamic with the Hash Sign"},"longBylineText":{"runs":[{"text":"Kenji Explains","navigationEndpoint":{"clickTrackingParams":"CKQBEKQwGAIiEwj63OuNzuqLAxUR0UIFHVbWMFoyB3JlbGF0ZWQ=","commandMetadata":{"webCommandMetadata":{"url":"/@KenjiExplains","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCkHdBeQ4DuvBXTahMYZVlMA","canonicalBaseUrl":"/@KenjiExplains"}}}]},"publishedTimeText":{"simpleText":"4 months ago"},"viewCountText":{"simpleText":"384,394 views"},"lengthText":{"accessibility":{"accessibilityData":{"label":"10 minutes, 54 seconds"}},"simpleText":"10:54"},"navigationEndpoint":{"clickTrackingParams":"CKQBEKQwGAIiEwj63OuNzuqLAxUR0UIFHVbWMFoyB3JlbGF0ZWRIxoeY0cjopdsEmgEFCAEQ-B0=","commandMetadata":{"webCommandMetadata":{"url":"/watch?v=HOmVlf6Bm2g","webPageType":"WEB_PAGE_TYPE_WATCH","rootVe":3832}},"watchEndpoint":{"videoId":"HOmVlf6Bm2g","nofollow":true,"watchEndpointSupportedOnesieConfig":{"html5PlaybackOnesieConfig":{"commonConfig":{"url":"https://rr2---sn-uxaxiv0nxx5q-nv4l.googlevideo.com/initplayback?source=youtube oeis=1 c=WEB oad=3200 ovd=3200 oaad=11000 oavd=11000 ocs=700 oewis=1 oputc=1 ofpcc=1 msp=1 odepv=1 id=1ce99595fe819b68 ip=2a02%3A27aa%3A0%3A0%3A0%3A0%3A0%3Ad49 initcwndbps=2106250 mt=1740891180 oweuc= pxtags=Cg4KAnR4Egg1MTM5MzE2MA rxtags=Cg4KAnR4Egg1MTM5MzE2MA%2CCg4KAnR4Egg1MTM5MzE2MQ%2CCg4KAnR4Egg1MTM5MzE2Mg%2CCg4KAnR4Egg1MTM5MzE2Mw%2CCg4KAnR4Egg1MTM5MzE2NA"}}}}},"shortBylineText":{"runs":[{"text":"Kenji Explains","navigationEndpoint":{"clickTrackingParams":"CKQBEKQwGAIiEwj63OuNzuqLAxUR0UIFHVbWMFoyB3JlbGF0ZWQ=","commandMetadata":{"webCommandMetadata":{"url":"/@KenjiExplains","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCkHdBeQ4DuvBXTahMYZVlMA","canonicalBaseUrl":"/@KenjiExplains"}}}]},"channelThumbnail":{"thumbnails":[{"url":"https://yt3.ggpht.com/9ZZjWRnwsec7xVsT1Uu67UEhqNt5KYW5hjbr8pw3msp5C6LCUGuEuBx-LhDyf5QwWKkAwz2ktg=s68-c-k-c0x00ffffff-no-rj","width":68,"height":68}]},"ownerBadges":[{"metadataBadgeRenderer":{"icon":{"iconType":"CHECK_CIRCLE_THICK"},"style":"BADGE_STYLE_TYPE_VERIFIED","tooltip":"Verified","trackingParams":"CKQBEKQwGAIiEwj63OuNzuqLAxUR0UIFHVbWMFo=","accessibilityData":{"label":"Verified"}}}],"trackingParams":"CKQBEKQwGAIiEwj63OuNzuqLAxUR0UIFHVbWMFpA6LaG9N-y5fQc","shortViewCountText":{"accessibility":{"accessibilityData":{"label":"384K views"}},"simpleText":"384K views"},"menu":{"menuRenderer":{"items":[{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Add to queue"}]},"icon":{"iconType":"ADD_TO_QUEUE_TAIL"},"serviceEndpoint":{"clickTrackingParams":"CKkBEP6YBBgHIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CKkBEP6YBBgHIhMI-tzrjc7qiwMVEdFCBR1W1jBa","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"HOmVlf6Bm2g","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CKkBEP6YBBgHIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["HOmVlf6Bm2g"],"params":"CAQ%3D"}},"videoIds":["HOmVlf6Bm2g"]}},{"clickTrackingParams":"CKkBEP6YBBgHIhMI-tzrjc7qiwMVEdFCBR1W1jBa","openPopupAction":{"popup":{"notificationActionRenderer":{"responseText":{"simpleText":"Added to queue"},"trackingParams":"CKoBELlqIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},"popupType":"TOAST"}}]}},"trackingParams":"CKkBEP6YBBgHIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"menuServiceItemDownloadRenderer":{"serviceEndpoint":{"clickTrackingParams":"CKgBENGqBRgIIhMI-tzrjc7qiwMVEdFCBR1W1jBa","offlineVideoEndpoint":{"videoId":"HOmVlf6Bm2g","onAddCommand":{"clickTrackingParams":"CKgBENGqBRgIIhMI-tzrjc7qiwMVEdFCBR1W1jBa","getDownloadActionCommand":{"videoId":"HOmVlf6Bm2g","params":"CAIQAA%3D%3D"}}}},"trackingParams":"CKgBENGqBRgIIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Share"}]},"icon":{"iconType":"SHARE"},"serviceEndpoint":{"clickTrackingParams":"CKQBEKQwGAIiEwj63OuNzuqLAxUR0UIFHVbWMFo=","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/share/get_share_panel"}},"shareEntityServiceEndpoint":{"serializedShareEntity":"CgtIT21WbGY2Qm0yZw%3D%3D","commands":[{"clickTrackingParams":"CKQBEKQwGAIiEwj63OuNzuqLAxUR0UIFHVbWMFo=","openPopupAction":{"popup":{"unifiedSharePanelRenderer":{"trackingParams":"CKcBEI5iIhMI-tzrjc7qiwMVEdFCBR1W1jBa","showLoadingSpinner":true}},"popupType":"DIALOG","beReused":true}}]}},"trackingParams":"CKQBEKQwGAIiEwj63OuNzuqLAxUR0UIFHVbWMFo=","hasSeparator":true}}],"trackingParams":"CKQBEKQwGAIiEwj63OuNzuqLAxUR0UIFHVbWMFo=","accessibility":{"accessibilityData":{"label":"Action menu"}}}},"thumbnailOverlays":[{"thumbnailOverlayTimeStatusRenderer":{"text":{"accessibility":{"accessibilityData":{"label":"10 minutes, 54 seconds"}},"simpleText":"10:54"},"style":"DEFAULT"}},{"thumbnailOverlayToggleButtonRenderer":{"isToggled":false,"untoggledIcon":{"iconType":"WATCH_LATER"},"toggledIcon":{"iconType":"CHECK"},"untoggledTooltip":"Watch later","toggledTooltip":"Added","untoggledServiceEndpoint":{"clickTrackingParams":"CKYBEPnnAxgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"addedVideoId":"HOmVlf6Bm2g","action":"ACTION_ADD_VIDEO"}]}},"toggledServiceEndpoint":{"clickTrackingParams":"CKYBEPnnAxgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"action":"ACTION_REMOVE_VIDEO_BY_VIDEO_ID","removedVideoId":"HOmVlf6Bm2g"}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Watch later"}},"toggledAccessibility":{"accessibilityData":{"label":"Added"}},"trackingParams":"CKYBEPnnAxgCIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"thumbnailOverlayToggleButtonRenderer":{"untoggledIcon":{"iconType":"ADD_TO_QUEUE_TAIL"},"toggledIcon":{"iconType":"PLAYLIST_ADD_CHECK"},"untoggledTooltip":"Add to queue","toggledTooltip":"Added","untoggledServiceEndpoint":{"clickTrackingParams":"CKUBEMfsBBgDIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CKUBEMfsBBgDIhMI-tzrjc7qiwMVEdFCBR1W1jBa","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"HOmVlf6Bm2g","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CKUBEMfsBBgDIhMI-tzrjc7qiwMVEdFCBR1W1jBa","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["HOmVlf6Bm2g"],"params":"CAQ%3D"}},"videoIds":["HOmVlf6Bm2g"]}}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Add to queue"}},"toggledAccessibility":{"accessibilityData":{"label":"Added"}},"trackingParams":"CKUBEMfsBBgDIhMI-tzrjc7qiwMVEdFCBR1W1jBa"}},{"thumbnailOverlayNowPlayingRenderer":{"text":{"runs":[{"text":"Now playing"}]}}}],"accessibility":{"accessibilityData":{"label":"Make Excel Formulas Dynamic with the Hash Sign - 10 minutes, 54 seconds - Go to channel - Kenji Explains - 384K views - 4 months ago - play video"}},"richThumbnail":{"movingThumbnailRenderer":{"movingThumbnailDetails":{"thumbnails":[{"url":"https://i.ytimg.com/an_webp/HOmVlf6Bm2g/mqdefault_6s.webp?du=3000 sqp=CIiwj74G rs=AOn4CLAKjhHYtXSitjUhxdBDu9AuQPZuSw","width":320,"height":180}],"logAsMovingThumbnail":true},"enableHoveredLogging":true,"enableOverlay":true}}}},{"lockupViewModel":{"contentImage":{"collectionThumbnailViewModel":{"primaryThumbnail":{"thumbnailViewModel":{"image":{"sources":[{"url":"https://i.ytimg.com/vi/25aiG5qg-CU/hqdefault.jpg?sqp=-oaymwEWCKgBEF5IWvKriqkDCQgBFQAAiEIYAQ== rs=AOn4CLDAOSXdZbZ4L8v6h8QvO80QgJ7SiA","width":168,"height":94},{"url":"https://i.ytimg.com/vi/25aiG5qg-CU/hqdefault.jpg?sqp=-oaymwEXCNACELwBSFryq4qpAwkIARUAAIhCGAE= rs=AOn4CLBXK62yqv5DM6PD7RTTs73La--eNA","width":336,"height":188}]},"overlays":[{"thumbnailOverlayBadgeViewModel":{"thumbnailBadges":[{"thumbnailBadgeViewModel":{"icon":{"sources":[{"clientResource":{"imageName":"COURSE"}}]},"text":"35 lessons","badgeStyle":"THUMBNAIL_OVERLAY_BADGE_STYLE_DEFAULT","backgroundColor":{"lightTheme":2436147,"darkTheme":2436147}}}],"position":"THUMBNAIL_OVERLAY_BADGE_POSITION_BOTTOM_END"}},{"thumbnailHoverOverlayViewModel":{"icon":{"sources":[{"clientResource":{"imageName":"PLAY_ALL"}}]},"text":{"content":"Play all","styleRuns":[{"startIndex":0,"length":8}]},"style":"THUMBNAIL_HOVER_OVERLAY_STYLE_COVER"}}],"backgroundColor":{"lightTheme":3028799,"darkTheme":3028799}}},"stackColor":{"lightTheme":7374489,"darkTheme":7767699}}},"metadata":{"lockupMetadataViewModel":{"title":{"content":"Happy New Year 2025"},"metadata":{"contentMetadataViewModel":{"metadataRows":[{"metadataParts":[{"text":{"content":"Jazz For Soul

#############################