Advanced Excel/VBA Dashboard Development for School

via Freelancer ·

Budget / SalaryA$10,000–20,000
TypeFreelance project
LocationRemote
Posted39 minutes ago
I need an experienced Excel/VBA developer to create a Centralised Support and Intervention Register. The register will be used by school staff to manage student support needs.

Key Requirements:
- Develop and maintain complex, macro-enabled operational dashboards and databases
- Create reports and summaries from existing school data
- Integrate workflows for inputting and outputting data
- Must work within the existing 57-sheet macro-enabled Excel workbook and retain all VBA, student photographs, formatting, and verified functions
- Design for approximately 2,000 students and many thousands of linked intervention records, ensuring reliable data integrity and scalable filters/lists
- Ability to troubleshoot complex legacy VBA, merged cells, workbook protection, and compatibility with existing controls
- Excel desktop/Windows solution only (no Power Automate, Office Scripts, cloud-based automation, or external platform dependency)

Ideal Skills:
- Advanced Microsoft Excel expertise: formulas, lookups, data validation/dropdowns, conditional formatting, linked worksheets, sheet protection/formatting
- Proficient in Excel VBA programming: modules/procedures, worksheet/workbook events, automated data entry/saving, error handling/macro debugging
- User-interface development: buttons/shapes, OnAction assignments, student search/filtered lists/navigation/dashboard layouts
- Data management: Student Register with unique IDs; linked support/intervention records; reviews/status changes/history retention
- Reporting/visualization: tier/domain dashboards; Faces on the Data student photographs; filters/summaries/progress-monitoring displays
- Testing/maintenance: VBA compile checks; save/close/reopen testing; backup/version control; regression testing while preserving macros/data integrity

Additional Requirements:
- Willingness to meet face-to-face to review the prototype and understand workflow requirements.
- Collaborate with our data import person mid-project and at project completion to ensure smooth integration of student/staff details into the registers.

Timeline:
The project should be completed by late January 2027. Collaboration during the school holiday break is expected.
visual basic data processing excel visual basic for apps excel macros data visualization data analysis data management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.