2:54Excel FIXED Function Easier than TEXT Function! (DOLLAR Function too). Excel Magic Trick 1635excelisfun11.2K viewsView & Download
2:42Excel Magic Trick 1389: Average Number of Days Between Two Columns of Datesexcelisfun27.3K viewsView & Download
3:51Excel Magic Trick 989: Conditional Formatting For Values above 90% Percentile Markexcelisfun8.1K viewsView & Download
3:24Excel Magic Trick 392: CHOOSE function Randomly Generate 1, 0 or Blankexcelisfun10.1K viewsView & Download
7:45Excel Magic Trick 1195: Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution?excelisfun16.4K viewsView & Download
5:08Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Takeexcelisfun3.7K viewsView & Download
10:45Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUPexcelisfun38.0K viewsView & Download
8:14Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labelsexcelisfun9.2K viewsView & Download
12:47Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Incrementsexcelisfun5.7K viewsView & Download
17:34Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicatesexcelisfun243.7K viewsView & Download
1:02Excel Magic Trick 1745 Part 2: Create & Spill Random Normally Distributed Valuesexcelisfun5.9K viewsView & Download
7:23Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)excelisfun70.1K viewsView & Download
4:02Excel Magic Trick 1239: Formula To Indicate a Date is in Leap Yearexcelisfun9.8K viewsView & Download
31:55Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples)excelisfun12.3K viewsView & Download
2:27Excel Magic Trick 1187: Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functionsexcelisfun7.2K viewsView & Download