Photo Gallery

Excel Magic Trick 336: Incrementing Numbers In Formulas
Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments
Excel Magic Trick 1476: SUMIFS to Add Expenses for Any Time Period (Adding with Three Conditions)
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Excel Magic Trick 335: VLOOKUP & Data Validation for Recipes
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123
Excel Formula to Increment Numbers: 1-6, 7-12, 13-18 for Raffle Ticket - Excel Magic Trick 1585
Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…
Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers
Excel Magic Trick 1067: Displaying Fractional Percent in Excel like: 33 1/3 % or 3/10%
Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently