Avoid Hiring Boo-boos with Excel – COUNTIFS for the win [video]
Imagine you are head of human resources at Casual Contracting Co. Every month you hire a lot of temporary staff who spend 1-4 months with CCC before leaving. Sometimes you hire the same people again. Of late, you have noticed a strange process gap. You are paying same person two (or more) salaries.
This is because you are hiring a person for new temp role even before their current one ended. See below picture.
So how to avoid making such hiring boo-boos.
Simple, using Excel of course.
There are a few ways to handle this problem.
- Using formulas to check if a person is hired twice in the same period
- Using conditional formatting to highlight such hires
- Using data validation to prevent such data entry
I made a video covering all these methods in detail. Check it out below or on Chandoo.org YouTube channel.
Download hiring boo-boos workbook
Click here to download the workbook showcased in the video. Play with various dates & names to test formulas, CF and data validation.
Avoid Excel Boo-boos, Show it who-da-boss
Learning few simple Excel best practices and techniques can save you a lot of time & money. So why wait, check out below links and become awesome in Excel.
- Advanced Excel skills & resources – learn the right way
- What is Conditional Formatting and how to use it? [Video]
- 5 tips to become conditional formatting rock star
- Introduction to SUMIFS
- MAX IF formula
While you are at this, subscribe to Chandoo.org YouTube channel. I have been uploading videos once a month. While this is not exactly a staggering pace, you are sure to be a rockstar at work if you just watch all the previous vids and stay tuned for more. Check it out.
Leave a Reply
|Relative References in Excel Tables||Selective Sub-totals in Pivot Tables [Quick Tip]|