
Closed
Posted
Paid on delivery
I need a set of interactive dashboards built in Microsoft Excel that will let my team monitor projects at a glance. The focus is squarely on project management, so the workbook must pull together: • Task completion status • Team performance metrics • Resource allocation These dashboards will be used day-to-day by team members rather than executives, which means the layout has to be intuitive, fast to update, and locked against accidental formula changes. I picture slicers, dynamic charts, conditional formatting, perhaps a progress-bar style visual for tasks—whatever gives an immediate sense of where we stand without asking anyone to hunt for numbers. Source data will come from the worksheets we already maintain; your job is to cleanly connect them, automate refresh where possible, and package everything in a single, well-documented file. Whenever feasible, please avoid VBA macros—simple formulas, Power Query, and Pivot Tables are preferred for ease of maintenance—but I’m open to lightweight VBA if it significantly improves user experience. Deliverables: 1. One Excel workbook containing all interactive dashboards, ready for use. 2. A brief how-to sheet so new team members understand how to refresh data and add future projects. I’ll provide sample data as soon as we start. Let me know your timeline and any clarifications you need to get moving.
Project ID: 40389750
16 proposals
Remote project
Active 6 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
16 freelancers are bidding on average ₹5,719 INR for this job

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
₹4,000 INR in 1 day
5.1
5.1

Hello, I can build a clean, user-friendly Excel dashboard that gives your team real-time visibility into project status, performance, and resource allocation. What I’ll deliver: Interactive dashboards with slicers, dynamic charts, and progress indicators Clear tracking of task completion, team performance, and resource usage Structured backend using Power Query + Pivot Tables (minimal/no VBA) Locked formulas to prevent accidental changes, while keeping inputs simple Extras: Fast refresh setup for ongoing use Well-organized workbook with a short “how-to” guide for your team My focus is on simplicity, speed, and clarity—so anyone on your team can use it daily without confusion. Best regards, Shivam
₹7,000 INR in 7 days
5.9
5.9

Powerful data insights, clear communication, and efficient project management are what I bring to the table for your interactive Project Dashboards in Excel. With 8+ years of experience as a Data Analyst & Scientist, I have a knack for presenting complex datasets in user-friendly formats that drive decision-making. My skills in Power BI, Tableau, Looker, Google Data Studio, Plotly/Dash) would help me leverage Excel's native functionalities like simple formulas, Power Query and Pivot Tables to create the intuitive yet robust dashboards you seek. What sets me apart is my proficiency with R, Python (Pandas, NumPy, Scikit-learn among others), not to mention Jupyter Notebooks and Google Colab - ensuring that I can effectively deal with any data-related complexity or modeling that may emerge while handling your tasks completion status, team performance metrics, and resource allocation data. Having worked across diverse industries like finance, healthcare, e-commerce & SaaS gives me a unique perspective and makes me versatile in tailoring solutions specific to your needs. As an experienced data specialist; ETL with Apache Airflow and Talend/Alteryx as well as database with SQL (MySQL, PostgreSQL, MS-SQL), MongoDB; using these technologies I can smoothly handle your source data worksheets to ensure easy connection & automate refresh for ongoing efficiency.
₹7,000 INR in 7 days
3.8
3.8

Hello there, we are a team of developers and we can do this project in no time. Thanks Ashish Kumar.
₹7,000 INR in 7 days
3.5
3.5

With expertise combining accounting and data analytics, I bring not only technical competence but also an eye for the bigger picture. My specialties in financial management, bookkeeping, and invoicing have endowed me with a love for precision and efficiency— vital qualities for project dashboards that your team can truly depend on. My approach is all about clarity and strategy. I want your interactive dashboards to be an immediate source of comprehension for your team. Understanding the unique nature of this task, I will ensure that formulas are locked against accidental changes while employing simple formulas, Power Query, and Pivot Tables instead of VBA macros where possible- this ensures an easily maintainable system that doesn't require extensive coding knowledge. My goal is to provide you with everything you need – a single, well-documented file containing all dashboards along with a how-to sheet- enabling easy data refreshment even after project completion. I'm confident that my methodical nature will serve you well in structuring the source data from various worksheets efficiently and creating thoroughly-connected dashboards. In choosing me, you can rest assured known that not only will your projects be monitored at a glance by every team member through intuitive layouts and dynamic charts, but also that the fresh perspective I bring from expanding into digital analytics will uncover trends and opportunities to further improve your project management processes.
₹7,000 INR in 3 days
3.4
3.4

@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.
₹7,000 INR in 7 days
2.8
2.8

Hi, I can build a clean and fully interactive Excel dashboard tailored for your project management needs. I have experience creating dashboards using Power Query, Pivot Tables, slicers, and dynamic visuals that make tracking tasks, team performance, and resource allocation simple and intuitive. I’ll structure your existing data for smooth integration and ensure the dashboard is fast, user-friendly, and protected against accidental changes. The workbook will include clear visuals like progress indicators, KPIs, and filters for quick insights. I’ll also provide a short guide so your team can easily refresh data and add new projects. I focus on creating scalable and easy-to-maintain solutions without heavy VBA. I can deliver this within 4–6 days once I review your sample data. Let’s discuss your data structure and get started.
₹5,000 INR in 7 days
2.0
2.0

