The Job Candidates Tracker is a ready-to-use Excel template for recruiters, HR managers and small business owners who need to manage the whole hiring process in one workbook. It contains three linked worksheets, Candidates, Openings and Interviewers, each built as a formatted Excel table that expands automatically when new rows are added. In the Candidates sheet you record each applicant's name, email address and phone number, the position applied for, the candidate type and the interviewer's feedback. The Applying For and Assigned Interviewer columns use drop-down lists that are filled automatically from the job openings and interviewers entered in the other two sheets. Status, Candidate Type and Interview Score are selected from predefined drop-down lists, and their options can be edited with the Data Validation tool. Conditional formatting colours each status, from phone screen and interview through awaiting decision to hired, so the progress of every candidate is visible at a glance. Phone screen and interview dates are highlighted automatically when they fall due today or are overdue for candidates who are still at that stage. Phone numbers are formatted automatically, and the date columns use the short date format of the file's language. The Openings sheet lists each vacancy with its description, required experience, salary level and notes. The Interviewers sheet holds the interview panel with each member's department, position, availability and notes. All sheets are set up for landscape printing on one page width, and input prompts explain how to fill them in.
Skyline Blue, Blue Horizon, Bold Beacon, Citrus Clean, Classic Ledger, Evergreen Edge, Fresh Current, Luminous Lines, Midnight Pop, Mint Offer, Nocturne, Prism Point, Soft Touch, The Ledger, Violet Standard
Excel template, printable, conditional formatting, spreadsheet, small business, recruitment, hiring, human resources, skyline blue, blue horizon, bold beacon, citrus clean, classic ledger, evergreen edge, fresh current, luminous lines, midnight pop, mint offer, nocturne, prism point, soft touch, the ledger, violet standard, HR template, drop-down lists, business report, hiring pipeline, job candidates tracker, applicant tracking, recruiter, job openings, vacancies, interview schedule, interviewers, interview score, candidate status, salary level