Excel Tips: Age data Validation Tricks for HR Pros

Table of Contents

Introduction

Are you looking to ensure accurate age data in your Excel sheets, particularly for HR purposes? Our recent YouTube video, titled “Excel Tips: Age Data Validation Tricks for HR Pros!” offers a comprehensive guide on this topic. The video focuses on implementing Age Data Validation for employee data, ensuring that only ages between 18 to 60 are entered.

Understanding the Basics

Before diving into the steps, let’s understand the data used in this example. We worked with a simple Excel sheet containing three columns: Employee Name (Column A), Supervisor Name (Column B), and Age (Column C). The key focus was on Column C, where we applied the data validation rule.

Step-by-Step Guide to Age Data Validation

Step 1: Selecting the Age Column

Firstly, select the range of cells in Column C (the Age column). This is where the age data of employees will be entered.

Step 2: Accessing Data Validation

Next, press Alt + D + L shortcut key on your keyboard. This shortcut opens the Data Validation window in Excel, a crucial tool for setting validation rules.

Step 3: Setting the Validation Criteria

In the Data Validation window, go to the ‘Settings’ tab. Here, follow these sub-steps:

Select “Whole Number” in the “Allow” dropdown. This ensures that only whole numbers are entered.
Choose “between” in the “Data” dropdown. This sets the condition for the age range.
Enter 18 in the minimum field and 60 in the maximum field. This restricts age entry to between 18 and 60 years.

Step 4: Customizing the Error Alert

Move to the ‘Error Alert’ tab. Here, you can customize the alert that appears when incorrect data is entered:

Choose “Stop” in the “Style” dropdown. It will prevent invalid data entry.
In the Title box, enter the “Incorrect Age”.
In the Error message box, type “Enter the Age between 18 to 60”.

Step 5: Finalizing the Validation

Click on ‘OK’ to apply this data validation. Now, age column will only allow ages between 18 to 60. If you enter the incorrect age, then it will display below error message.

Wrapping Things Up

So, there you have it! Setting up age validation in Excel is pretty simple and super useful, especially for HR folks. I really suggest giving it a try. You’ll see how much easier it makes your work. Plus, when you’re dealing with people’s info, you want to make sure everything is spot on, right? That’s where this neat Excel trick comes in handy.

Give It a Go!

Now it’s your turn. Crack open Excel and put what you’ve learned into practice. Trust me, it’s easier than it sounds. And the more you use it, the better you’ll get. Plus, it’s always good to know you’re keeping your data accurate and tidy.

Stay Tuned for More

And hey, don’t forget to keep an eye out for more handy tips like this. We’ve got loads of tricks up our sleeves to help make your work life a breeze. So, stay tuned, and let’s keep making work stuff easier, together!

Visit our YouTube channel to learn step-by-step video tutorials

Youtube.com/@PKAnExcelExpert