
Cancelled
Posted
Paid on delivery
I am looking for an experienced Excel developer to create a project management workbook that allows me to manage multiple projects in a single sheet and have a dashboard sheet to track all projects in one place. Requirements: Ability to track: • Project name & ID • Tasks & subtasks • Timeline (start date, end date, and duration) • Task status (e.g., Pending, In Progress, Completed) • Costing & revenue • Progress percentage per task and per project Dashboard: • Summary of all projects in a single sheet Graphs/charts for progress, cost vs revenue, and timelines • Automatic updates from the project data sheet • Clean, professional, and user-friendly design • Preferably automated with formulas, pivot tables, and/or macros where needed Deliverables: Excel workbook with: 1. Project Sheet – for entering and updating multiple projects with all required details 2. Dashboard Sheet – for a visual overview of all projects at once Instructions on how to update and maintain the sheet Skills Required: • Advanced Excel (formulas, charts, pivot tables, conditional formatting) • Experience with project management templates • VBA/Macro knowledge is a plus
Project ID: 39698794
17 proposals
Remote project
Active 11 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average $128 USD for this job

Greetings! I'm an expert in building powerful, automated Excel workbooks for project management—transforming complex data into clear, actionable dashboards. With over 9 years of experience in Advanced Excel, VBA, and data visualization, I’ll create a dynamic workbook that tracks every detail (tasks, timelines, costs, progress) and presents it all in a sleek, user-friendly dashboard with auto-updating charts and pivot tables. Here's how I can help: - Design a centralized Project Sheet for easy data entry and updates - Build a dynamic Dashboard with visual progress tracking, cost vs. revenue graphs, and timeline charts - Automate calculations and status updates using formulas, pivot tables, and macros - Provide clear instructions for seamless maintenance and scalability Your workbook will save you time and give you real-time insights at a glance. Would you like the dashboard to include any specific KPIs or custom visualizations? Also, do you prefer a fully macro-driven solution or a mix of formulas and VBA?
$250 USD in 5 days
7.2
7.2

Hello sir, I am a PHD degree holder in project management and a master degree holder in computer science. I have read project description and i am sure i can deliver excellent paper, since i have more than 5 years of experience in research , report and technical writing. I do provide FREE Turnitin reports in both AI and plagiarism prove. Kindly contact me and we work together and you will never regret.I have written many task similar to this please consider me. Thank You
$140 USD in 3 days
7.2
7.2

Hello Aishath F., I have read the project details and understood the overall requirement. With 5 years of experience in Visual Basic, Data Processing, Project Management, Excel, Visual Basic for Apps, Excel VBA, Excel Macros, Data Visualization, Data Analysis, and Automation, I am confident in delivering a high-quality Advanced Excel Project Management Workbook for you. I will create a comprehensive Excel workbook with a Project Sheet for managing project details and a Dashboard Sheet for visualizing project summaries. The workbook will include features to track project names, tasks, timelines, statuses, costing, revenue, progress percentages, and more. The dashboard will have graphs/charts for progress, cost vs revenue, and timelines, all automatically updated from the project data sheet. You can view my portfolio here: https://www.freelancer.com/u/mannanmaan1425 Please ping me back so we can discuss the project further in the chat. Best regards, Abdul
$30 USD in 1 day
6.1
6.1

Hello, I am excited about the opportunity to create an advanced Excel project management workbook tailored to your needs. With my extensive experience in developing complex Excel solutions, I can design a comprehensive workbook that allows you to track multiple projects seamlessly. The workbook will include a dedicated project sheet for entering and updating project details such as project name, ID, tasks, timelines, and status. I will ensure that the dashboard provides a clean, professional overview, with automatic updates reflecting real-time data. Visualizations like graphs and charts will clearly show progress, cost vs. revenue, and timelines, making management easier and more efficient. With a focus on user-friendliness and automation using formulas, pivot tables, and macros, the final product will not only meet your requirements but exceed your expectations. I will also provide clear instructions for updating and maintaining the sheet, so you can manage your projects effortlessly. Thanks, Monicah
$130 USD in 3 days
5.2
5.2

With my comprehensive command over Excel and being an adept data professional for over 10 years, I offer you a refined understanding and strong skill set appropriate for your Advanced Excel Project Management Workbook. As a full-stack developer well-versed in generating efficient solutions, I've created various project management templates and tools that precisely navigate through complex project management scenarios. By incorporating formulas, pivot tables, conditional formatting, moreover potentially macros and VBA knowledge if so deserved, I'll craft a clean yet professional and user-friendly design Excel workbook that accurately tracks your various projects, their timelines, task statuses along with their respective costs and revenues. Cognizant of the need to efficiently present copious data at once, the Dashboard Sheet I create would offer a summary of all projects compiled in one place with graphs/charts detailing progress, cost vs. revenue analyses and timelines. I emphasize on automating updates from the project data sheet to reduce manual intervention ensuring efficiency and accuracy throughout this process. By guiding you on how to easily update and maintain the sheet, I ensure you smoothly transition into using the workbook delving into its powerful functionalities.
$50 USD in 3 days
3.1
3.1

