2024 New Employee Checklist – Free Excel Template
This Excel template is designed to document completion of activities in a checklist. HR departments in companies can use this to track or document new employee on-boarding activities. Typically, there is a list of activities that each employee has to complete to ‘on-board’ to the new company. We can use this one file to track such on-boarding for all employees.
This Excel template is designed for Microsoft Excel, but if you are looking for a Google Sheet template, please visit New Employee Checklist in Google Sheets.
Benefits of New Employee Checklist template
- Customize activities for your business (maximum 12 activities)
- Printable checklist for each employee
- Choose whether to print dates
- Customize header with ordering fields as you prefer
- Rename fields as needed (except the activity dt fields)
- Customize footer with your business information
- % Complete progress bar
- All employees’ data in one file
Free Download
Requirements
Microsoft Excel for Windows (2010 or above); Microsoft Excel for Mac (2011 or above);
Video Demo
How to use a new employee checklist in Excel?
The template has three sheets – Settings, Employees and Print. It uses Excel tables feature to store information.
If you are new to Excel Tables, please see article (with video) on Excel tables.
Settings
In the Settings sheet, let’s enter company name. If we don’t want to print activity dates, then choose No to that.
Finally, enter the list of activities.
Employee Data
In the Employees sheet, let us enter each employee and their information.
Tip: If you would prefer to print empty checklists and check items in the hard copy, then skip entering the Employee Data and directly move to Print step below.
These fields can be renamed as needed.
Then, we enter the activity completion dates for each employee, as they complete the activities.
Please do not rename these date fields, as they will impact the formulas used.
In the Print sheet, we can print the certificate for each employee separately by choosing the employee name.
We can change the fields in the header by using the drop down. This allows us to re-order fields to suit our needs. Also, if you had renamed the employee fields earlier, they will automatically appear here. 🙂
If you need to change the format of any of the cells (for example date to text or text to date), just select the cell and press Ctrl+1 to open the format cell dialog box.
There is no need to change the Activities section of the certificate.
At the end of the activities section, a Checklist Completed Dt will appear if the employee has completed all activities.
We can customize the footer area by providing contact information for your business and any internal links for reference for new employees. There are no formulas here. We can just type directly.
If you prefer to not have anything, you can select the cells, right click and clear contents.
Now that you have the certificate customized, we can print (Press Ctrl+P to print) or export to PDF using Excel’s built-in options.
The following are a couple of sample certificates printed.
Related Free Templates
Recommended Template
Related HR Templates
-
Compliance Training Dashboard Excel Template$40
-
HR KPI Scorecard & Dashboard$50
-
Employee Retention Dashboard Excel Template$50
-
Recruitment Tracker Dashboard Excel Template for Simplified Hiring ProcessOriginal price was: $89.$69Current price is: $69.
63 Comments
This is an amazing spreadsheet. Is there an updated version that allows for more than 12 activities to be tracked?
Thank you for showing interest in our template and sharing your valuable feedback.
We have premium version of the template with a limit of 25 and more advance reports. Following is the link to the same for quick reference:
https://indzara.com/product/hr-onboarding-dashboard-excel-template/
Best wishes.
Hi Sir.
i am trying to learn about this work book so i can make my own to present in my upcoing job interview. but print sheet is protected with password and i cant edit it.
please help.
Thank you for showing interest in our template.
The password to unprotect the sheet is indzara.
https://support.indzara.com/support/solutions/articles/62000137281-how-to-unprotect-sheets-
Best wishes.
Thank you for the amazing simple template im sure thousands of people finds it extremely useful
Thank you for sharing your valuable feedback.
Best wishes.
Dear Sir,
could you please tell me how to change the color of the completion bar?
Thank you
Following are the steps to change the completion bar colour.
1. Select the 10 cells of completion bar (G16 to P16)
2. Goto Home -> Conditional Formatting -> Manage Rules
3. Click Edit Rule to change the colour.
Best wishes.
Is it possible to add more activities?
Thanks for using our template.
As of now, only 12 activities can be added. We will try to add more in our future release.
Best wishes
Agreed, i can only use the template if i can add more than 12 options. I need many more. Disappointed. thx
Hello
As of now, only 12 activities can be added. We will try to add more in our future release.
Best wishes
Hello,
Is there a way to have the check boxes checked on the PRINT page when there is either a Date of completion OR N/A ? I need it to include both as being COMPLETE.
Thanks for using our template.
In case you enter NA for dates, it means that the stage is anyways not applicable for the employee, so the checkbox remains unchecked.
Best wishes
I am using this as a training matrix and do not want to include the N/A’s – is there a way to do this?
Hello
The checkbox will be ticked if a date is entered for that stage.
Else, it would remain unchecked.
Best wishes
Request you to make a similar tracker that works in google sheets as well please..!!! let me know if you can send me one. Thanks.
Thanks for your message.
We have designed and tested all our templates on MS Excel.
Best wishes
Hi there! I am editing this to include some tasks that need completing rather than on-boarding employees, as this template seemed to better fit my needs rather than a few of the other templates I reviewed. However, I am having trouble with getting the fields to display on the Print tab, & I’m sure it has something to do with the formulas. Any ideas on how to help? Thank you for creating something like this to aid in managing tasks better!!
Hello
Thanks for using the template.
This template is fairly simple, the issue could arise in case a formula has been edited by mistake. You download a fresh copy and see if it works. Else, email the file to contact@indzara.com.
Best wishes
Thank you sir,would you like to send me this format to my mail.
Hello
Thank you for your interest in our template.
Please download the file from https://indzara.com/2016/06/new-employee-checklist-free-excel-template/
Best wishes