Hi, You need Excel dashboards that actually help your team *work faster day-to-day*—not just look good. That means clarity, zero confusion, and no risk of breaking formulas. I’ll build a clean, interactive Excel system that connects your existing sheets into a single dashboard layer using **Pivot Tables, Power Query, and dynamic formulas (no heavy VBA)**. The focus will be real-time visibility of tasks, team performance, and resource allocation in a way your team can instantly understand. What I’ll deliver: • Task tracking dashboard with progress bars, status indicators, and filters • Team performance view (workload, completion rates, bottlenecks) • Resource allocation tracker (who’s doing what, and capacity view) • Slicers + dynamic charts for quick filtering without touching data • Fully locked structure (users can’t break formulas) • Clean data flow using Power Query for easy refresh Everything will be optimized for speed, usability, and daily usage—not just reporting. Quick question: is your current data already structured (tables with consistent columns), or will it need cleanup before building the dashboards? Thanks and regards, Sagar Lohni
₹1,500 INR in 7 days
1.4
1.4

Hi there, I am Syed Taha Hussain, and I would love to build these project management dashboards for your team. Data visualisation and automated Excel reporting are my primary skills. I specialise in using Power Query and Pivot Tables to create fast, user friendly tools that eliminate manual data hunting. I will build an intuitive interface featuring task progress bars, team metrics, and resource allocation views. Using Power Query, I’ll ensure your data connects seamlessly without complex macros, keeping the file easy to maintain. I will also implement sheet protection to prevent accidental formula changes while keeping slicers fully interactive. I have several sophisticated project tracking dashboards in my portfolio on my profile. Please message me in the chat so I can share these as a reference and we can get started.
₹5,500 INR in 3 days
1.1
1.1

Hi, I’m very interested in supporting your monthly financial reporting and ensuring your numbers are accurate, consistent, and decision-ready. I have experience working with structured data, Excel reporting, and financial record organization. I can extract data from your accounting system, reconcile it with the ledger, and prepare clear, well-formatted Income Statements (P&L) and Cash Flow Statements. My approach: • Verify all figures against the ledger to ensure accuracy • Reconcile discrepancies and flag any inconsistencies • Prepare clean, structured reports in both Excel and PDF formats • Maintain consistency in format and calculations month-to-month • Provide a brief note highlighting unusual movements or trends I focus on accuracy, clarity, and reliability so you can confidently use the reports for decision-making. I’m available to start immediately and can commit to consistent monthly delivery. Best regards, Mitali
₹4,000 INR in 2 days
0.0
0.0

I can build an interactive Excel dashboard tailored for project management, using your existing data. My approach combines Pivot Tables, Power Query, slicers, dynamic charts, conditional formatting, and progress bars—for a user-friendly, intuitive layout. I'll connect your source data, automate updates, and ensure formulas are protected. I'll deliver a single well-documented workbook plus an easy how-to sheet for your team. I can start as soon as you provide sample data and clarify any preferences.
₹4,000 INR in 3 days
0.0
0.0

I can build an interactive Excel dashboard that gives a clear and quick overview of your project data. My approach would be: 1 Connect and structure your existing worksheets into a clean data model 2 Use Pivot Tables and Power Query to automate data processing and updates 3 Build interactive dashboards using slicers, dynamic charts, and conditional formatting 4 Include task status tracking, team performance metrics, and resource allocation views 5 Ensure the layout is simple, fast to update, and protected from accidental changes I will also add a short “how-to” sheet so your team can easily refresh data and extend the workbook in the future. My focus is to make the dashboard practical for daily use, not just visually appealing. I can deliver a working version quickly and refine it based on your feedback.
₹4,500 INR in 5 days
0.0
0.0

Hi, Saw your project: interactive Excel dashboards for team-level project monitoring, with slicers, dynamic charts, conditional formatting, and formula lock-down. Focused on task status, team metrics, resource allocation. This fits my toolkit. I will build one workbook with a source-data tab you paste into, a config tab for team and status lookups, and the dashboard tab driving off slicers. Progress-bar visuals for task completion using REPT formulas and conditional formatting. Formulas locked, input cells unlocked, so the team cannot accidentally break it. I will also include a short instructions tab so new team members can self-onboard. 48 hour turnaround with a draft mid-way. Turner
₹5,000 INR in 2 days
0.0
0.0

Hi, I’ve carefully reviewed your project requirements, and I can confidently help you build a clean, interactive, and user-friendly Excel dashboard tailored for project management. I will create a fully integrated workbook that brings together task completion tracking, team performance insights, and resource allocation in one place. The dashboards will be designed for daily use—intuitive, fast, and visually clear—so your team can instantly understand project status without digging into raw data. I focus on keeping solutions efficient and easy to maintain, avoiding heavy VBA unless absolutely necessary. I’m ready to start as soon as you share the sample data. Looking forward to working with you! Best regards, Sana
₹6,000 INR in 3 days
0.0
0.0

Mumbai, India
Member since Apr 22, 2026
$30-250 USD
$250-750 AUD
$10-50 USD
$250-750 USD
$2-8 USD / hour
$30-250 USD
₹1500-12500 INR
₹600-1000 INR
₹100-400 INR / hour
$10-60 USD
$250-750 USD
$250-750 USD
£5-10 GBP / hour
₹1500-12500 INR
$250-750 USD
₹750-1250 INR / hour
₹10000-15000 INR
$3000-5000 USD
$10-60 USD
$2-8 AUD / hour