Advanced Excel/VBA Dashboard Development for School
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.
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.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.