11:03Excel Magic Trick 1117: Calculate Average For Each Sample: AVERAGEIFS, PivotTable, or OFFSETexcelisfun58.1K viewsView & Download
12:47Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Incrementsexcelisfun5.7K viewsView & Download
6:19Excel Magic Trick 316: Concatenate Selection w Criteria (MoreFunc Excel Add-in functions)excelisfun17.5K viewsView & Download
8:22Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letterexcelisfun6.4K viewsView & Download
4:53Excel Magic Trick 1477: COUNTIFS & AND Functions for Duplicate Event Codes AND Task = "Special"excelisfun5.8K viewsView & Download
2:42Excel Magic Trick 1389: Average Number of Days Between Two Columns of Datesexcelisfun27.3K viewsView & Download
8:25Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formulaexcelisfun5.1K viewsView & Download
7:44Excel Magic Trick 975: 7 Keystrokes to Enter an Excel Formula, including Array Formulas.excelisfun4.3K viewsView & Download
16:08Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Examples)excelisfun7.3K viewsView & Download
28:07Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas?excelisfun8.4K viewsView & Download
3:20Excel Magic Trick 1267: PivotTable Automatic Date Grouping: New in Excel 2016excelisfun104.5K viewsView & Download
8:51Excel Magic Trick 920: Rotating List & Upside down VLOOKUP: Alternative Formulasexcelisfun8.0K viewsView & Download