MS Excel project cost monitoring

$250-750 USD

Closed

Posted

7 months ago

$250-750 USD

Paid on delivery

I am looking for a freelancer who can help me with an MS Excel project that involves cost monitoring for construction projects. I need someone with expertise in creating dynamic tables and statistical analysis function 'FORECAST' and the ability to develop charts and graphs for data visualization. Specific requirements for the project include: - Creating dynamic tables, specifically dynamic number of table COLUMN's based upon project duration - Utilizing statistical analysis functions in Excel, specifically FORECAST, using budget vs actual vs forecast costs - Creating charts and graphs to visually represent data - Implementing simple Excel functions for cost monitoring Ideal skills and experience for the job: - Proficiency in Excel, with a strong understanding of statistical analysis functions - Experience in data visualization, particularly creating charts and graphs - Familiarity with cost monitoring and using Excel functions for this purpose Please note that I do not require the project to be automated with macros or VBA. Simple Excel functions are sufficient for my needs. If you have any suggestions or advice on how to best approach this project, I would greatly appreciate your input. Thank you!

Project ID: 37283127

About the project

68 proposals

Remote project

Active 6 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

68 freelancers are bidding on average $439 USD for this job

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

$500 USD in 7 days

4.9

(577 reviews)

8.5

@liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..

$750 USD in 3 days

5.0

(29 reviews)

6.9

@daniyal3214

Hello, I am an experience Financial Analyst, Statistical and Excel expert holding years of experience in Financial Projection, Statistical Forecast and Data analytics I will be happy to discuss in detail how I am highly suitable for this.

$250 USD in 2 days

4.8

(230 reviews)

7.3

@writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 2 days

$320 USD in 1 day

4.9

(262 reviews)

6.8

@khurram1984

Hi. I am ranked among Top excel professionals with 750+ project awards and 500+ good reviews on freelancer. i am an affiliate chartered accountant (CPA) and a professional finance expert since 2009. We have worked with our clients at national as well as international level. We have advanced knowledge in excel because of extensive financial background, expertise and experience. We know how to prepare good dashboards, reports, templates which require minimum input from staff and must be automated. i am a professional business expert since 2009 and good understanding how to present information with attractive outlook. Kindly share your details of the project and insights of your requirements. We can address all your requirements with quality.

$400 USD in 5 days

4.8

(113 reviews)

7.2

@Giovanni704

Hi there! I have extensive experience in Excel, including creating dynamic tables, utilizing statistical analysis functions like FORECAST, and developing charts and graphs for data visualization. I understand your specific requirements and can help you effectively monitor costs for your construction projects using Excel's built-in functions without the need for macros or VBA. I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. Send me a message so I can show you my previous work and we can discuss more. Respectfully, Giovanni.

$250 USD in 1 day

4.9

(56 reviews)

6.9

@AAGGMM

Hi there I can help you creating your file I am a Google certified data analytic with a very strong skills in Excel include advanced formula, dynamic tables, power query and data visualization. If you are interested please feel free to contact me Regards Ahmed

$400 USD in 4 days

5.0

(113 reviews)

5.9

@mehmoodfaisal61

Hello, I hope you are doing well. I hold master degree in statistics from a renowned university. I am a seasoned statistician. I enjoy vast experience in performing statistical analysis and forecasting using Excel. I can help you with your project. Please contact me to discuss

$700 USD in 7 days

5.0

(33 reviews)

5.9

@arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun

$250 USD in 1 day

5.0

(29 reviews)

5.3

@merinsinha

Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.

$400 USD in 4 days

4.6

(159 reviews)

5.9

@techplusintl

Hi there, ★★★ Excel / VBA / Macros / Automation Expert ★★★ 5+ Years of Experience ★★★ I've read requirements and ready to build an MS Excel project that involves cost monitoring for construction projects.. I provide complete ranges of solution for your Excel, Custom Formulas / Functions, Pivot Table, Dashboards, VBA and Macros Automation need. I can also provide similar past Excel work example before being hired. Services we offer: ✔️ Custom Formulas ✔️ VBA Macros Automation ✔️ Vlookup / Hlookup ✔️ Countif / Countifs ✔️ Converting CSV files in to specific format. ✔️ Export & import of Excel files in to specific excel file ✔️ Visual Basic User Forms, for user interface designing and dashboards ✔️ Interactive Pivot Tables and Graphs. ✔️ Converting Excel to PDF or CSV ✔️ Complete Dynamic VBA Macros Dashboards ✔️ Removing Duplicates from the File ✔️ Data Entry with automated process As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team

