Content Analysis: (11:54) Summary Reference Videos:

Photo Gallery

Excel Magic Trick #121: Count With More Than 1 Criteria Condition
Excel Magic Trick 1201: Conditional Format Product With No Sales (5 Examples)
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick #181: Count Words Case Sensitive
Excel Magic Trick 862: Count Numbers In Column, But Only If Number Is Not Repeated In Row
Excel Magic Trick 1121: Excel 2013 RRI Function: Calculate Compounding Rate/Geometric Mean
Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart
Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments
Excel Magic Trick #221: LEN function Counts Spaces
Excel Magic Trick 1043: Count Unique Numbers in Column with Empty Cells and Text (Mixed Data)
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT