View Detailed Profile
Excel Magic Trick 253: Data Table 1 Variable What If Analysis

Excel Magic Trick 253: Data Table 1 Variable What If Analysis

Download

Excel Magic Trick 337: RANK function 10 Examples

Excel Magic Trick 337: RANK function 10 Examples

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT337.xls See how to Rank numbers in

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 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel

Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel

Download

Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?

Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?

Download Excel Start File: https://excelisfun.net/files/EMT1178.xlsx

Excel Magic Trick #171: MACRO Data Validation from 3 lists

Excel Magic Trick #171: MACRO Data Validation from 3 lists

Download

Excel Magic Trick #90: Consolidation

Excel Magic Trick #90: Consolidation

Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MikeGelGirvinYouTubeExcelMagicTricks90.xls Finished File: ...

Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!

Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!

Download

Excel Magic Trick 335: VLOOKUP & Data Validation for Recipes

Excel Magic Trick 335: VLOOKUP & Data Validation for Recipes

Download

Excel Magic Trick 865: Data From Many Columns Into One: Recorded Macro & Paste All Clipboard

Excel Magic Trick 865: Data From Many Columns Into One: Recorded Macro & Paste All Clipboard

Download

Excel Magic Trick 255: Data Table 2 Variable What If Analysis

Excel Magic Trick 255: Data Table 2 Variable What If Analysis

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 1118: MODE for Text Values, Extract Word That Occurs Most Frequently

Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently

Download