I'm seeking a proficient Excel expert to create an intuitive, scalable spreadsheet that will help us manage prospective talent across multiple sectors within the Australian market for a client. Here’s what I envision:
- **Structure & Functionality:**
- Lists for specific job roles in banking and technology
(e.g., • Head of Digitisation & Operational Excellence
• Data Management Lead
• Chapter Lead, Head of Acquisition and Channel, Mortgages
and others.
- Ability to effortlessly enter and update multiple candidates' as potential options for each role.
We really only need to be able to add the name and light notes. This is more of a talent mapping exercise rather than a candidate database to track continuous conversations. So only basic info will be added.
Also a field for potential talent that may be needed in the future, (not a against a specific role) where are they now, a current company, job title, salary would be useful. We can draw this info form linked in and paste it in.
- **Spreadsheet Capabilities:**
- Fixed panel for open roles / and potential new roles
- Candidate status - ie available, not looking or potential etc
Space for additional notes on candidates added
- Easy to use for team members with varied Excel skill levels
- Ability to paste linkedin info on target candidates.
- **Ideal Freelancer Profile:**
- Expertise in Excel spreadsheet design and function
- Experience- Note this is a basic tool to map potential talent not a complex ATS as we already have this.
- This information will be used for management to understand the market and options available.
- - Ability to deliver a user-friendly basic interface with some light features
Your creativity and advice on ensuring the spreadsheet’s efficiency and scalability are appreciated. Looking forward to seeing how we can make a talent mapping spreadsheet.