I require someone with a knowledge of Excel
- or -
Post a project like this3352
$$
- Posted:
- Proposals: 12
- Remote
- #672757
- Awarded
Business Consultant, Website Design, Website Development, PHP, WordPress, Web App, Mobile App, Branding, Designer, Business Plans, Business Support, Presentation, Adviser, Analyst, Strategist, Advisor
City of London
VBA, Excel,Access,SQL Development,Intrgration & Automation,Database Desigh & Development,Reporting Services
Melbourne
55949063734208270498669510090579409601443643244846858848610
Description
Experience Level: Intermediate
Description of excel work: I am developing a data base from several hundred companies. I have the data and its format:
Task 1 - is to consolidate the data for each company into one line from 3 sources
Task 2 - is to create the ability to sort the data as required.
Extra notes: In the Example file attached, I started the process of developing one line of data per company. I only did 2 indicating the Company index.
I started doing the sums (everything is averages) vertically for the 3 above, and horizontally for each 3.
The full file contains about another 100 companies.
Task 1 - refers to creating the single lies of numeric format data as the first one, for all the fields.
Task 2 - creating a way for the data to be sorted. For example all Manufacturing; all plastic/rubber within Manufacturing; the previous two by Country, and by state within each country.
Submit separate quotes for each Task.
Task 1 - is to consolidate the data for each company into one line from 3 sources
Task 2 - is to create the ability to sort the data as required.
Extra notes: In the Example file attached, I started the process of developing one line of data per company. I only did 2 indicating the Company index.
I started doing the sums (everything is averages) vertically for the 3 above, and horizontally for each 3.
The full file contains about another 100 companies.
Task 1 - refers to creating the single lies of numeric format data as the first one, for all the fields.
Task 2 - creating a way for the data to be sorted. For example all Manufacturing; all plastic/rubber within Manufacturing; the previous two by Country, and by state within each country.
Submit separate quotes for each Task.
Jerry T.
100% (3)Projects Completed
5
Freelancers worked with
9
Projects awarded
50%
Last project
30 Mar 2015
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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