Advanced Excel/VBA Dashboard Development for School
$10000-20000 AUD
Posted 1 minute ago
•
Ends in 6 days
$10000-20000 AUD
Paid on delivery
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.
Project ID: 40819863
About the project
40 proposals
Open for bidding
Remote project
Active 41 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
40 freelancers are bidding on average $11,988 AUD for this job


A useful support register needs to show staff not just which students need help, but which interventions are active, who owns the next action, and when a review is due. I can build a macro-enabled Excel register with guided entry forms, validated fields, searchable records, and dashboards that highlight overdue reviews and summarise support by year group or intervention type. I’ll map your existing school data into a consistent structure so reports are reliable and staff do not have to enter the same information twice. Because student records are sensitive, I’d also plan for appropriate access controls and an edit history. If several staff need to update the register at once, we should agree on how files will be shared before relying on Excel as a central database. What location would face-to-face work be in? If you can share a sample of your current data and the reports staff need, I can propose a practical workbook structure.


Creating a Centralised Support and Intervention Register for your school requires a robust approach to Excel and VBA development. I can build a dynamic, macro-enabled dashboard that efficiently manages student support needs while allowing for seamless integration of data workflows and detailed reporting capabilities. My skillset includes advanced Excel, VBA automation, and database management, all critical for this project. I have a verified track record with a 4.9-star rating across 200 client reviews and 220 projects completed. What specific metrics or data inputs do you envision for the dashboard?


⚠️ If you're not happy, you don’t pay. ⚠️ Hi Client, thank you for checking my proposal and sharing the detailed project brief. I can build your Centralised Support and Intervention Register using advanced Excel and VBA, with a user-friendly and efficient design. I will deliver: • Complex macro-enabled dashboards for real-time insights • Automated reports and summaries from existing school data • Seamless workflows for data input and output • User access control for enhanced security • Comprehensive data validation to ensure accuracy You will also receive: • Detailed documentation for ongoing maintenance • A training session for staff to maximize usage I am confident I can execute your vision professionally and efficiently. Looking forward to discussing timeline and next steps. Best regards, Chirag Pipal.


Hi, I am Adeel. I would start by agreeing who can see what, since student support data needs tight access control. Then I would build a validated input form that writes to one clean data table, so every dashboard and report refreshes from the same source. Existing school data would come in through repeatable import macros that check each record before it lands. Which system holds the current student data today? I built Florence College, a Microsoft 365 collaboration and document management platform for an independent college, where access rules and structured records mattered from the start. Over 10 years I have completed 161 projects here and I am in the top 3% of freelancers, as a Microsoft Certified Solution Developer. I am just a message away whenever you want to talk through the access model first.


Hi. I'll share similar Excel and VBA dashboards in chat. Building a Centralised Support and Intervention Register is right in my wheelhouse, a macro-enabled workbook where staff input student support needs through clean, validated forms, and the dashboards and summaries update automatically from that data, so nobody's editing raw tables by hand. I'd pull reports and summaries from your existing school data, mapping it in so staff don't re-enter anything, and build the input and output workflows so data flows in and out cleanly. Since this holds sensitive student information, I'd build it with proper data validation, protected sheets and access controls so records stay accurate and confidential, and keep the file structured so it's easy for your team to maintain after handover. One honest note: I work remotely, and I saw you'd prefer face-to-face with some remote acceptable, so I'd stay in close contact through regular calls and screen-shares, but if on-site is essential I understand. I'd confirm a fixed price once I've seen your current data and the exact reports you need, rather than guess high up front, and I can start as soon as we scope it. I understand you want one central macro-enabled register where staff manage student support needs, with dashboards and reports built automatically from your school data. I am familiar with advanced Excel, VBA macros, dashboards and data reporting. I can start work right away and contact me to discuss more details. Thanks. Smit


