Re-format and standardize customer database - Excel
$30-250 USD
Paiement à la livraison
This is probably best suited for someone who has good Excel programming skills, as well as some data entry and good accuracy and attention to detail. There are 415 records in the job file.
I have several different lists, each representing a different group, but they all need the same process applied. There will be 14 lists with an average of 300 records on each, with the smallest being around 170 and the largest being around 700 records.
You must have a very good understanding of English to complete this job well. I have these lists every now and then, so I wish to find a freelancer to use more than once.
• This job is a test to find a great freelancer to help on the larger project.
• It will focus on establishing a process and understanding on this 1 list, so that if done right I can have you do the other 13 lists as a separate job. Of course you will be much more efficient and faster on the other lists once you have figured out the best way to do this.
• Please price this job accordingly - that you will invest more time on setting up this first one, but the subsequent jobs will be much faster and simpler for you.
I want these lists to end up showing individual’s names in most cases – not the various other entities that are often used such as Trusts or other entities (Companies, or LLC’s, etc.).
Therefore, I want you to first separate each list into 2 sub-lists, and title them as follows:
1. “Names” (these will be all records with standardized names)
2. “Others” (these will be all of the Trusts , LLC’s, or other entity names)
The final product will be sending me the 2 lists in Excel format:
1. Names
2. Others
I wish to award this today, and need the finished list by Wednesday morning.
Please see the more detailed instructions and sample Excel file attached here. Ask any questions or for clarifications - it is critical that you understand this and do it properly, or it will be a waste of time for both of us. Along with your bid please make sure to outline what your approach will be to make this a fast and efficient process: will you use Excel formulas, programming, convert to another software to better manipulate then convert back to Excel, use some manual data entry or not, etc.?
Thanks,
Bruce
Nº du projet : #12076119
À propos du projet
Décerné à:
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Plus
48 freelances font une offre moyenne de 135 $ pour ce travail
ok sure i am ready to start immediately can we discuss? thanks............................................
Hi, I am good at Excel and vba. I have gone through the excel file provided. I have got good understanding of seperation of details. It is purely manual process. No automation is possible. Looking forward to work on Plus
Hello, as you are promising more offers I am offering you that price. However, I have good understanding of English and I love programming in excel I can show my works if it is needed but I love doing such jobs lik Plus
Hello Bruce, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. PS: I think the best approach here is to use formul Plus
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Plus
Hi! I am professional C/C++/C#/Java programmer. I can do this project with highest quality! Best Regards, Szymszteinsl
Dear Sir, Greetings. I have checked those 2 attached resources. The main goal is to separate the provided raw data base in 2 criteria, Name(Individual and Other(Company, Business,..), also Spouse/Partners Name, Ma Plus
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Plus
expert in excel and excel formula function, have done many projects in excel, have created many excel templates, expert in vlookup macros pivot table and charts, can complete it on time with good quality. experienced M Plus
Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating string, columns and rows. I checked your documents. My Plus
"Dear Client, Update: Thanks for your patience; I have reviewed your excel file along with word document and understood the job. I am ready to start on it. As you explained, for the first time, i need to setup Plus
Hi sir, I'll finish this task in max 24 hours. I can't download and preview the attached files, don't know why, it's not downloading, but as I understood from you very good description, I'm pretty sure that I'll manag Plus
Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if y Plus