You’re scheduled to interview for a job whose description calls for “advanced Excel skills." You’ve used Excel for basic data entry… but what the heck is a PivotTable?n How the heck are you going 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” →
Don’t Underestimate the Weather! RNC Analyst Musings
Many of you know that I call Cleveland, Ohio, home. So I felt it behooves me (see photo #3, har) to add a blurb from the convention. No politics here, just a kind of question that only an analyst …
Continue Reading about Don’t Underestimate the Weather! RNC Analyst Musings →
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( ) →
Excel Tip: It’s all in the PDF and Print.
These are the little things that make a good analyst. You should not assume your recipient has Excel, especially if the recipient will be reading the report from a point of service like a retail …
Continue Reading about Excel Tip: It’s all in the PDF and Print. →