View Detailed Profile
Excel Magic Trick #133: Import CSV Data (Comma Separated Values - Data)

Excel Magic Trick #133: Import CSV Data (Comma Separated Values - Data)

Download

Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable

Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable

Download

Excel Magic Trick 571: VLOOKUP To Create Form from Access Linked Data Import

Excel Magic Trick 571: VLOOKUP To Create Form from Access Linked Data Import

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT570-574.xls See how to

Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell

Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell

Drilling Through to put one formula on many sheets with one action

Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform

Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform

Download Excel Files: Scroll down to

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 #182: Workbook References

Excel Magic Trick #182: Workbook References

Download

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel If statement

Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)

Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)

Download

Excel Magic Trick 1200: Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods)

Excel Magic Trick 1200: Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods)

Download

Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL

Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL

Download

Excel Magic Trick #137: Array Syntax for USA & Norway

Excel Magic Trick #137: Array Syntax for USA & Norway

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