Avoid Hiring Boo-boos with Excel – COUNTIFS for the win [video]


Share on facebook
Share on twitter
Share on linkedin

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.

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.

Share on facebook
Share on twitter
Share on linkedin

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Howto export youtube video comments to Excel file?

How to export YouTube video comments to Excel file? – Free template + Power Query case study

This week, I am running a contest on YouTube. One of the criteria for picking winners is that they must comment on my video. So far, I got more than 200 comments. To make my job easier, I want to export the video comments to an Excel file. Turns out this is easily done once you have a Google developer API key. In this article, let me explain the process for extracting Youtube video comments to Excel table.

Leave a Reply