Filter some data on excel to take out double ups

$10-30 USD

Đang triển khai

Đã đăng vào

gần 5 năm trước

$10-30 USD

Thanh toán khi bàn giao

I have a data analysis task. We need to sort out the contact details contained in several databases for the USA, Australia and Canada. These are contained in Excel documents. There are approximately 19000 USA entries between 6 documents (7500, 11000, 28, 180, 150, 120) I think . Each of these documents is currently formatted differently so the information is in different columns and they are in different stages of completion. · We need to combine these lists into a master list with all the information in matching columns. · We need to eliminate multiples of the same businesses that have the same email address. · Create 3 pages within the document. One with all the unique listings, one that has email addresses for all listings, and one that has mailing or physical addresses for each listing. · The Canadian lists are contained within the USA documents and need to be separated out into a Canada list document. In Australia we have about 7000 listings over 5 documents and we need to do exactly the same with those as for the USA lists. I also need the contacts pulled from all customers in USA and canda [login to view URL]

Business Analysis

Mã dự án: 20337560

Về dự án

4 đề xuất

Dự án từ xa

Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@pjlnel

Dear Sir or Madam, I am a South African based professional Accountant with a proven track record. My qualifications include a post graduate degree in Management Accountant with my main subjects: Cost Accounting Advanced Decision Making Techniques Enterprise Management Management Accounting Strategic Management Financial Reporting Financial Analysis I have over 20 years of work experience, ranging from accountant to CFO level. Some of my exposure and experience includes: Full Accounting Responsibility (Cashbooks, AR, AP, Management Accountants) Preparation of Annual Financial Statements HR and Payroll Financial and Risk Analysis Cashflow management Medium to Longterm Budgets Cost Accounting and Variance analysis Liaison with company auditors and preparation of the audit files I am an advanced Microsoft Office user with above average software skills. I am have read your project requirement and I am capable of completing the project on time. If you require any additional information, kindly contact me. Regards Phillip

$30 USD trong 2 ngày

5,0

(1 nhận xét)

1,0

4 freelancer chào giá trung bình $36 USD cho công việc này

@naimagul

Hi, I am an expert in Excel having vast data analysis experience using spreadsheets. I am proposing my services for the task. Let's talk about the project a bit more. Please message me. You have mentioned that data is in Excel but you are asking to create the document. I hope you are meant by 'sheets'. Please note I'm new on this platform, so I am proposing my services in a discounted rates. This way I also want to build a trust with you. Hoping to hear from you.

$25 USD trong 4 ngày