Find Jobs
Hire Freelancers

Excel Expert

$250-750 AUD

Completed
Posted over 6 years ago

$250-750 AUD

Paid on delivery
I manage a building business and have developed an excel based job costing workbook with multiple spreadsheets. Each spreadsheet represents a job and all spreadsheets are referenced to a summary spreadsheet to sum up all jobs in progress including payments received. I would like to automate the workbook so that i can automatically add new spreadsheets and the formulas will automatically update in the summary spreadsheet. I would also like to add buttons so that I can add new rows and colums without comprising the integrity of the spreadsheet. The summary spreadsheet also sets out the labour and overhead rates that need to populate every new spreadsheet. Each spreadsheet needs to generate a pie or bar graph that illustrates job progress and actuals vs. budget.
Project ID: 15629585

About the project

28 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

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
Awarded to:
User Avatar
Hi, I am good at Excel and vba. I have seen the description. I can consolidate several sheets into Summary sheet with a button click. Please share the file with existing status. -Chandra Relevant Skills and Experience Excel vba, Data anlaysis Proposed Milestones $400 AUD - Milestone I would like to know the graphs that each worksheet contains. So, i can try automating them, based on the feasibility.
$400 AUD in 3 days
5.0 (847 reviews)
7.9
7.9
28 freelancers are bidding on average $438 AUD for this job
User Avatar
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Proposed Milestones $550 AUD - Please pay me once the job is 100% complete Please initiate a chat before award as I have few queries to confirm so that I can ensure its doable
$550 AUD in 5 days
5.0 (709 reviews)
8.5
8.5
User Avatar
Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with excellent knowledge in Excel. please give me a chance to work on your project Proposed Milestones $400 AUD - Excel Job
$400 AUD in 5 days
4.9 (300 reviews)
7.8
7.8
User Avatar
Hello. I am Paris. I read your brief and I am confident I can develop the necessary code to automate the processes you refer to when adding more sheets. Relevant Skills and Experience I am a well-respected developer here on this site as you can check for yourself. Proposed Milestones $150 AUD - Deliver a draft version $250 AUD - once you are happy with the final version
$400 AUD in 7 days
4.9 (204 reviews)
7.3
7.3
User Avatar
I am a guru in Excel, and I have experience in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's, charts and more. Relevant Skills and Experience I served as CFO, Controller, and Chief Accountant at global parent companies. I have extensive experience in accounting, consolidating, forecasting, budgeting, and costing, reports. Proposed Milestones $347 AUD - At the delivery of the first version $347 AUD - At the completion of the project I did similar projects, and I can show you samples.
$694 AUD in 10 days
4.9 (81 reviews)
7.0
7.0
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia relevante VBA/Models Htos propuestos $500 AUD - final delivery
$500 AUD in 10 days
4.9 (220 reviews)
6.9
6.9
User Avatar
We can do a very nice job of this using EXCEL. However, a MUCH better application can be made employing ACCESS. Please contact us to learn more. Confidentiality guaranteed. Relevant Skills and Experience Highly experienced (25+years) EXCEL/ACCESS Programming Expert. Strong Data, Reporting, and User Interface skills. Strong Accounting, COSTING, Inventory, and Payroll+Time application knowledge. Proposed Milestones $255 AUD - Down Payment $300 AUD - Upon Completion For best results, please contact us via chat before awarding. Respectfully, Carol+Bill.
$555 AUD in 10 days
4.9 (29 reviews)
6.0
6.0
User Avatar
Hello Sir ! I have worked on creating automated excel software and dashboards. I can complete your project effectively and efficiently in a timely manner. Relevant Skills and Experience Excel Proposed Milestones $750 AUD - final
$750 AUD in 10 days
4.8 (50 reviews)
5.8
5.8
User Avatar
- Have done similar costing of construction site with the budgeted and carry over for each task in project. - Have very good Excel automation skills Relevant Skills and Experience - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., Proposed Milestones $300 AUD - Day5 - Costing, summary and graphs for construction Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio. - University, US - Scoring the answer sheets based on keyword and number of occurences.
$300 AUD in 5 days
4.7 (48 reviews)
6.0
6.0
User Avatar
Hi, I went through the description. This job is quiet similar to my recent projects and my experience. Today can start to do this. I am looking forward to hearing from you On time delivery is guaranteed. Open for Discussion, negotiation. After service. 24X7 online, Replies within 1 hour. Thanks Regards Thushara
$555 AUD in 30 days
5.0 (25 reviews)
4.3
4.3
User Avatar
Hello. I'm interested in your work. I have a lot of experience working with a variety of documents. Also, I worked as a content manager and IT project manager. I hope that you will answer me and we will be able to discuss all the details of the assignment.
$342 AUD in 15 days
5.0 (5 reviews)
3.1
3.1
User Avatar
Hello, Could you please provide a sample of your workbook for accurate information? Then we can discuss your requirements on solid basis and I can give you an accurate price. I'm basically an Industrial engineer with 15 years experience in Production scheduling and business cases evaluation using Excel.
$500 AUD in 10 days
5.0 (3 reviews)
2.3
2.3
User Avatar
I have extensive experience working on projects that require excel VBA skills. I'm keen on quality and delivering the project well advance in time.
$250 AUD in 10 days
5.0 (2 reviews)
2.4
2.4
User Avatar
As a specialist in Data entry,Powerpoint, PDF Conversion, Excel Works, searching the web for emails, phone numbers, address, contact person ... Relevant Skills and Experience Web Development, Internet research, domain name creation etc the multitude of services I provide my clients truly knows no bounds. Data Entry,web research,Excel ,internet search,scraping,PDF Proposed Milestones $250 AUD - Excel
$250 AUD in 10 days
5.0 (1 review)
1.8
1.8
User Avatar
I am a professional building services engineer with capability of provide a solution for the mentioned task. Relevant Skills and Experience Excel, Mechanical Engineering Proposed Milestones $277 AUD - Negotiable
$277 AUD in 2 days
4.7 (3 reviews)
1.5
1.5
User Avatar
Very experienced working with Microsoft Excel, developing macros to achieve tasks using VBA and also financial analysis. I have 2+ years on the job experience where these skills have been utilized. Relevant Skills and Experience - Microsoft Excel - Visual Basic (Applications) - Data and finance analysis - Report generation Proposed Milestones $555 AUD - Completion of project To ensure I don't waste your time, I would like to view your spreadsheet before accepting this project.
$555 AUD in 7 days
5.0 (1 review)
1.2
1.2
User Avatar
This tool is a simple VBA task yet requires 3 days (including Your reviews of layout etc). For real time results and to balance performance, different update technics should be used. Odpowiednie Umiejętności i Doświadczenie Over 3 ears exp with Excel, VBA and Access for reporting as a consultant to sales teams and analyst building corporate solutions. I create reports and tools (like forms) to collect and visualise data. Zaproponowane płatności Milestone $150 AUD - creating layout for all sheets (major, dictionaries, 'per job' sheets) plus relations between them $100 AUD - macros for updating all sheets, pivots etc Zaoferowane Dodatkowe Usługi $10 AUD - export to pdf and csv if needed $10 AUD - import data from csv, or xls, xlsb templates Milestones are not obligatory, we can agree on payment for the whole job. Reviews and error fixing after 3 days time are for free. Would be great to receive simpe layout overwiev of what You'd like the tool to look like.
$250 AUD in 3 days
5.0 (1 review)
0.7
0.7
User Avatar
I am having excel and costing both expertise desired for this job. Relevant Skills and Experience Excel Proposed Milestones $750 AUD - My Offer Stay tuned, I'm still working on this proposal.
$750 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I believe that I'm The best for this job because I l'm Civil Engineer where your program will be related with civil engineer topics and I'm Expert in Excel and you will be satisfy from my work. Relevant Skills and Experience I'm fit for this job as I have qualification and experience in addition to Intellectual Proficiency to deal with Excel . I hope to take my chance to provide you with my best efforts in this job . Proposed Milestones $250 AUD - Civil Engineer and Excel Expert
$250 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I think its best to move your process to an Access database. This way you can add and remove spreadsheets from a gui control and create reports and invoices through Access. Relevant Skills and Experience excel, access, database, macro, visual basic Proposed Milestones $250 AUD - Delivery
$250 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm an expert level excel programmer who does living on excel programming at Corporate level. I can assist you with your project. Thanks. Relevant Skills and Experience Excel, VBA, Macro, Programming Proposed Milestones $500 AUD - Excel Macro sheet and Explanation of how to use the sheet Please assign the work. Thanks.
$500 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
4
Payment method verified
Member since Nov 13, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.