Photo Gallery

Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples)
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method
Excel Magic Tricks # 1: Formulas & Cell References
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 362: 12 Amazing Counting Formulas
Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula
Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)
Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Trouble
Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently
Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL
Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR