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! 🤗