12:47Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Incrementsexcelisfun5.7K viewsView & Download
16:08Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Examples)excelisfun7.3K viewsView & Download
8:38Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formattingexcelisfun12.6K viewsView & Download
6:19Excel Magic Trick 316: Concatenate Selection w Criteria (MoreFunc Excel Add-in functions)excelisfun17.5K viewsView & Download
4:46Excel Magic Trick 867 AVERAGEIFS Function w/ Not and Between Criteriaexcelisfun5.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
1:09:39Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)excelisfun722.1K viewsView & Download
7:23Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)excelisfun70.1K viewsView & Download
5:07Excel Magic Trick 1217: D Functions: Text Criteria: “Starts With”, “Exact” and “Contains”excelisfun23.4K viewsView & Download
8:25Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formulaexcelisfun5.1K viewsView & Download
4:55Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Functionexcelisfun242.6K viewsView & Download
7:51Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF?excelisfun3.4K viewsView & Download