View Detailed Profile
Excel Magic Trick #215: Dynamic Print Range

Excel Magic Trick #215: Dynamic Print Range

Download

Excel Magic Tricks # 1: Formulas & Cell References

Excel Magic Tricks # 1: Formulas & Cell References

Video 1 – 10 Download

Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range

Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range

Download

Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match

Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match

Download

Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers

Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers

Download

Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract

Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract

Download

Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels

Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels

Download

Excel Dynamic Arrays & Conditional Formatting for Spilled Arrays (Excel Magic Trick 1525)

Excel Dynamic Arrays & Conditional Formatting for Spilled Arrays (Excel Magic Trick 1525)

Download

Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT

Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT

Download

Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Names

Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Names

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT582-585.xls See how to use the OFFSET function ...

Excel Magic Trick #240: Dynamic Range New Data At Top

Excel Magic Trick #240: Dynamic Range New Data At Top

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 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function

Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT423-430.xls See how to add