Hello. For a school-wide support register, the main challenge is keeping student intervention records consistent, confidential and easy for staff to update without creating conflicting versions of the data. I'd first review your existing spreadsheets and staff workflows, then build a structured Excel/VBA solution with validated entry forms, intervention tracking, automated summaries and role-specific dashboards. I'd separate the underlying records from reporting, add audit trails and test the workflows against real scenarios before staff handover. I'd also assess whether a shared database is needed for reliable multi-user access. Q1: Will multiple staff members need to update the register simultaneously? Q2: Is the existing student data held in Excel or a school management system? I'd start with a working register prototype and validate it with staff before expanding the reporting.


Hello!!! I recently finished a successful project merging the eSense GSR device with a JavaScript web application, allowing real-time data collection via the headphone jack. We provided low-latency signal processing, user-friendly UI for real-time GSR visualization, and reliable data logging/analytics. Our experience encompasses hardware-software integration and biometric data utilization. For your project, we suggest utilizing advanced Excel and VBA structures to build a robust Centralised Support and Intervention Register. Integrating automated macros and custom dashboards will improve data management and user engagement. Keeping data structured locally or through a centralized workbook provides adaptability for upcoming analytics and reporting. Could you explain the intended environment, are you focusing on shared network deployment (for instance, multi-user desktop access), or is the application tailored for a particular operating system or device? This will affect how data workflows are managed and if additional validation or security measures are required. Let's discuss in more detail now. Reach out to initiate a conversation! Best regards, Digital Web Giants :


Hi, I have experience developing data-driven management systems, automated reporting workflows, and operational dashboards, including student records, activity tracking, and administrative tools for educational environments. For your Centralised Support and Intervention Register, I'd start by reviewing your existing school data, staff workflows, and reporting requirements. I'd then build a structured Excel/VBA solution with controlled data entry, student support records, intervention tracking, follow-up dates, automated summaries, and interactive dashboards. I'd focus on reliable VBA automation, data validation, role-appropriate access, and clear reporting so staff can manage information consistently without unnecessary manual work. I'd also include testing, documentation, and staff training. I'm available for remote development and regular walkthroughs, with any required on-site sessions to be agreed separately.


Hello! This is John from Chicago. I am ready to build your Centralised Support and Intervention Register with automated dashboards, student support tracking, and streamlined reporting workflows, Exactly as you want. I’m a fullstack developer over 20 years experience in advanced Excel, VBA macros, UserForms, Power Query, PivotTables, and data visualization. I can consolidate existing school data, automate staff input and reporting, track interventions and outcomes, and implement data validation and access controls to protect sensitive student records. I’m available to start right away and happy to discuss the project details and face-to-face requirements anytime.


Hi, I'm Sufyan from Fourge. We can develop a centralised Excel/VBA support register with structured student records, intervention tracking, automated workflows and operational dashboards. We'll include role-appropriate reports and summaries with data validation and clear input forms to make daily use easier for school staff. Could you share your existing school data and confirm whether the register needs to support multiple staff members editing it simultaneously?


Hi, I can help develop a centralised Excel/VBA Support and Intervention Register that makes it easier for school staff to record student needs, track interventions, and generate meaningful reports. I'd approach this as a structured Excel application rather than just a collection of spreadsheets. Using VBA, structured tables, validation rules, and automated reporting, I'll build a system with: - Centralised student and support records. - Easy-to-use data entry forms for school staff. - Intervention tracking and progress monitoring. - Automated dashboards, summaries, and reports. - Controlled data input and export workflows. I'll also pay particular attention to data consistency, user permissions, and student information privacy. The system should be straightforward for staff to use without requiring advanced Excel knowledge. I'd first review your existing school data and reporting requirements, then agree on the database structure and dashboard design before development. Happy to discuss the requirements and plan the first development milestone!


Your Support and Intervention Register could be one macro-enabled workbook, with VBA forms for staff entry, a locked data table and dashboards that refresh from your existing school data. I'd map your current intervention workflow first, then deliver a working entry form and a first summary report for staff to test. For over five years I've built and run banking systems where sensitive records had to stay accurate and secure, which is how student support data deserves to be handled. Once you message me on Freelancer, I can share examples of data-entry and reporting work relevant to this register. Does your existing data come from a school system export, or from separate staff spreadsheets? Kind regards, Sonny Dube
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