9:43Excel Magic Trick 625: INDIRECT SUBSTITUTE SUBSTITUTE Silly Two Way Lookup Formulaexcelisfun17.0K viewsView & Download
6:15Excel Magic Trick 1002: Replace "11" With "13", But Only After Third Dashexcelisfun5.3K viewsView & Download
7:23Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)excelisfun70.1K viewsView & Download
13:06Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequentlyexcelisfun48.1K viewsView & Download
9:01Using the Excel SUBSTITUTE FunctionTechnology for Teachers and Students103.1K viewsView & Download
3:56Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formulaexcelisfun10.7K viewsView & Download
4:53Excel Magic Trick 1477: COUNTIFS & AND Functions for Duplicate Event Codes AND Task = "Special"excelisfun5.8K viewsView & Download
8:09Excel Magic Trick 289: LEN & SUBSTITUTE functions Counting Tricksexcelisfun16.5K viewsView & Download
2:43Excel Magic Trick 1167: Substitute Final Score If Greater Than Low Score: MAX, MIN & SUM Functionsexcelisfun3.2K viewsView & Download
4:47Excel Magic Trick 1165: Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Functionsexcelisfun1.8K viewsView & Download
7:08Excel Magic Trick 1176: CONVERT Function to convert units in Excel (Excel CONVERT Joke at 05:27)excelisfun40.1K viewsView & Download
14:18Stop Using Old Excel Formulas! 2 Modern Functions That Replace 30+ | Excel 2026Jopa Excel26.0K viewsView & Download
8:22Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letterexcelisfun6.4K viewsView & Download
6:56Excel Magic Trick 291: Add Nums Associated w Codes From Stringexcelisfun2.4K viewsView & Download
