Excel specialist
- or -
Post a project like this2394
$$
- Posted:
- Proposals: 21
- Remote
- #1713972
- Awarded
Consultant: Accounts, Taxation, Audit, Investment, Data Eentry, PDF Conversion, Financial Service and Other Service
Agra
18044831794814185737018620591858178185437518440901458031168601018319281837247768831
Description
Experience Level: Intermediate
General information for the business: We sell customised vans, Mainly Ford Transit Customs http://transitgt.com/
Description of excel work: http://transitgt.com/ Create a dashboard on a spreadsheet that allows us at a quick glance to monitor stock levels, types of stock, age of current stock as well as value of total stock which will need to be broken down on a monthly basis. We currently use a Ford excel spreadsheet that uses the excel filtering systems which works well. Also if it could generate stock numbers this would be great - Ideally we'd like a form on the front for easy data entry - It just needs to be short, simple and concise.
W would like to develop this in the future to create orders and proforma invoices using specific vehicles on the stock list, Ideally it would generate an online "T Card" system which would help us to progress the vehicle order through our workshops and body shop as well as the customer delivery process. If you can suggest a software package for these needs that you could customize to suit ourselves we would be greatly interested in considering this option, However our immediate need is for a functioning stock list with reports. I've attached an example below.
Design and target audience: No customer audience, just some salesman
Extra notes: Easy to use,
I need to upload it to one drive once its done to make it a live document so several people can access and edit it at the same time!
Description of excel work: http://transitgt.com/ Create a dashboard on a spreadsheet that allows us at a quick glance to monitor stock levels, types of stock, age of current stock as well as value of total stock which will need to be broken down on a monthly basis. We currently use a Ford excel spreadsheet that uses the excel filtering systems which works well. Also if it could generate stock numbers this would be great - Ideally we'd like a form on the front for easy data entry - It just needs to be short, simple and concise.
W would like to develop this in the future to create orders and proforma invoices using specific vehicles on the stock list, Ideally it would generate an online "T Card" system which would help us to progress the vehicle order through our workshops and body shop as well as the customer delivery process. If you can suggest a software package for these needs that you could customize to suit ourselves we would be greatly interested in considering this option, However our immediate need is for a functioning stock list with reports. I've attached an example below.
Design and target audience: No customer audience, just some salesman
Extra notes: Easy to use,
I need to upload it to one drive once its done to make it a live document so several people can access and edit it at the same time!
Sam A.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
16 Oct 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Do you have a current "quotation" form as used by your salesmen?
502666
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies