Content Analysis: Download Files: Start File: https://excelisfun.net/files/EMT1396-97.xlsx https://excelisfun.net/files/EMT1397%20Part%2002.xlsx ... (11:54) Summary Reference Videos: Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT531-533.xls See how to

Photo Gallery

Excel Magic Trick #121: Count With More Than 1 Criteria Condition
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart
Excel Magic Trick 1201: Conditional Format Product With No Sales (5 Examples)
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 #221: LEN function Counts Spaces
Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments
Excel Magic Trick 290: Count Codes From Column of Text Strings
Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT
Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functions
Excel Magic Trick 441: Count Times That Start With 7 (7:00, 7:15, etc.)