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.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Relative References in Excel Tables||Selective Sub-totals in Pivot Tables [Quick Tip] »|