View Detailed Profile
Excel Magic Trick 425: Functions That Can Handle Array Syntax And Do Not Require CSE

Excel Magic Trick 425: Functions That Can Handle Array Syntax And Do Not Require CSE

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT423-430.xls Learn about 7

Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods

Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods

Download

Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples)

Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples)

Download

Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula

Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula

Download

Excel Magic Trick 430: Count Sales Numbers Greater Than Hurdle (GESTEP function)

Excel Magic Trick 430: Count Sales Numbers Greater Than Hurdle (GESTEP function)

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT423-430.xls See how to count how many Sales are ...

Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together

Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together

Download

Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH

Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT524-530.xls See how to enter VLOOKUPs 3rd ...

Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods)

Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods)

Download

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600

Download

Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic

Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic

Download

Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions

Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions

Download

Excel Magic Trick 452: IF Function Formula 16 Examples

Excel Magic Trick 452: IF Function Formula 16 Examples

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT452.xls 1-4) IF

Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE

Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE

Download