Well, data is a bridge -- and it could lead to nowhere. This weekend I watched a BBC documentary called The Joy of Data. You can see it here, but I'm not sure for how long -- BBC does not post to …
Slideshare: “PivotTables: The WD-40 of Excel”
Here is an introductory Slideshare to my Guide to PivotTables.I love PivotTables so much that I often perplexed old coworkers and supervisors because almost everything I did was in a PivotTable.I'm …
Continue Reading about Slideshare: “PivotTables: The WD-40 of Excel” →
Slideshare: “VLOOKUP: The Duct Tape of Excel”
Here is an introductory Slideshare to my Guide to VLOOKUP.It's one thing to know the mechanics, another to understand WHY we need to know it. VLOOKUP's importance lies in the disperse nature of …
Continue Reading about Slideshare: “VLOOKUP: The Duct Tape of Excel” →
Excel for Healthcare Tip: Calculating On-Call Points with WEEKDAY( )
The WEEKDAY( ) function will return a number representing the day of the week for any date.In this example, I will show you how to use this to transform an on-call calendar from a slow, manual …
Continue Reading about Excel for Healthcare Tip: Calculating On-Call Points with WEEKDAY( ) →
The Guide to PivotTables
I call PivotTables the “WD-40 of Excel” because they allow you to loosen up and extract meaning and trends out of your data.Introductory SlideShare:Here are a few of my top posts …
Did that just work? Case formatting in Excel
I recently came across this quote from Isaac Asimov -- it is so true:I absolutely love this quote. Breakthroughs hardly happen when you expect them. This requires a level of humility and even …
Continue Reading about Did that just work? Case formatting in Excel →