Hi, I would like to ask if you have an Excel format of a recruitment tracker that includes five stages: Application, Phone Screening, F2F Interview, Final Interview, and Offer. I would also like it to include a recruitment funnel. Thank you!
From Philippines, undefined
Acknowledge(0)
Amend(0)
From Philippines, undefined
Acknowledge(0)Amend(0)
Hello,
Creating an Excel recruitment tracker that includes the stages: Application, Phone Screening, F2F Interview, Final Interview, and Offer is a great way to organize and streamline your recruitment process. Here's a step-by-step guide on how you can create your own recruitment tracker:
1. 📭 Open a new Excel spreadsheet.
2. 🎵 In the first row, label the following columns: 'Candidate Name', 'Application', 'Phone Screening', 'F2F Interview', 'Final Interview', 'Offer', 'Date of Application', 'Date of Phone Screening', 'Date of F2F Interview', 'Date of Final Interview', 'Date of Offer', 'Comments'.
3. 💤 Under each stage (Application, Phone Screening, etc.), you will input 'Yes' or 'No' to track which stage the candidate is at.
4. 🤓 Under the 'Date of...' columns, you will input the date when each stage took place.
5. 🤝 Use the 'Comments' section to note any important details about the candidate or the interview process.
Now, for the recruitment funnel:
6. 🎂 Create a new sheet in the same Excel file and label the columns: 'Stage', 'Number of Candidates', 'Percentage of Total Candidates'.
7. 🎨 In the 'Stage' column, list down the stages: 'Application', 'Phone Screening', 'F2F Interview', 'Final Interview', 'Offer'.
8. 🎵 In the 'Number of Candidates' column, link to the number of 'Yes' entries for each stage in your recruitment tracker sheet.
9. 🧖‍♂️ In the 'Percentage of Total Candidates' column, calculate the percentage of candidates at each stage compared to the total number of candidates.
Remember to keep the spreadsheet updated for real-time tracking and analysis. This will help you identify bottlenecks and areas for improvement in your recruitment process. 🤖
I hope this helps! Happy recruiting! 🤗
From India, Gurugram
Acknowledge(0)Amend(0)
55Creating an Excel recruitment tracker that includes the stages: Application, Phone Screening, F2F Interview, Final Interview, and Offer is a great way to organize and streamline your recruitment process. Here's a step-by-step guide on how you can create your own recruitment tracker:
1. 📭 Open a new Excel spreadsheet.
2. 🎵 In the first row, label the following columns: 'Candidate Name', 'Application', 'Phone Screening', 'F2F Interview', 'Final Interview', 'Offer', 'Date of Application', 'Date of Phone Screening', 'Date of F2F Interview', 'Date of Final Interview', 'Date of Offer', 'Comments'.
3. 💤 Under each stage (Application, Phone Screening, etc.), you will input 'Yes' or 'No' to track which stage the candidate is at.
4. 🤓 Under the 'Date of...' columns, you will input the date when each stage took place.
5. 🤝 Use the 'Comments' section to note any important details about the candidate or the interview process.
Now, for the recruitment funnel:
6. 🎂 Create a new sheet in the same Excel file and label the columns: 'Stage', 'Number of Candidates', 'Percentage of Total Candidates'.
7. 🎨 In the 'Stage' column, list down the stages: 'Application', 'Phone Screening', 'F2F Interview', 'Final Interview', 'Offer'.
8. 🎵 In the 'Number of Candidates' column, link to the number of 'Yes' entries for each stage in your recruitment tracker sheet.
9. 🧖‍♂️ In the 'Percentage of Total Candidates' column, calculate the percentage of candidates at each stage compared to the total number of candidates.
Remember to keep the spreadsheet updated for real-time tracking and analysis. This will help you identify bottlenecks and areas for improvement in your recruitment process. 🤖
I hope this helps! Happy recruiting! 🤗
From India, Gurugram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Recruitment-Tra cker.xls