New Employee Checklist – Free Excel Template

Posted on
Sample Employee Certificate - Employee checklist

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.

The key features in this template are

  • 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

New Employee Checklist Excel Template

REQUIREMENTS: Microsoft Excel for Windows (2010 or above); Microsoft Excel for Mac (2011 or above);

 

VIDEO DEMO

 

HOW TO USE

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.

New Employee checklist - Settings
New Employee checklist – Settings

 

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.

 

New Hire Checklist - Employee Data
New Hire Checklist – Employee Data

 

These fields can be renamed as needed.

Then, we enter the activity completion dates for each employee, as they complete the activities.

New Hire Checklist - Employee Activity completion dates
New Hire Checklist – Employee Activity completion dates

Please do not rename these date fields, as they will impact the formulas used.

 

Print

In the Print sheet, we can print the certificate for each employee separately by choosing the employee name.

New Employee Checklist - Header - Choose Employee
New Employee Checklist – Header – Choose Employee

 

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.

New Employee Checklist - Header - Customize
New Employee Checklist – Header – Customize

 

There is no need to change the Activities section of the certificate.

New Employee Checklist - Activities List
New Employee Checklist – Activities List

 

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.

New Employee Checklist - Customize Footer
New Employee Checklist – Customize Footer

 

If you prefer to not have anything, you can select the cells, right click and clear contents.

New Employee Checklist - Clear Footer
New Employee Checklist – Clear Footer

 

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.

Sample Employee Certificate - Employee checklist
Sample Employee Certificate – Employee checklist

 

Another Sample Employee Certificate - Employee checklist
Another Sample Employee Certificate – Employee checklist

45 thoughts on “New Employee Checklist – Free Excel Template

  1. 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!!

    1. 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

  2. Thank you sir,would you like to send me this format to my mail.

    1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *