Photo Gallery

Excel Magic Trick #200: Excel Table Formula Nomenclature
Excel Magic Trick 1113: Extract All Characters In Cell To Separate Cells: PPPP to P, P, P, P
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
Excel Magic Trick 1120: Is Item in All Three Lists?
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally
Excel Magic Trick 1121: Excel 2013 RRI Function: Calculate Compounding Rate/Geometric Mean
Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel
Excel Magic Tricks # 1: Formulas & Cell References
Excel Magic Trick 1101: Calculate MEDIAN Based On Lower/Upper Date, Exclude Holidays & Weekends
Excel Magic Trick 1206: Day & Night Shift Time Calculations: Add Total Hours Single Cell Formula