I will create excel scoring model with dashboard and automation

Turn messy spreadsheets into a decision-making tool.

I build weighted scoring and ranking models in Excel the kind HR, admissions, procurement, and grant/scholarship teams use to evaluate candidates or applicants fairly and consistently, backed by a live dashboard instead of a static table.

With a background in HR/L&D (6 years) and hands-on Excel/Tableau certification, I understand both the business logic behind scoring criteria and the technical build so the model isn't just formulas, it reflects how real evaluation decisions get made.

What you get:

• Custom weighted scoring model (criteria + weights tailored to your use case)
• INDEX/MATCH-based lookup and ranking system (no manual re-sorting)
• Clean, automated dashboard filter, sort, and visualize results instantly
• Anonymized/scalable structure you can reuse for future evaluation rounds
• Short screen-recorded walkthrough explaining how to use it

Use cases: candidate/applicant ranking, scholarship & award allocation, vendor selection, employee performance scoring, KPI tracking.

I keep communication clear and async-friendly happy to iterate over messages rather than lengthy calls.