Photo Gallery

Excel Magic Trick 417: Get Last Value from Multiple Sheets
Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter
Excel Magic Flashing Christmas Tree. Plus, BIG LET Surprise!!! Excel Magic Trick 1711
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick #176 Get Last Item in Column on Diff Sheet
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally
Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP
Excel Magic Trick #179: Are All Four Word The Same?
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates
Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT