Create an Excel Invoice Template with Database for Staffing Effortlessly

Excel invoice template with database for Staffing

[Music] hi this is ivan with simplesheets in this video we're going to do a step-by-step tutorial of a recruitment management template this is one of over a hundred pre-built and smart templates that we offer click the link in the description and try five free templates before you buy let's get started the introduction sheet contains a short description about this template the employees are the lifeblood of any company and the hiring process is a way to keep the workforce refreshed and thriving this template would greatly help in that process over here we have a customization difficulty an explanation of the sheets that come with this template and some instructions on how you can utilize this template at the bottom we have a short guide on using our templates with compatible online services we start in the recruitment database sheet it's here where we input the company standards when it comes to the hiring process we input the job level application source reasons for rejection job type locations and pipeline stages the application status column is pre-made and locked for editing moving to the jobs datasheet we input the different jobs that the company is offering do note to only put data into white cells because the grayed out cells contain automated formulas you start in the sheet by assigning a job code for the job opening the department the hiring manager job title job level gender job type vacant number location job posting date the running number to be hired the job status closing date hiring cost and any other comments about the position to add a new entry simply follow the job arrow at the bottom and enter the data there moving on to the applications data sheet select the available jobs from the drop down list if you wish to see the job details further click the plus sign on top input other details like the recruiter name the candidate application source application date and the last recruitment stage that the applicant made it to once the hiring process is done input the final decisions using the drop down if the applicant is rejected input the reasons as to why input the decision date and the joining date if you want to see more fields for additional comments click the plus sign at the top in the candidates report tab we have an overview of the different applicants with the different stages that they're in the decision rejection reasons decision dates joining dates hr comments and technical comments you can edit the information that you see using the slicers on top you can filter by department job status and available jobs it also gives you some quick stats such as the available vacants total applications accepted shortlisted in process and rejected moving on to the candidates information sheet you input here all the candidates you want to keep on file input their name attach a hyperlink to their cv by right-clicking the cell clicking insert link then selecting the corresponding file plugin experience field date of birth gender phone number address and email address as well lastly we have the recruitment dashboard it shows the aggregates of your data which includes total jobs total hiring costs and days in market you can also see how many individuals are in the different stages of the recruitment pipeline and see a summary of the different rejection reasons it also gives you some stats such as percentage rates for acceptance shortlisted in process and rejected we also have graphs for the required higher areas versus the hired areas a graph showing the different jobs and the number of hired versus the number left to hire as well as a summary of the application sources on a pie chart again you have some dynamic slicers to change what shows on the charts you can filter by department job status job type application source applications department and job posting date for both the recruitment dashboard sheet and the candidates report sheet they have a refresh macro button to update the charts with new data that you enter we also have a full screen macro button which when pressed hides the ribbon if you want your ribbon back just minimize the window and it should be right there this template makes a gigantic task such as managing your job openings and applicants a breeze that's all for this template if you want to automate your xlr processes and enhance your level of productivity simple sheets advanced templates and university is the best tool out there i'll see you guys on the next one