View Detailed Profile
Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula

Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula

Download

Excel Magic Trick 1289: Remove “USD” from CSV File Column of Numbers (6 Examples)

Excel Magic Trick 1289: Remove “USD” from CSV File Column of Numbers (6 Examples)

Download

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Download

Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel

Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel

Download

Excel Magic Trick 1143: Extract Content From Non-Empty Cells: Filter or Array Formula?

Excel Magic Trick 1143: Extract Content From Non-Empty Cells: Filter or Array Formula?

Download

Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?

Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?

Download

Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…

Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…

Download

Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters

Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters

(00:10) Problem setup and review of last video

Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

Download

Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?

Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?

Download

Excel Magic Trick 991: Formula To Create Sequential Numbers 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, ...

Excel Magic Trick 991: Formula To Create Sequential Numbers 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, ...

Download

Excel Magic Trick 1198: Median for Each Quarter Using AGGREGATE Function

Excel Magic Trick 1198: Median for Each Quarter Using AGGREGATE Function

Download

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Download