We need an Excel Model for potential Applicants in our recruiting processes
Those should base on Variables such as:
1. Grades at School (if Master and Bachelor, an average of both --> Should base on a scoring system from 1-30 points (30 being the best) ) - 25% of overall weighting
2. Target University (whether a student is visiting a target university, yes or no --> So 10 or 0) - 10% of overall weighting
3. Practical Experience based on three variables (number of internships, length of internships, quality of Internships) - (number 7.5%, length 5%, Quality 17.5%) consolidated to 30% of overall weighting
4. A Focus Group --> Corporate, Strategy, StartUp, or PE/VC - no weighting it should just appear after the name
5. Subjective Rating --> from 1-10 (10 being the best) - 10%
6. Software Skills (PowerPoint, Excel, R, Python etc.) - should be all included (PowerPoint 10%, Excel 10%, Rest 5% --> total 25%
This should be all clickable (in a dropdown or similar) and appear in a new dataset which should include the name, last name, [login to view URL], Focus Group (see above) and total Score of the candidate.
There should also be a tab which consolidates all candidates automatically and another tab showing a heat map where our candidates are in scoring. --> Maximum Points = 100. Lowest Points = 0) --> This can also be combined with R or Python
VBA (Visual Basic) and Macro Skills in Excel is a MUST!
This has to be clean work and has to be done very thoroughly.
19 pekerja bebas membida secara purata €83 untuk pekerjaan ini
I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's). I already build Many VBA model's and Dashboards.
I'm a specialist in Excel and macros programming. Also know something about Python. I think I could deliver a good work. Relevant Skills and Experience Lot of programming.
I am a retired engineering manager and a successful freelancer. I have the technical skills (macros, VBA) to get it done and interest/background in recruiting/evaluations.
Hi! I have been working with Excel for more than 8 years so I am an expert with Macros and VBA. I can deliver quality and accuracy in everything you may need. I hope to hear from you soon!