
Closed
Posted
Paid on delivery
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
Project ID: 40391871
9 proposals
Remote project
Active 24 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average ₹21,722 INR for this job

Hello, I’m Jenifer, and I have 5+ years of experience in Excel automation and creating clean, user-friendly dashboards that are actually easy to use day-to-day. I’ve worked on similar dashboards where the goal wasn’t changing data, but improving clarity and structure. For example, I redesigned a multi-location performance tracker where KPIs (planned vs actual) were hard to read, and turned it into a clean, scalable dashboard with better hierarchy and quick insights. Also handled a reporting sheet where multiple stakeholders needed a consistent, easy-to-maintain layout without using VBA. Your requirement is exactly that, improving usability without breaking what already works. I can redesign your Dashboard tab and “2025” sheet to make KPIs instantly readable, scalable for multiple colleges, and aligned with a clean Microsoft-style layout, all within native Excel. Let’s keep this simple, I can share a quick mockup idea first so you can see the direction before we finalize. Let’s open a chat and get this moving. Jenifer
₹25,000 INR in 7 days
5.6
5.6

Hello, I’d love to help transform your existing Erasmus+ Excel dashboard into a more professional, intuitive, and user-friendly reporting tool. With strong expertise in advanced Excel dashboard design connecting to SharePoint and transform data into power query, KPI reporting, and usability optimization, I can enhance the layout, visual hierarchy, and overall user experience while keeping all your existing data, formulas, and calculations fully intact and maintainable in native Excel. I understand this workbook is used daily by International Office staff across multiple colleges, so my focus will be on creating a clean, polished, and highly functional interface that makes KPI monitoring faster and easier. What I will deliver: * Modern, professional dashboard redesign * Clear KPI cards for planned vs. registered values * Improved visual hierarchy for faster decision-making * Better charts, conditional formatting, and layout flow * Easy navigation and filter usability * Stable and fully editable native Excel structure I have hands-on experience building performance dashboards and management reporting tools in Excel, and I know how to balance strong visuals with long-term maintainability. I’m confident I can help elevate this dashboard into a more impactful and user-friendly solution for your team. Looking forward to working with you. Best regards, Shivani
₹25,000 INR in 7 days
4.7
4.7

I can redesign your Excel dashboard into a clean, structured, and highly usable interface while keeping all calculations intact and fully maintainable. The focus will be on creating a clear KPI-driven dashboard with strong visual hierarchy, scalable layout for multiple locations, and a design aligned with Microsoft Fluent principles. The underlying “2025” sheet will also be reorganized to improve readability and long-term maintainability without rebuilding your logic. Why I’m a strong fit: Experience building KPI dashboards and structured reporting systems in Excel Strong focus on clarity, usability, and scalable design Comfortable working within native Excel constraints (no VBA) A few quick questions: Should users filter by location or view all locations at once? Do you have brand guidelines (colors, logo format)? Any preferred KPI additions beyond the six listed? The goal is to deliver a dashboard that is intuitive for daily use and easy to maintain across different colleges.
₹20,000 INR in 7 days
3.7
3.7

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
₹15,000 INR in 7 days
2.7
2.7

As a freelancer with substantial experience in both graphic design and technical development, I believe I am the perfect candidate to tackle your project. My expertise in Excel, combined with my design proficiency and eye for detail, enables me to deliver work that is not only visually appealing but reliable and scalable as well. Moreover, during our collaboration you can be assured of staying within tech constraints whilst also ensuring a maintainable product. Having worked with numerous clients over the years who needed a mix of creative yet organize work that non-technical personnel could manage, I've gained immense experience in simplifying complex processes while retaining their robustness. All in all, hiring me for this project means gaining the dual advantage of a design-forward approach fused with a solid foundation in Excel functionalities. Get ready to reimagine your Erasmus administration using an enhanced dashboard that not only meets but exceeds your needs for clarity, customizability, and scalability!
₹12,500 INR in 7 days
0.0
0.0

I am pleased to submit my proposal for the redesign of your Erasmus+ Monitoring Dashboard. I understand that for vocational colleges, this tool is not just a spreadsheet—it is a critical instrument for ensuring that European funding is utilized effectively and inclusively. My approach focuses on three core pillars: Professionalism, Portability, and Precision. Professionalism (Fluent Design): I will move away from the "grid-heavy" look of traditional Excel. By using white space, high-quality typography (Segoe UI), and a card-based layout. Portability (Zero Macros): Recognizing the strict IT security environments of educational institutions, my solution relies entirely on native Excel features. I use Power Query for data connection and Pivot-Logic for the dashboard, ensuring the file remains fast, secure, and compatible. Precision (Scalability): The system is built to grow. Whether a college manages 4 locations or 15, the "Location Load" charts and tables will adapt automatically. By centralizing branding elements (Logos and Colors), I ensure that the tool remains a cohesive part of each college’s identity. I have included an additional KPI—Budget Burn Rate—which provides a predictive look at whether a college is on track to spend its allocation by the end of the term, a key requirement for Erasmus+ compliance. I am ready to transform your current workbook into a world-class administrative tool.
₹30,000 INR in 7 days
0.0
0.0

Your brief is impressively detailed — the 6 KPIs, Fluent Design preference, variable college locations, and the no-VBA constraint together paint a very clear picture. I'd structure this with a clean Dashboard tab using dynamic named ranges and structured tables so adding locations requires zero formula edits. I've built similar multi-entity Excel dashboards before and can deliver mockup images first for your sign-off before touching the final file. Let's connect.
₹18,000 INR in 5 days
0.0
0.0

Hello, This is exactly the type of Excel project I specialize in. I can redesign your dashboard to make it clearer, more structured, and visually aligned with a modern Microsoft Fluent-style layout, while keeping everything fully maintainable in native Excel (no VBA). My approach will focus on: * Clean KPI presentation with strong visual hierarchy * Easy-to-read layouts for International Office staff * Scalable structure that adapts to multiple college locations * Consistent formatting and intuitive navigation * Maintaining and improving your existing data model without breaking current logic I will also provide a clear and customizable design so each college can easily adapt colors and branding. I can prepare a dashboard mockup preview (as requested) to demonstrate the design before final delivery. Looking forward to working with you.
₹25,000 INR in 7 days
0.0
0.0

Delhi, India
Member since Mar 29, 2020
$250-750 CAD
$30-250 USD
$8-15 USD / hour
₹750-1250 INR / hour
$30-250 SGD
₹12500-37500 INR
$10-30 USD
$250-750 USD
₹750-1250 INR / hour
₹400-750 INR / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
$80-240 HKD
€30-250 EUR
₹600-1500 INR
min £36 GBP / hour
₹12500-37500 INR
$30-250 USD
₹750-1250 INR / hour
min $50 AUD / hour