View Detailed Profile
Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel

Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel

Download

Excel Magic Trick 1037: Make Table Reference Absolute by Copying And Pasting Instead Of Dragging

Excel Magic Trick 1037: Make Table Reference Absolute by Copying And Pasting Instead Of Dragging

Download

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable

Download

Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formula

Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formula

Many Amazing Formulas:

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Download

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Download

Excel Magic Trick 1019: Formula For Text Month Labels From Serial Date: EDATE, TEXT & COLUMNS

Excel Magic Trick 1019: Formula For Text Month Labels From Serial Date: EDATE, TEXT & COLUMNS

Download

Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally

Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally

... https://www.youtube.com/playlist?list=PLrRPvpgDmw0kjL4875H36yNhWBb0f-nci

Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.)

Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.)

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT431-439.xls See how to Count Workdays given a ...

Excel Magic Trick #176 Get Last Item in Column on Diff Sheet

Excel Magic Trick #176 Get Last Item in Column on Diff Sheet

Download

Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Download

Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)

Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)

Download

Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF?

Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF?

Download