$500 USD in 2 days

5.0

(8 reviews)

5.1

@haleem0786

I can do this. I have read your project detail and ready to work. Please review my profile and inbox me for detail. Thanks Abdul Haleem

$450 USD in 2 days

5.0

(38 reviews)

5.0

@Jatin77777

Hello, I went through the mentioned details and found that I can give you support to complete your task. I have knowledge of advanced excel functions, VBA, Slicers, Power Bi, Power pivot/Query, and best data visualization. I have more than 10 years of experience in reporting and data analysis. I have worked for Comcast and Dell. I have designed multiple Dashboards and macros to reduce human intervention. These dashboards and reports have dynamic views and functionality to present the data. Like checkboxes, radio buttons, drop-down lists and graphical data representations (Bar charts, pie charts & heat maps, Gantt chat, etc.). Please check my portfolio once for more information. Further, we will discuss this on chat. Thanks in advance for your valuable time. Thanks, Jitender kumar Reporting & Data Analytics

$500 USD in 2 days

5.0

(26 reviews)

4.7

@zafarfarooq612

Greetings, I am an Excel expert with a strong background in cost monitoring for construction projects, and I'm well-equipped to assist you. I will create dynamic tables tailored to your project's duration, employ the 'FORECAST' function for budget vs actual vs forecast cost analysis, and develop charts and graphs for intuitive data visualization. My proficiency in Excel, coupled with extensive experience in cost monitoring and data visualization, ensures that your project will be handled efficiently. I appreciate your preference for simple Excel functions, and I'm open to providing suggestions and advice to optimize your project. Thank you for considering my proposal, and I look forward to collaborating with you! Best regards, Zafar

$250 USD in 1 day

4.9

(31 reviews)

4.3

@MahmoudRafatAli

I understand you are looking for someone to help you with an MS Excel project that involves cost monitoring for construction projects. Specifically, I would like to discuss dynamic tables, statistical analysis functions such as FORECAST, using budget vs actual vs forecast costs to create charts and graphs to visually represent data. I have the skills necessary to complete this project. My expertise in creating dynamic tables and statistical analysis functions in Excel makes me well-suited for the job requirements. Additionally, I have experience in data visualization, particularly creating charts and graphs, which will be necessary for creating visual representations of data.

$250 USD in 1 day

5.0

(29 reviews)

3.9

@andrwojsz

Hi, Thank you for the detailed description. I have checked carefully the attachment and I would like to improve your file by using advanced formulas, tables and advanced formatting. The dynamic column I can create with formulas and if you want, the simple macro can hide unnecessary columns (or you can see them empty). Some sheets might need creating tables (to assign dynamic ranges) e.g. AFE scenarios. To recognize the columns for each UNLOC I can setup the INDEX and MATCH funtcions (it will allow to match the values for multiple locations). Of course I will apply the forecast for the metrics needed. Let's discuss the details in private message. I have more than 4 years experience as a data analyst. I worked for the financial companies and I'm familiar with this type of projects. I would really appreciate for the cooperation. Best Regards,

$350 USD in 6 days

5.0

(6 reviews)

3.6

@farazahmedmalik2

Hello, I’m a certified financial accountant and excel expert. I can help you with cost monitoring for construction projects. I’m skilled excel expert using dynamic tables and Statistical functions “Forecasts”, I won’t use VBA or anything just simple excel. Please inbox me the details.

$250 USD in 1 day

4.8

(5 reviews)

3.3

@bitswap

Hello, I can design for you the formulas you want in Excel so that you can easily calculate your profits and losses in the construction work. And I will design the desired graphs for you You have up to 5 free updates so that I can give you any changes you want after the end of the project Keep in mind that I am a programmer, on the other hand, I can create a web application for you in the future so that you can connect to it through iPhone, laptop, Android and all other devices and update your information and see the graph there. And there is no need Excel software We can chat more thanks

$250 USD in 2 days

5.0

(3 reviews)

2.0

@RANDHIR76

I am RANDHIR KUMAR faculty of mathematics for 11th. 12th. I.I.T Jee and also for degree level having 27 years experience I promise your assignments will complete within given time period with 100% client satisfaction I am also member of international mathematics contest USA feedback forum

$500 USD in 7 days

3.3

(5 reviews)

2.7

@AsimMunir77

Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 years. I have completed different project in excel using inbuilt as well as custom formulas. You can share your project details with me in chat. Regards

$500 USD in 7 days