Overview: Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT440-451.

Photo Gallery

Excel Magic Trick 449: Excel Data Analysis Abbreviated Notes
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Excel Magic Trick 444: Multiply Column Times Row With TRANSPOSE Function
Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take
Excel Magic Trick 1094: Wildcards for Sheet References and INDIRECT function
Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT
Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel
Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods
Excel Magic Trick 1289: Remove “USD” from CSV File Column of Numbers (6 Examples)
Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH