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” →
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. →
Course Preview: The Essential Guide to Interviews
This is an introduction to my new Udemy course, "Hired with Excel: The Essential Guide to Interviews."This is a companion to "Hired with Excel: What Every Analyst Needs to Know." I lay out a gameplan …
Continue Reading about Course Preview: The Essential Guide to Interviews →