Do some Excel Work
$30-250 USD
Paid on delivery
I am looking for a Microsoft Excel master to create what I am calling an “Active Skills Matrix”. Basically, the excel spread sheet should be designed to provide the following functionality:
Show a list of people vertically in column A
Show a list of skills / knowledge areas horizontally across the top that can be mapped to an individual person
Allow a person to rate their own proficiency (i.e. from 1 to 3 for example) for each individual skill / knowledge area using a drop down box i.e. 1(green fill), 2 (orange fill), 3 (red fill) etc which are assigned to a number
Show the rating criteria for both knowledge level and proficiency to assist them in understanding how to rate themselves correctly
Allow a manager to rate the supervision level required to be applied to an individual for each individual skill using a drop down box (i.e. from 1 to 3 for example)
Assign the individual skills to a discipline or multiple disciplines i.e. Security Design Services, Security Risk Services, Business Resilience, Crisis Management, Business Continuity, Project Management, Close Protection, Emergency Management etc
Assign the individual skills to project type i.e. CCTV design, Security Risk Assessment, Feasibility Study etc.
Assign the individual skills to a deliverable type i.e. TRA Report, Project Management Plan, Specification, etc
The spreadsheets objective (based on the inputs) is to rank people as follows:
Individual profile for each person (graph / pie chart etc) showing their proficiency / rating in each individual skill / knowledge area
Analyse and rank people best suited to a discipline
Analyse and rank people best suited to a project type
Analyse and rank people best suited to a deliverable type
Upon project award, I will provide the raw data that needs input into the spreadsheet.
Project ID: #6851189
About the project
65 freelancers are bidding on average $129 for this job
Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n More
Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to More
Hello, I am highly interested in your project and able to deliver quality work. Let's discuss about details. Best regards,
Hi: Will the spreadsheet have two separate pages: one for input and the other to view the summary? Summary could show the best 5 people in a discipline or a project type or a deliverable. Please note that I have 100% c More
Hi. I am Usman and I have been working with Excel applications for a long time. I have designed a very similar application in Excel before and I shall be able to get it done for you exactly as you desire. Kindly discus More
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More
Hey, What you are looking for is something similar to stack ranking system. Right? I can create a spreadsheet template for you which will allow the users to input the ratings and also do project assignments as requi More
Hello, Read and understood project details. We have a lot of experience of data scarping and data entry. We can do this job very well also we are ready to do sample entries. Hope to getting consider for this also pleas More
Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.
Hello dear sir, I'm very interested in the job and ready to start immediately once you accept my bid, I'm a full time worker having all skills needed to complete your job perfect on time. kindly check my profile and s More
Hello, This is richag from "Hire WordPress Experts" and I am here to help you with Do some Excel Work . We have gone through the information provided by you. and I can assure you that we are expert with Data Entry, D More
I can do this, see my portfolio and contact me if you're interested. Thanks, TOm______________________________________________________________________
Hello I can do this project as I had done projects of excel, virtual assistance and data entry before as you can check my profile. I can provide you samples of my previous work. I hope you would like to work with me More