Excel SWITCH Function, is it really as good as they say? You might be surprised!
The Excel SWITCH Function is an alternative to nested IFs, IFS, V or XLOOKUP by allowing you to replace one value with another, but does it really offer anything new or improved? In this video we compare SWITCH to IFS, VLOOKUP, XLOOKUP and CHOOSE. Download the Excel file here: https://www.myonlinetraininghub.com/e... 0:19 SWITCH for Lookups 1:23 IFS for lookups 2:32 VLOOKUP & XLOOKUP alternatives 3:37 IFS for multiple logical tests 4:44 SWITCH for multiple logical tests 5:47 SWITCH to return Fiscal Quarters 6:39 CHOOSE to return Fiscal Quarters 7:17 Options reviewed 7:48 The bottom line! View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: / myndatreacy
▶︎
Excel Hash Sign Operator - What is it + ADVANCED Tricks!
▶︎
When You Should Use the New Excel LET Function
▶︎
Try The SWITCH Function Instead of IF Statements
▶︎
A Dynamic Way to Compare Two Lists in Excel Using The Filter Function.
▶︎
Excel Battle: CHOOSE vs SWITCH
▶︎
7 Excel Tricks You Wish Someone Had Shown You Years Ago
▶︎
2 Awesome Tips on How to Use the SWITCH Function in Excel
▶︎
IF, IFS, Nested IFs: Avoid the Mistakes Slowing You Down
▶︎
How You Can Actually Use the NEW Excel BYROW & BYCOL Functions
▶︎
10 Excel Formula Symbols You Wish You Knew Years Ago
▶︎
LET Function Transforms Messy Formulas - Comprehensive Guide
▶︎
XLOOKUP Complete Tutorial in Excel (+ Hidden Tricks)
▶︎
✋ Stop Using NESTED IF Formulas in Excel, Use SWITCH Function Instead
▶︎
Excel FILTER Function incl. Trick to Rearrange Column Order
▶︎
🚗 BYD : The biggest SCAM of the car industry ?
▶︎
Intro to Excel’s LET Function: Simplicity + Efficiency
▶︎
Say Goodbye to IF Statements in Excel with SWITCH
▶︎
I Hacked This Temu Router. What I Found Should Be Illegal.
▶︎
How to Calculate YTD (Year to Date) Values in Excel using the SCAN function
▶︎