Redesign Excel Erasmus+ Dashboard

  • Status: Closed
  • Prêmio: €250
  • Inscrições Recebidas: 9
  • Vencedor: Amagdy1960

Síntese do concurso

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

Habilidades Recomendadas

Winner
Concurso em Destaque
Lance um Concurso Como Este

Feedback do Empregador

“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.”

Foto do perfil eor555, Estonia.

Principais inscrições deste concurso

Ver Mais Inscrições

Painel de Comentários

  • Farrukh Saeed
    Farrukh Saeed
    • 3 semanas atrás

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

    • 3 semanas atrás
    1. eor555
      Proprietário do Concurso
      • 3 semanas atrás

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

      • 3 semanas atrás
  • PadmR
    PadmR
    • 3 semanas atrás

    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.

    • 3 semanas atrás
    1. PadmR
      PadmR
      • 3 semanas atrás

      #19

      • 3 semanas atrás
    2. PadmR
      PadmR
      • 3 semanas atrás

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

      • 3 semanas atrás
  • hassanr313
    hassanr313
    • 3 semanas atrás

    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.

    • 3 semanas atrás
  • MagedAtya
    MagedAtya
    • 3 semanas atrás

    #extended Please

    • 3 semanas atrás
  • emansalahali
    emansalahali
    • 3 semanas atrás

    #extended

    • 3 semanas atrás
  • hassanr313
    hassanr313
    • 3 semanas atrás

    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.

    • 3 semanas atrás
  • ahtishamf5
    ahtishamf5
    • 3 semanas atrás

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

    • 3 semanas atrás
  • naqibrahmanb5
    naqibrahmanb5
    • 3 semanas atrás

    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.

    • 3 semanas atrás
  • hassanr313
    hassanr313
    • 3 semanas atrás

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

    • 3 semanas atrás
  • SakibKaiser
    SakibKaiser
    • 4 semanas atrás

    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.

    • 4 semanas atrás
  • hassanr313
    hassanr313
    • 4 semanas atrás

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

    • 4 semanas atrás
  • naqibrahmanb5
    naqibrahmanb5
    • 4 semanas atrás

    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

    • 4 semanas atrás
  • Farrukh Saeed
    Farrukh Saeed
    • 4 semanas atrás

    have a look #56

    • 4 semanas atrás
  • ShivaniGoyalsai
    ShivaniGoyalsai
    • 1 mês atrás

    how do get a access to share point ?

    • 1 mês atrás
  • naqibrahmanb5
    naqibrahmanb5
    • 1 mês atrás

    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 mês atrás
  • naqibrahmanb5
    naqibrahmanb5
    • 1 mês atrás

    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 mês atrás
  • hassanr313
    hassanr313
    • 1 mês atrás

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

    • 1 mês atrás
  • nayana137
    nayana137
    • 1 mês atrás

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

    • 1 mês atrás
  • alialasif
    alialasif
    • 1 mês atrás

    You can check #58

    • 1 mês atrás
  • hassanr313
    hassanr313
    • 1 mês atrás

    wait i am working on it

    • 1 mês atrás
  • Farrukh Saeed
    Farrukh Saeed
    • 1 mês atrás

    wait i am working on it

    • 1 mês atrás
  • naqibrahmanb5
    naqibrahmanb5
    • 1 mês atrás

    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 mês atrás
  • sihinas2
    sihinas2
    • 1 mês atrás

    Lot of AI GENERATED IMAGES

    • 1 mês atrás
  • SakibKaiser
    SakibKaiser
    • 1 mês atrás

    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 mês atrás
  • amitk654
    amitk654
    • 1 mês atrás

    Please review entry #31

    • 1 mês atrás
  • Osama102
    Osama102
    • 1 mês atrás

    Hello,
    will you share the colour palette please!
    Thanks

    • 1 mês atrás
  • sihinas2
    sihinas2
    • 1 mês atrás

    #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 mês atrás
  • hanying1
    hanying1
    • 1 mês atrás

    sir, pelase check my Entry #17

    • 1 mês atrás
  • rozeakter1112131
    rozeakter1112131
    • 1 mês atrás

    Please check #23 and give your feedback.

    • 1 mês atrás
  • PadmR
    PadmR
    • 1 mês atrás

    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 mês atrás
  • PadmR
    PadmR
    • 1 mês atrás

    Sir Please stay aware from ai images

    • 1 mês atrás
  • naqibrahmanb5
    naqibrahmanb5
    • 1 mês atrás

    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 mês atrás
  • SHABNAM10AKTHER
    SHABNAM10AKTHER
    • 1 mês atrás

    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 mês atrás
  • ashdip
    ashdip
    • 1 mês atrás

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

    • 1 mês atrás
  • ashdip
    ashdip
    • 1 mês atrás

    Check #11. I have redesigned the UI on Excel

    • 1 mês atrás

Mostrar mais comentários

Como começar com concursos

  • Publique seu concurso

    Publique seu Concurso Rápido e fácil

  • Receba muitas inscrições

    Obtenha Toneladas de Inscrições De todo o mundo

  • Premie a melhor inscrição

    Premie a melhor inscrição Baixe os arquivos, é fácil!

Poste um Concurso ou Junte-se a nós Hoje!