Filter some data on excel to take out double ups

$10-30 USD

En curso

Publicado

hace casi 5 años

$10-30 USD

Pagado a la entrega

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

ID del proyecto: 20337560

Información sobre el proyecto

4 propuestas

Proyecto remoto

Activo hace 5 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 2 días

5,0

(1 comentario)

1,0

4 freelancers están ofertando un promedio de $36 USD por este trabajo

@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 en 4 días