Photo Gallery

Excel Magic Trick 1275: Excel Online Office 365 MAXIFS function
Excel Magic Trick 1274: VLOOKUP Replaces Long IF Formula for Conversion Formula (LOOKUP too)
Excel Magic Trick 1276: Impossible: Excel Online Absolute Cell References?
Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell
Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP
Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…
Excel Magic Trick 975: 7 Keystrokes to Enter an Excel Formula, including Array Formulas.
Excel Magic Trick 1273: Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins
Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT
Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!
Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter
Excel Magic Trick 1477: COUNTIFS & AND Functions for Duplicate Event Codes AND Task = "Special"

Related Updates

Excel Magic Trick 1275: Excel Online Office 365 MAXIFS function Excel Magic Trick 1274: VLOOKUP Replaces Long IF Formula for Conversion Formula (LOOKUP too) Excel Magic Trick 1276: Impossible: Excel Online Absolute Cell References? Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39… Excel Magic Trick 975: 7 Keystrokes to Enter an Excel Formula, including Array Formulas. Excel Magic Trick 1273: Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins Uncovering The Secrets Of John Gotti: A Legacy Of Power And Betrayal Uncovering The Forgotten Heir Of Home Alone: The Kieran Culkin Connection Step Into America's 2nd Largest Mall: Where Shopping Dreams Come Alive This Summer What I Discovered About Warren Harding That Changed My Mind Kurt Cobain's Final Hours: Uncovering The Tragic Truth Behind His Death Who Was Tony Hughes, The Young Man Silenced By Jeff Dahmer's Horror Callan Mulvey's Shocking Story: What Happens Before Tragedy Strikes Howard Stern's Marriage: Secrets Revealed