Redesign Excel Erasmus+ Dashboard

  • Status: Closed
  • Preis: €250
  • Einträge eingereicht: 10
  • Gewinner: Amagdy1960

Kurzbeschreibung des Wettbewerbs

BACKGROUND
I maintain an Excel‑based dashboard used by International Office staff at several European vocational colleges to manage and monitor Erasmus+ administration.
The workbook is used daily and already contains accurate data and calculations. The main need is to improve the layout, visual hierarchy, and usability, while keeping everything fully maintainable in native Excel.

WHAT THE DASHBOARD TRACKS
The dashboard monitors the following 6 key performance indicators (KPIs), each with planned vs. registered values where applicable:
1. Total Erasmus+ budget available
2. Available budget for partner countries
3. Available budget per college location (planned vs. registered)
4. Total number of participants with fewer opportunities (planned vs. registered)
5. Total number of participants in blended activities (planned vs. registered)
6. Total number of persons using green travel options (planned vs. registered)

SCOPE OF WORK
Please focus on design, structure, and clarity, not on rebuilding the underlying logic.

REQUIRED TASKS
- Create a new “Dashboard” tab that clearly and intuitively presents the six KPIs listed above.
You may also propose and include additional KPIs if, in your professional judgment, they add meaningful
insight or value for International Office staff.
- Redesign the existing “2025” tab, which contains the underlying tables
- Improve readability, consistency, and visual hierarchy
- Ensure the design scales well if the number of colleges increases

DESIGN CONSIDERATIONS
A) Users work entirely within the Microsoft ecosystem. A look and feel inspired by Microsoft Fluent Design is strongly preferred.
B) Each college using the file has its own color palette, its own logo. The design should be easy to customize per college.
C) The file currently includes 4 example locations (e.g. College Noord, College Zuid). In reality, location names vary widely. Some colleges may have 10–15 locations. The design must adapt easily to a variable number of colleges.

TECHNICAL CONSTRAINTS
- Stay entirely within native Excel
- No VBA / Macros (blocked by IT security policies)
- Refine existing data model, formulas, or pivot tables only where necessary. There is no need to rebuild the file from scratch. Maintainability by non‑technical colleagues is essential.

DELIVERABLES FOR THE COMPETITION
Please submit:
- One image showing the proposed Dashboard design
- One image showing the redesigned ‘2025’ tab

(Mockups, screenshots, or exported images are all acceptable.)

FINAL DELIVERABLE (after selection)
A fully updated .xlsx file
Ready for internal use and sharing
Clean, documented, and easy to maintain

Empfohlene Fähigkeiten

Feedback vom Arbeitgeber

“Ahmed did an excellent job on our complex Excel dashboard project, including visualizations with filters, slicers, and pivot tables. He delivered all agreed outcomes to a high standard, and we’re very happy with the results. We’ll definitely be hiring him again for additional functionality.”

Profilbild eor555, Estonia.

Top-Einträge für diesen Wettbewerb

Mehr Einträge sehen

