Photo Gallery

Excel Magic Trick 976: Excel Two Way Lookup - 11 Examples (2 Way Lookup)
Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range
Excel Magic Trick 1200: Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods)
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates
Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently
Excel Conditional Format Row, Column & Intersecting Cell -  Excel Magic Trick 1572
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Excel Magic Trick 1106: 3-D Gradient Conditional Formatting For Row with AND Criteria
Excel XLOOKUP Function โ€“ Comprehensive Lessons โ€“ 27 Examples - Excel Magic Trick 1600
Excel Magic Trick 1021: Implicit Intersection or #VALUE Error: No Ctrl + Shift + Enter