Extract data from 17 excel documents and create master file with filter criteria (need done today)
$10-30 USD
Completed
Posted over 1 year ago
$10-30 USD
Paid on delivery
Please let me know if you can do this within 24 hours.
Before copying data to main excel sheet-
1. Delete all rows that contain following keywords in company name, website, or email: Farmers, progressive, insurance, geico, university, school, academy, foundation, nonprofit, kinder, welch, waldorf, college, and .edu.
2. Copy all rows into the master document that contain one of the keywords in the “Job Title” column: partner, founder, owner, lawyer, attorney, marketing, intake, reputation, sales, shareholder, director, president, and manager.
After all cities are copied to main data sheet
1. Delete duplicates (determined by email)
2. Delete all rows that do not contain an email address.
3. Save as both xlsx and csv format.
4. Name the state name. For example, “Pennsylvania law firms”.
Hello Sir,
I have done many virtual assistant projects, data entry and web scraping before. You can review my profile and see my clients feedback.
I am ready to start right away.
I am fast learner. I am familiar with Slack, Google Spreadsheet, Excel, word etc.
Thanks
$20 USD in 1 day
4.9 (161 reviews)
6.8
6.8
25 freelancers are bidding on average $31 USD for this job
Hello sir
I am Ahmed, a GOOGLE certified data analytic with very good skills in spreadsheets [(Google sheets and Excel); including advanced formula, macros, power query and pivot tables], SQL and R-Programming language, also in data processing, cleansing, organization, and integrity. I achieved many excel projects and finish them with 5 stars and excellent reviews So, I can achieve this task perfectly.
If you are interested in my offer, please feel free to contact me to discuss the details.
Regards
Ahmed
Hello,
We are a Professional Deep Data Miner, Data Scraping, Data Entry Operator and Lead Generation expert in since 5 years. We carefully read your project description. We learn that you need to Extract data from 17 excel documents and create master file with filter criteria (need done today)We can assure you that you will get 100% Quality of work from us.
*24/7hr service
*100% error-free
We always believe in satisfaction of customers and 100% Quality of work.
Thanks
World Data Service.
hello
I can do this project very quick. Maybe within few hours I think is possible to do all 3 month data together
I will do it using Excel VBA . It's very powerful app for like this cases
I have 15+ year experience of Excel, Excel VBA, Python and 100% feedback
So, you can trust to me. Result will be excellent
Best Regard
"Dear employer,
I had read your requirement for Extract data from 17 excel documents and create master file with filter criteria. I am expert in this field. That's why I placed my bid on this project. I'm a professional in data entry, web scraping, data analysis, excel VBA macro, BI Developer and I can start your work immediately right now. I will be available for any query round the clock even if the project is completed.
Please award me this project so that we can discuss it more. Hope I will get a chance to work with you.
Thanks and Regards,
Trusted Hand Service
(Bring The World Nearst To You)"
""""""""""""""""""""""" I AM READY TO START THE WORK RIGHT NOW! """"""""""""""""""""""""""""
Hello Sir/Ma'am
I understand your project description.
I think you are looking for someone for your project who can Extract data from 17 excel documents.
Waiting for your response. Thanks!
Hello,
I am very interested in this job, i have Excel certification and can work on spreadsheets formating and data entry .
I can deliver this work before 24h before your deadline.
I am ready to discuss further details about your project.
Best regards,
Nassim Rebib.
It will be great opportunity for me if you provide these work plus i assure you that i will do the work on time with much dedication and hardwork and there will be no complaint from my side too
I have a decent typing speed of 190 characters per minute and 99% and I have been doing Excel projects since 2 years. I can do all your desired work in minimum time and maximum accuracy.
Hi,
I am Md. Aminul Haque, as a professional freelancer in delivering the best quality and accuracy projects. Client satisfaction is my first priority. For more details just message & attached file so that we can discuss your order.
Best Regards
Md. Aminul Haque