Öffentliche Anschlagtafel

  • Farrukh Saeed
    Farrukh Saeed
    • 1 Monat zuvor

    someone from india reposted this contest as project
    https://www.freelancer.com/projects/business-intelligence/Redesign-Excel-Erasmus-Dashboard-40389110/details

    • 1 Monat zuvor
    1. eor555
      Wettbewerbs-Inhaber
      • 1 Monat zuvor

      Thank you Farrukh for bringing this to my attention. I reported this to Freelancer.com.

      • 1 Monat zuvor
  • PadmR
    PadmR
    • 1 Monat zuvor

    Hello Sir Please reconsider my entry #19. I'm a teacher of Excel, and I have experience. I'm perfect Fit for your project. Hope you understand.

    • 1 Monat zuvor
    1. PadmR
      PadmR
      • 1 Monat zuvor

      #19

      • 1 Monat zuvor
    2. PadmR
      PadmR
      • 1 Monat zuvor

      If you need proof of my work Contact me I'll share you

      • 1 Monat zuvor
  • hassanr313
    hassanr313
    • 1 Monat zuvor

    Kindly review my entry #103 . I have designed the dashboard with a focus on clarity, usability, and a modern professional layout, ensuring that even non-technical users can easily understand the insights.

    • 1 Monat zuvor
  • MagedAtya
    MagedAtya
    • 1 Monat zuvor

    #extended Please

    • 1 Monat zuvor
  • emansalahali
    emansalahali
    • 1 Monat zuvor

    #extended

    • 1 Monat zuvor
  • hassanr313
    hassanr313
    • 1 Monat zuvor

    Kindly review my entry #103. I have designed the dashboard with a focus on clarity, usability, and a modern professional layout, ensuring that even non-technical users can easily understand the insights.

    • 1 Monat zuvor
  • ahtishamf5
    ahtishamf5
    • 1 Monat zuvor

    Please check #102. I have done it on Excel (completely).

    • 1 Monat zuvor
  • naqibrahmanb5
    naqibrahmanb5
    • 1 Monat zuvor

    Dear friend, Entry #101 is now 100% complete and fully aligned with your requirements. Every detail has been carefully implemented to match your exact needs, and I confidently guarantee that everything is accurate, reliable, and professionally executed.

    This solution is built for real-world use—clean, structured, and easy to maintain with 100% native Excel.

    For more confidence or to review similar high-quality work, feel free to message me privately. I’m ready to support you and provide any additional details you need.

    • 1 Monat zuvor
  • hassanr313
    hassanr313
    • 1 Monat zuvor

    Sir, please wait. I am working on it and will submit the entry before the deadline.

    • 1 Monat zuvor
  • SakibKaiser
    SakibKaiser
    • 1 Monat zuvor

    Hello, did you checked entry #77 ? It's made with excel completely and fulfills all your requirements. Most of the entries here you are seeing not excel based. Have a look again.

    • 1 Monat zuvor
  • hassanr313
    hassanr313
    • 1 Monat zuvor

    Sir, please wait. I am working on it and will submit the entry before the deadline.

    • 1 Monat zuvor
  • naqibrahmanb5
    naqibrahmanb5
    • 1 Monat zuvor

    Your requirements were implemented through a structured 4-phase approach:
    Phase 1 – Analysis: Carefully reviewed your existing workbook, KPIs, and Erasmus+ workflow to preserve accuracy while identifying usability gaps.
    Phase 2 – Data Structuring: Refined the “2025” tab for clarity, consistency, and scalability—ensuring it supports multiple locations (10–15+) without complexity.
    Phase 3 – Dashboard Design: Built a clean, Fluent-inspired “Dashboard” tab with clear KPI hierarchy (planned vs. registered), optimized for daily use by International Office staff.
    Phase 4 – Usability & Flexibility: Ensured full native Excel compatibility (no VBA), easy customization (colors/logo per college), and long-term maintainability.
    The result is not just a design—but a practical, scalable system ready for real-world Erasmus+ management.#43

    • 1 Monat zuvor
  • Farrukh Saeed
    Farrukh Saeed
    • 1 Monat zuvor

    have a look #56

    • 1 Monat zuvor
  • ShivaniGoyalsai
    ShivaniGoyalsai
    • 1 Monat zuvor

    how do get a access to share point ?

    • 1 Monat zuvor
  • naqibrahmanb5
    naqibrahmanb5
    • 1 Monat zuvor

    Dear friend, Entry #43 is now 100% complete and fully aligned with your requirements. Every detail has been carefully implemented to match your exact needs, and I confidently guarantee that everything is accurate, reliable, and professionally executed.

    This solution is built for real-world use—clean, structured, and easy to maintain with 100% native Excel.

    For more confidence or to review similar high-quality work, feel free to message me privately. I’m ready to support you and provide any additional details you need.

    • 1 Monat zuvor
  • naqibrahmanb5
    naqibrahmanb5
    • 1 Monat zuvor

    Entry #43 is now approximately 80% complete and fully aligned with your requirements. The structure, KPI layout, and dashboard logic have been carefully built to match your workflow using 100% native Excel—no VBA—ensuring long-term usability and easy maintenance.

    I specialize in creating clean, scalable Excel systems that are not just visually strong, but also practical and reliable for daily use across multiple locations. Every element is designed with clarity, accuracy, and real-world application in mind.

    I confidently guarantee that the final result will meet your expectations exactly as requested. If you’d like to review the current progress or discuss final adjustments, feel free to message me—I’m ready to complete and refine it quickly.

    Choose Entry #43 if you want a solution you can trust and use with confidence every day.

    • 1 Monat zuvor
  • hassanr313
    hassanr313
    • 1 Monat zuvor

    Sir please wait I am working on it and I am sure you will like my design.

    • 1 Monat zuvor
  • nayana137
    nayana137
    • 1 Monat zuvor

    Hi, I’ve submitted my design — Entry #54 #55. Happy to refine it based on your feedback.

    • 1 Monat zuvor
  • alialasif
    alialasif
    • 1 Monat zuvor

    You can check #58

    • 1 Monat zuvor
  • hassanr313
    hassanr313
    • 1 Monat zuvor

    wait i am working on it

    • 1 Monat zuvor
  • Farrukh Saeed
    Farrukh Saeed
    • 1 Monat zuvor

    wait i am working on it

    • 1 Monat zuvor
  • naqibrahmanb5
    naqibrahmanb5
    • 1 Monat zuvor

    I specialize in designing clean, fully maintainable Excel dashboards for real-world daily use—especially where clarity, structure, and reliability matter most.

    Entry #43 is not just a visual improvement; it’s a practical solution built around your exact workflow. It clearly presents all KPIs with a strong visual hierarchy, keeps everything 100% native Excel (no VBA), and is designed to scale بسهولة across multiple colleges and locations.

    My focus is simple: make your data instantly understandable and easy for your team to maintain without technical complexity.

    If you’d like to discuss details or see more proven work, feel free to message me here in the public chat—I’ll respond quickly and transparently.

    If you want a solution you can trust and use every day, choose Entry #43.

    • 1 Monat zuvor
  • sihinas2
    sihinas2
    • 1 Monat zuvor

    Lot of AI GENERATED IMAGES

    • 1 Monat zuvor
  • SakibKaiser
    SakibKaiser
    • 1 Monat zuvor

    Hello, I rebuilt the Erasmus+ mobility tracker into a professional, ready-to-share dashboard that's as easy to maintain as it is to read. Entry #40

    • 1 Monat zuvor
  • amitk654
    amitk654
    • 1 Monat zuvor

    Please review entry #31

    • 1 Monat zuvor
  • Osama102
    Osama102
    • 1 Monat zuvor

    Hello,
    will you share the colour palette please!
    Thanks

    • 1 Monat zuvor
  • sihinas2
    sihinas2
    • 1 Monat zuvor

    #28 The upgraded Erasmus+ Dashboard transforms raw administrative data into a professional, "at-a-glance" management tool. Key features include high-impact **KPI Scorecards** for real-time tracking of budget availability and expenditure. It utilizes a **smart data model** that automatically calculates "Effective Participants" by extracting group mobility counts from complex text fields, ensuring accurate reporting.

    The visual layout includes a **Horizontal Bar Chart** designed for readable activity descriptions and a **College Distribution Pie Chart** for monitoring participation across locations. Built natively in Excel with a modern "Midnight & Steel" palette, the workbook is **fully automated via Python** but requires no Macros or VBA, maintaining 100% compliance with IT security policies while delivering a clean, corporate-ready interface for International Office staff.

    • 1 Monat zuvor
  • hanying1
    hanying1
    • 1 Monat zuvor

    sir, pelase check my Entry #17

    • 1 Monat zuvor
  • rozeakter1112131
    rozeakter1112131
    • 1 Monat zuvor

    Please check #23 and give your feedback.

    • 1 Monat zuvor
  • PadmR
    PadmR
    • 1 Monat zuvor

    Hello Sir can we chat I need some data for recreating the whole site please DM me I'm waiting for you replay Their are 99.99% entries are just images

    • 1 Monat zuvor
  • PadmR
    PadmR
    • 1 Monat zuvor

    Sir Please stay aware from ai images

    • 1 Monat zuvor
  • naqibrahmanb5
    naqibrahmanb5
    • 1 Monat zuvor

    Entry #18 is designed with one goal: clarity + reliability for daily use.

    I didn’t just improve visuals — I structured the dashboard so your team can instantly understand budget status, participant distribution, and activity insights without confusion. Everything is built using native Excel (no VBA), clean layouts, and consistent color themes tailored for your colleges.

    This means: easy updates, zero technical dependency, and a professional look your team can trust every day.

    For more detailed samples and similar work, please send me a private message or check my profile.

    • 1 Monat zuvor
  • SHABNAM10AKTHER
    SHABNAM10AKTHER
    • 1 Monat zuvor

    Hi there ?

    I’ve completed the dashboard exactly according to your requirements and focused on keeping it clean, professional, and easy to understand for daily use.

    Unfortunately, I’m unable to upload the Excel file directly here, so I’ve attached a few screenshots to give you a clear preview of the work. Please have a look when you get a moment.

    My entry number is #12.

    If everything looks good, I’d be happy to share the full .xlsx file right away or make any adjustments you’d like.

    Looking forward to your feedback!

    • 1 Monat zuvor
  • ashdip
    ashdip
    • 1 Monat zuvor

    You can message me and I can share the actual Excel file for testing

    • 1 Monat zuvor
  • ashdip
    ashdip
    • 1 Monat zuvor

    Check #11. I have redesigned the UI on Excel

    • 1 Monat zuvor

Mehr Kommentare zeigen

Einstieg in Wettbewerbe

  • Veröffentlichen Sie Ihren Wettbewerb

    Veröffentlichen Sie Ihren Wettbewerb Schnell und einfach

  • Erhalten Sie zahlreiche Einträge

    Erhalten Sie zahlreiche Einträge aus der ganzen Welt

  • Vergeben Sie die Prämie an den besten Eintrag

    Vergeben Sie die Prämie an den besten Eintrag Laden Sie die Dateien herunter - ganz einfach!

Wettbewerb Veröffentlichen oder registrieren Sie sich heute!