Photo Gallery

Excel Magic Trick # 2: Chart Keyboard Trick
Excel Magic Trick #92: Two Chart Types In One Chart!
Excel Magic Trick #200: Excel Table Formula Nomenclature
Excel Magic Trick 732: SERIES Chart Function
Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)
Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH
Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions
Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria
Excel Magic Trick 1100: Cross Tabulated Lookup: 1) Lookup Row then match or 2) Array Multiplication?
Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick 1099: Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range