Find Jobs
Hire Freelancers

A Custom formatted Excel Spreadsheet

$250-750 USD

Closed
Posted over 8 years ago

$250-750 USD

Paid on delivery
I want a custom spreadsheet formatted for my commission based sales agency. It will help me track an order through the entire process...Purchase Order, Sales Order (or Acknowledgement) and then an Invoice. Then I want to track that invoice until it ships, and I am paid commission from the respective factory. I want to input information in one sheet and have it duplicated on additional sheets, sorted by the column of "Factory". I have 18 Factories I work with. This is possible? I already have the information in separate Excel spreadsheets, and there is a lot of duplication. My current system is a time consuming and ineffective method.
Project ID: 9342510

About the project

36 proposals
Remote project
Active 8 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
36 freelancers are bidding on average $435 USD for this job
User Avatar
A proposal has not yet been provided
$250 USD in 3 days
4.9 (251 reviews)
7.6
7.6
User Avatar
Hello there, I am an expert in creating Excel based automated dashboards and calculation templates. I have showcased some of my works in my profile and have done several other professional quality dashboards for clients across the globe. As you would see in my work history, the clients I work with are very happy with my work and have been associated with me for multiple projects. The kind of calculator you are looking for can be built in several ways and may have different layouts. To be able to provide a suitable cost and also to suggest some options, I would need more detailed requirements. Can you share the existing data file with some dummy data? Also, any information related the metrics that need to be calculated and any preferred layouts that you may have would be helpful. I will then create the different sheets PO, SO, Invoice and Commission etc. As each project moves in various stages, you would simply have to change a 'status' flag and all these sheets would be updated automatically. There would be no duplication of data. Does this sound interesting enough to explore more? Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to working with you and thank you for considering my bid. Regards, Rishi
$277 USD in 5 days
4.8 (96 reviews)
6.3
6.3
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 55 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$251 USD in 5 days
4.8 (72 reviews)
5.8
5.8
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the project.
$250 USD in 5 days
4.8 (71 reviews)
5.5
5.5
User Avatar
I am experienced with Excel and can make different adjustments and templates for data entry including forms and also modules like macros. Also integration with other MS Office programs is possible if requested.
$750 USD in 10 days
5.0 (8 reviews)
5.5
5.5
User Avatar
A proposal has not yet been provided
$250 USD in 5 days
4.6 (65 reviews)
5.3
5.3
User Avatar
Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, data processing. I can design and develop excel, ms access applications in quick time ensuring the final output is as per the precise requirement. Over 8 yrs I've worked in VBA technology and so I am accustomed to working with all sorts of excel, access related development. You can be sure that I will use my best skills to ensure the successful completion of the project. I highly value professionalism and hold myself strictly accountable to represent client's profile. I aim to form a long term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Vinay
$250 USD in 4 days
4.7 (9 reviews)
4.1
4.1
User Avatar
I an very good in excel and do proper data process... without data duplication... I can do this very well..
$277 USD in 2 days
5.0 (1 review)
0.8
0.8
User Avatar
We have read your project Requirements and are keen on working on your Project We have in depth knowledge of working in Photoshop Adobe Acrobat Flash Illustrator Corel Draw Dreamweaver Power point and Indesign We assure you that we will execute the work as per your specifications We will be grateful to you if you could give us the opportunity to work with you on this project Regards, Sudha
$250 USD in 3 days
3.2 (1 review)
0.6
0.6
User Avatar
A proposal has not yet been provided
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is definitely possible and will save you lots of time. I am able to format your spreadsheet, build tables and tracking formulas to produce the final product you are desiring
$250 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am new here so I do not have any reviews or references which can be used as a proof of my quality of work. I would request you to give an opportunity so that I can do the work and hopefully with your good review I can get more work here. I am fully qualified for the job and I am good at Excel. Thanks
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am well aware of all features of MS Office tools and techniques. I have delivered bulks of Excel and Word documents in my prior companies. I would also like bring to your notice that I am good at typing and my documents are 100% error free. I have went through your requirement, and I can help you build a proper mapping database. Regards!
$333 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am already working in multiple excel sheets on a daily basis which are linked to each other. I have created these files myself and I am sure I can complete your task within the timeline efficiently.
$833 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive experience working with Excel. high-speed printing. Attentive and careful in their work.
$250 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$444 USD in 9 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a lot of experience in custom formatting including formatting documents for legal proceedings and for management information reporting.
$333 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Free of cost please consider Dear Sir, I am experienced professional just join freelancer platform because of urgent need but still trying to get my 1st job which I couldn't find yet may be because I haven't any good remarks posted on my profile by any employer for this purpose I would love to offer my services for free of cost I would be really thankful if you provide me a chance to deliver regard Faraz Yaqoob
$250 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of EGYPT
Egypt
0.0
0
Member since Jan 15, 2016

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.