Excel-based Candidate Short-lister Essay Example | Topics and Well Written Essays - 1000 words

Excel-based outlook Short-lister - Essay ExampleThe intelligent rule is based on the numbers of A grades in the requisite criteria requirements which is then sorted again by the number of As in the desired criteria. This gives a more scrutinized level of sorting, for selecting the most qualified candidates in case of huge number of candidates satisfying the requirements. Moreover, each(prenominal) page is enhanced with a Save and Print option so as to ease the act of saving the work and printing them whenever required, during the process. The below secrecy shot shows the initial screen of the tool. Figure1. Initial screen of the Candidate short-lister tool For easy navigation, View application data and view shortlisted data options be added in the initial sheet, which when clicked will take us to the respective sheet. The desired and the essential criteria for the line description be added in the respectively columns without any space between the cells and as well as betwee n the heading and the data as shown in figure 2 and Generate Application_data Sheet is clicked. This will create template for the Application data sheet for entering the application data (shown in figure 3). Figure2. Entering the essential and desired criteria for the job description Figure3. ... p, which when clicked will shortlist all the candidates satisfying the given requirements based on their grade and creates a report in the shortlisted Candidates sheet(figure 5). The minimum qualifying grade used in this selection process is also given in the Shortlisted Candidates sheet in pink line. If the user is not satisfied with the number of shortlisted candidates and involve to maximize or minimize the result, they can edit the field and refine the look to (figure 6). Figure4. Data are entered manually in the application data sheet In case, if we want to sort the report to strike a required number of candidates, we can use the Intellisort option in the shortlisted candidates shee t, which will internally discharge a sort based on the number of A grades in the essential criteria and again on the number of A grade in desired criteria. This is shown in figure 7. Figure 5. Short-listed candidates Figure6. Refine search by editing the options in pink line Figure7. Sorting the candidates using Intellisort If we want to shortlist simply the top 5 candidates for interview scheduling, we can click the Shortlist decease 5 button on the Shortlisted Candidates sheet which will internally perform an intellisort and selects the top 5 candidates and creates a report on the Top 5 Candidates sheet (figure 8). Figure8. Selecting the top 5