I take great pleasure in writing this pitch as I've seen and solved similar problems in my vast career working with Excel and managing projects. Entrusting me with your "Advanced Excel Project Management Workbook" task is guaranteeing yourself a thoroughbred professional who understands the essence of detail, efficiency, and accuracy. My portfolio undeniably speaks to skills in advanced Excel that you need for this project as seen in areas such as formulas, charts, pivot tables, automation with VBA/Macro. My toolkit is supplemented by having incredible hands-on experience in project management. This means that your deliverables will be tailored to meet your specific project management needs. Understanding that every detail counts and time is an essential factor in business, I can ensure an intelligent layout of your data in a way where all required details will be inputted effectively and visible for quick analysis. Additionally, automated components such as data entry forms, alerts, graphical representation are easily implementable by me so that users like yourself find the workbook easy to use and maintain. In conclusion, my proficiency using Excel doesn't just stop at creating intelligible worksheets; it extends to integrating complex functionalities that can save you time while improving precision. My written style may seem more down-to-earth than some but behind those words are deep-rooted passion, extensive knowledge base
$100 USD in 3 days
2.8
2.8

Hi, I am an experienced Excel developer with expertise in advanced Excel functions, charts, pivot tables, and conditional formatting. I have a strong background in creating project management templates and automating processes using VBA. I have read the project requirements and can deliver a professional and user-friendly project management workbook with a detailed project sheet and interactive dashboard. I will ensure automatic updates from the project data sheet and provide clear instructions for maintenance. Let's discuss further to tailor the workbook to your specific needs. Looking forward to collaborating on this project. Thanks, Emile
$30 USD in 7 days
0.0
0.0

I am a perfect fit for your project, specializing in creating clean, professional, user-friendly Excel workbooks for project management. I will ensure your workbook is seamless, integrated, and automated, meeting all your requirements. While I am new to freelancer, I have tons of experience in creating similar projects off-site. I provide expertise in advanced Excel, project management templates, and VBA/macros to enhance functionality. I would love to chat more about your project! Regards, Virgil Bent
$200 USD in 14 days
0.0
0.0

"You’ve just found the right match for your project — here’s why:" I understand your need for a clean, professional, and user-friendly Excel project management workbook with a seamless dashboard. I specialize in advanced Excel functions, project management templates, and VBA automation. I may be new here, but I have a proven track record working with clients outside Freelancer.com — I’m ready to earn your trust, too. Happy to discuss this further when you’re ready. Regards, Ahmed
$150 USD in 30 days
0.0
0.0

Hi there, How u doing? I have came across ur project and i believe i can help u with it as i have great working experience in Data Analysis, Data Visualization, Excel Macros, Excel, Project Management, Visual Basic, Visual Basic for Apps, Excel VBA, Automation and Data Processing. Please have a look at my portfolio to see reviews and more: https://www.freelancer.com/u/ayesha0124 I am available 9am-9pm EST. Regards,
$250 USD in 7 days
0.0
0.0

I am a perfect fit for your project, seeking an experienced Excel developer to build a project management workbook. Proficient in Advanced Excel, I excel in creating clean, professional, and user-friendly designs enhanced by formulas, pivot tables, and macros for seamless automation. While I am new to Freelancer, my expertise shines through years of off-site project experience. Let's collaborate to craft a dynamic Excel workbook featuring a Project Sheet and Dashboard Sheet, marrying functionality with aesthetics. I would love to chat more about your project! Regards, Leonard Boucher
$150 USD in 14 days
0.0
0.0

This sounds like something I can absolutely deliver ? Clean, professional, and user-friendly Excel project management workbook creation is my specialty. I create systems with smart design and integrated automation for seamless project tracking. While new to Freelancer, I've successfully completed similar projects off-site with satisfied clients and tangible results. I'd love to collaborate with you on this project, PhaXu. Let's discuss how I can create a tailored Excel workbook that meets all your requirements and exceeds your expectations. Looking forward to chatting more about your project! Regards, Jarrod
$150 USD in 14 days
0.0
0.0

?YOU PAY WHEN YOU ARE HAPPY WITH THE WORK ? I am a person for your project, I will work with you until you are 100% satisfied. Your need for a clean, professional, user-friendly, Excel project management workbook with integrated dashboard aligns perfectly with my expertise. While I am new to Freelancer, I have tons of experience with project management templates and advanced Excel skills, including VBA knowledge. I would love to chat more about your project! The worst that can happen is you walk away with a free consultation. Regards, Brandon Booth
$150 USD in 14 days
0.0
0.0

Ra Rasgetheemu E-03, Maldives
Payment method verified
Member since Jun 9, 2025
$30-250 USD
$2-8 USD / hour
$2-8 USD / hour
₹600-1500 INR
₹1500-12500 INR
$100-125 USD
₹750-1250 INR / hour
$250-750 USD
₹12500-37500 INR
₹100-400 INR / hour
₹600-1500 INR
$10-50 USD
$15-25 USD / hour
$250-750 USD
₹12500-37500 INR
₹1500-2000 INR
₹1500-12500 INR
₹12500-37500 INR
$15-25 CAD / hour
₹12500-37500 INR
$250-750 USD
₹600-1500 INR
₹600-1500 INR