Find Jobs
Hire Freelancers

I need to automate a database cleaning process in Excel

$10-30 USD

Cerrado
Publicado hace alrededor de 3 años

$10-30 USD

Pagado a la entrega
I need to automate a base cleaning process that consists of the following: Initially you have to delete some columns that I don't need and leave only what I need. After that I have to separate the entire row into a different file depending on a field in a cell. For example I have a base that has: Name | Phone | Email Favorite color | And I only need that in my exported sheets at the end this Mail and Favorite Color On one page, all the people with a favorite color "red" should come with their email (only those two columns, the others should be deleted), in another file, all the people with a favorite color "green" with their email, in another those of the color "blue" ... etc
ID del proyecto: 29363143

Información sobre el proyecto

40 propuestas
Proyecto remoto
Activo hace 3 años

¿Buscas ganar dinero?

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
40 freelancers están ofertando un promedio de $20 USD por este trabajo
Avatar del usuario
Hi there, I have understood the Project I can develop a simple macro for this, it will delete the rows or columns that need deletion and prepare a seperate Excel file within which we can have sheets based on colour. We are a team of trained professionals with years of experience in Ms Excel and VBA. Hit us up and we can talk in detail. Regards, Nikita And her team at Affiliazion
$15 USD en 1 día
5,0 (41 comentarios)
6,3
6,3
Avatar del usuario
Hello I'm an excel professional experienced in these sort of automation. can we discuss your request? John
$35 USD en 3 días
5,0 (162 comentarios)
6,3
6,3
Avatar del usuario
Hi there, I can help you with your database cleaning project based on your requirements . I have 7+ years of expertise in Excel/VBA, SQL, Power BI, Tableau creating complex automation tools, formulas, databases, queries and macros etc. please message me to discuss more. Regards, Ravinder
$30 USD en 1 día
4,9 (126 comentarios)
6,0
6,0
Avatar del usuario
Hello, I went thru the description Contact me and I will start the task RIGHT NOW I look forward to hearing from you Thanks Regards Thushara
$30 USD en 1 día
5,0 (36 comentarios)
5,2
5,2
Avatar del usuario
Hi, I'm interested on this post. I have an advanced knowledge on Excel's different formulas including pivot charts and visual basic coding. I can help you finish this work as soon as possible.
$18 USD en 1 día
5,0 (73 comentarios)
5,1
5,1
Avatar del usuario
Hi there, I am an expert in excel, database programming, Access, VBA and data processing. In this regard, I am going to automate the process of cleaning your data as you have described. I am ready to start working on your project now. Please contact me for more information. Thanks.
$20 USD en 1 día
4,8 (45 comentarios)
4,8
4,8
Avatar del usuario
I have more than 5 years experience in typing & expert in Web designing. Also an Educator & Having good typing speed, knowledge of relevant computer applications, attention to detail and accuracy, written comprehension, ability to perform under pressure, organizational and planning skills including time management and prioritizing, confidentiality. Give a chance to prove myself and finish your work faster than anyone can. Thank you
$10 USD en 3 días
5,0 (11 comentarios)
4,1
4,1
Avatar del usuario
I can do this project right now with 100% accuracy. I understood your project description. I am an expert in Visual Basic, Data Processing, Excel, Microsoft Access, and interested in your project. I work efficiently and will finish on time, and will provide high-quality work. I have done this kind of job in the past. You can check in my profile with a helpful review. I am waiting for your quick positive reply, and If you need any samples, please let me know. Thanks
$18 USD en 2 días
4,9 (9 comentarios)
2,9
2,9
Avatar del usuario
Greeting! My name is Vipin Kumar Garg and I am a software engineer (MCA). I have 20+ Yrs. Exp. in MS Excel VBA (Macro) and MS Access. I have developed around 500 macros & modules for the global sales team, paper mill, manufacturing companies and upload data on websites, send Emails as automatic, etc. I have worked in 200 million data in SQL Server. Created google sheets for an automation process. Examples: -  Market, Portfolio, Funnel, Revenue, Vision and True North for (Sales Playbook)  Module for paper size cutting (stop for wastage)  Macro for purchase paper reels (as per requirement)  Macro for finance balance sheets for maintaining as (opening, closing & GST)  Module for data entry (inward & outward material PMS & IMS)  Macro for send automatic Emails for customers by the sales department  Module for PIR as production process as machine wise.  Customize the ribbon in excel VBA with XML by “Custom UI Editor for Microsoft Office”  Scraped data from websites in excel with formatting  Created database in ms access and SQL server I am a new freelancer but I have good experience, I can work on your project at the lowest rate, please let me know a time for discussion with you
$10 USD en 2 días
3,8 (1 comentario)
1,9
1,9
Avatar del usuario
Hello sir, I read your description and I understand all the requirements and I am experienced in database data extraction also i have been working on similar project before. If you give this job to me I will do my best to deliver a quality product in time and I won't disappoint you. Thank you.
$20 USD en 1 día
5,0 (1 comentario)
0,7
0,7
Avatar del usuario
I see you need some help in data cleaning automation. I will be pleased to work with you :) I'm a certified data analyst, I have a nanodegree in advanced data analysis and statistics. I worked on data analysis in python (Pandas, Numpy, Matplotlib & Seaborn) for two years including: - Data integration from different sources - Data wrangling / cleaning / processing - Statistical inference and interpretation & data analysis - Reporting and visualization - Visual Dashboard designing I can write a python script for you to perform this excel cleaning process automatically In-shaa Allah. Do you have any questions for me?
$20 USD en 2 días
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
I have gone through your project details and I am sure that I will accomplish it. So, I am ready are you. see in you in the inbox to get it done ASAP. your regards Abhishek
$10 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello! Sir, I can understand your work. I am professional and very efficient in data entry working. I can complete your task within the timeframe. Customer services are my first priority. My primary goal is to satisfied my clients 100%. I'll be very thankful to you if you award me the project. I'll be looking for your forward response. Thanks.
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello! I have been using Excel since my university projects. So I believe that I can Handel your project effectively.
$20 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Greeting Sir, Hi ,My name is Noor Ariffah Chung Abdullah. I know excel ,word and different types of skills of typing and data entries. I can do all types of work in excel. Hence, I can say that I am data entry expert and I am available 7 day in week. I am available to take up to the work immediately and Will complete the task before deadline. I look forward to hearing from you.
$17 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi Thank you for your project description I love to work with you. I have understood what you want and how to deliver quality work to you Thank you sincerely Bibek tamang https://www.freelancer.com/u/Ben123Ben123 (My profile)
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, This is Jaimin Patel. I have earned Diploma in Information technology . I have done such work in past. So, I am able to do such work in time frame.
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello sir I am interesting for the job. I am computer operator. I have expert team. I have 4 years experience.
$20 USD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I read your project details and want to work for you. I can easily do your job. If you want hire me then please accept my proposal. Thank you, vijendra singh
$18 USD en 7 días
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
Hello sir I am interesting for the job. I am computer operator. I have expert team. I have 4 years experience.
$20 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
Kishangarh, India
4,9
20
Forma de pago verificada
Miembro desde abr 20, 2019

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.