View Detailed Profile
Excel Magic Trick #238: Round Times To 5 Minutes

Excel Magic Trick #238: Round Times To 5 Minutes

Download

Excel Magic Trick #237: ROUND to Digit or Multiple

Excel Magic Trick #237: ROUND to Digit or Multiple

Download

Excel Magic Trick 1028: Create Hyperlinks to Duplicate Text Titles In Column A On Different Sheet

Excel Magic Trick 1028: Create Hyperlinks to Duplicate Text Titles In Column A On Different Sheet

Download

Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment

Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment

Download

Excel Magic Trick 1478: Conditional Format Row When Event Code is a Duplicate AND Task  = "Special"

Excel Magic Trick 1478: Conditional Format Row When Event Code is a Duplicate AND Task = "Special"

Download Files: Start

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Download

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 347: Magic Moments In Excel! MROUND v ROUND functions

Excel Magic Trick 347: Magic Moments In Excel! MROUND v ROUND functions

What To Do When No MROUND. IncongruentBalance sends in a

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

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

Excel If statement

Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ROUND & MROUND

Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ROUND & MROUND

Download

Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)

Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)

Download

Excel Magic Trick #182: Workbook References

Excel Magic Trick #182: Workbook References

Download

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Download