Photo Gallery

Excel Magic Trick 911: Add Leading Zero and Dash, More Examples From Mr Excel & excelisfun Trick 107
Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formula
Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell
Excel Magic Trick #182: Workbook References
Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formula
Excel Magic Trick #179: Are All Four Word The Same?
Excel Magic Trick 1019: Formula For Text Month Labels From Serial Date: EDATE, TEXT & COLUMNS
Excel Magic Trick 1471: Array Formula: Add Daily Rainfall 5 AM to 5 AM Next Day: (Most Automatic)
Excel Magic Trick 1038: Make Table Reference Absolute With Colon and Double Square Brackets
Excel Magic Tricks # 1: Formulas & Cell References
Excel Magic Trick 1120: Is Item in All Three Lists?
Excel Magic Trick 1230: Conditional Formatting: Highlight Table with Color When Name Selected