Find Jobs
Hire Freelancers

Create a functional Customer Database in Excel

$750-1500 USD

종료됨
게시됨 4년 이상 전

$750-1500 USD

제출할때 지불됩니다
The objective of this project is to create a customer database for a business that distributes construction materials. The customer database will include existing customers (see attached file, "Existing Customers_9.18.19") and potential new customers (see attached file, "Detail20191007071000"). For each customer or potential new customer, the database will include key identifying information including: Customer Name, Customer #, Existing Customer / Potential New Customer, Zip Code, Employee Count, Sales Volume, Primary SIC Code, Primary NAICS Code...potentially others. The database should be made such that it is easy to filter based on any piece of the aforementioned "key identifying information." An initial step for this project will be to map the "Existing Customers_9.18.19" file to the "Detail20191007071000" file such that there are no duplicates in the ultimate customer database and it is evident which are existing customers and which are potential new customers.
프로젝트 ID: 21666279

프로젝트 정보

62 제안서
원격근무 프로젝트
활동 중 4년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
62 이 프로젝트에 프리랜서들의 평균 입찰은 $957 USD입니다.
사용자 아바타
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$750 USD 5일에
4.9 (400 건의 리뷰)
8.1
8.1
사용자 아바타
Hello, I’m an Excel/VBA expert and I would like to help you with your database project. Please check my profile and contact me to discuss further details. Regards.
$750 USD 7일에
4.9 (418 건의 리뷰)
7.7
7.7
사용자 아바타
Hello! I see you have attached CSV and Excel file, but in the project description, you mention a database. Since CSV is a plain text file and Excel is not a database program, I believe you need to have a real database in MS Access? If the answer is yes, then I can help you create such a database the way you want it and I will import the data to the database which leads me to the first question: how to map records from CSV and Excel file? Also, I am interested will you have to import data from time to time or we will import everything at the beginning? We can talk about the details in the chat if you like. Also, please check my profile to see some samples of my work, reviews from other employers and things like that that do matter. Best regards, Branislav Mihaljev
$1,125 USD 7일에
5.0 (281 건의 리뷰)
7.7
7.7
사용자 아바타
Dear Client, I am an experienced VBA and Excel professional and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I am the one who believes in long term relationships and thus works upto client satisfaction to have them as my clients forever after. I have reviewed your job and ready to proceed to it and will wait for your response to discuss the further details and start the project. Warm Regards Ali
$1,125 USD 7일에
4.9 (169 건의 리뷰)
8.0
8.0
사용자 아바타
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will distinguish between existing and potential customers. Moreover, I will add functions to import records from a CSV file easily and I will add powerful filters that will retrieve filtered data quickly. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $900* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 330 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$900 USD 5일에
4.9 (320 건의 리뷰)
7.8
7.8
사용자 아바타
Hello Sir Im excel VBA macro and formula Expert :) i can do make functional customer database in excel like you want Sir please ping me now for discuss more and im able to start working right now after all clear :) Thank you Sincerely Galih
$750 USD 7일에
4.9 (393 건의 리뷰)
7.3
7.3
사용자 아바타
Hi there, What kind of database would you like to have :Excel, Access, SQL, noSQL? I can create whatever you would like to have ! Please feel free to contact me to discuss further details. Best regards Miljan
$750 USD 8일에
4.9 (150 건의 리뷰)
7.5
7.5
사용자 아바타
Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using diff tools like .NET, Excel and VBA, Winautomation, etc) and I'd like to help you. Please, get in touch to discuss and understand all the details in deep. Based on what we will talk, I'll be able to give you a good proposal. Experience building solutions like: Windows Desktop Apps (using Excel and VBA, Access and VBA, .NET,C++,C#, Winautomation) Scrapers Apps Scrape services Automation programs/bots Web apps/systems. Message me to have the whole idea about your project. Will wait for your contact. Thanks.
$1,125 USD 20일에
5.0 (196 건의 리뷰)
7.3
7.3
사용자 아바타
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$750 USD 5일에
4.9 (285 건의 리뷰)
7.1
7.1
사용자 아바타
Hi, I am financial experts and a guru in Math, Excel, and /VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database, especially with importing external files to a structured database in Excel and vice versa (+ automation with VBA). I work with advanced formulas, Pivot Tables, Visual Basic Application including available interfaces, graphical and visualisation reports, dynamic dashboards, user-forms, drop-down boxes, generator reports, charts (by scripts) and API (trading, google maps SQL etc.). Furthermore, I have experience in accounting, financial statements, consolidating, forecasting, budgeting, costing, cash flow, payrolls,multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I develop financial modules which incorporate complex components of business in a simplified and logical manner. I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.
$750 USD 7일에
4.9 (93 건의 리뷰)
7.2
7.2
사용자 아바타
*** I AM EXPERT IN MS EXCEL DATABASES *** Dear, we are Team of French + US. I propose to create your database in Access, it is much more reliable. Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$750 USD 9일에
4.7 (92 건의 리뷰)
7.4
7.4
사용자 아바타
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
$1,125 USD 7일에
5.0 (133 건의 리뷰)
6.6
6.6
사용자 아바타
Hello, I can build the excel database you want with the functionality you want as i have advanced excel skills and over 8 years in the field. Please check my portfolio to see my work. Thanks!
$941 USD 5일에
4.9 (57 건의 리뷰)
6.8
6.8
사용자 아바타
Hi, Would you like to see a quick sample list of your project on creating customer database of existing and potentially new customers which can be filtered based on any of the key identifying information completed before you award the project? You can consider it professionally done in less than 24 hrs. Rather than just show you past similar projects, I want to exceed your expectations by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks.
$750 USD 10일에
4.9 (59 건의 리뷰)
6.5
6.5
사용자 아바타
Good day, My name is Donna. I have read your project description and I feel with more detail I could complete it to your vision.  I would suggest Microsoft Access based off what I read. I can do either. I am a expert Microsoft  access database developer, I am also an expert in Microsoft Excel. I have completed all classes from beginner to expert in 2007 to 2016 Microsoft  Excel and Access.  I have created over 350 custom databases in 19 years.  I am fluent in VBA, Macros, Vba lookups, Mysql, complex formulas,  and many other excel and access functions.  I guarantee my work. After full payment if you have an error on my part or something stops working, please do not hesitate to contact me to get it resolved.  I have screenshots of past work on my profile.  If you feel my qualifications are a good fit for your project, needs please contact me.  If not best of luck. I hope you have a blessed day Donna
$1,333 USD 15일에
4.8 (45 건의 리뷰)
6.7
6.7
사용자 아바타
I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and we can move forward with your project.
$750 USD 3일에
4.9 (97 건의 리뷰)
6.0
6.0
사용자 아바타
Hello, I have worked on several similar projects to what you are looking for, and I am ready to assist you with your excel database, too. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Razvan
$750 USD 7일에
5.0 (18 건의 리뷰)
6.0
6.0
사용자 아바타
Hello, I can make you a web application or MS Access app to do this. Please share existing process and I can map the fields accordingly and make you wireframes of the entire application before. Ok i see the attached two sheets and can make you the app. So customers and also the executives are to be mapped? Do you also need a step to upload the potential customers into the system? How do you normally get the list of potential customers? Would you be adding these on the app iteself one at a time? Mostly things are clear. We can chat further for details. thanks, Bhawan Baweja
$1,470 USD 25일에
5.0 (6 건의 리뷰)
5.8
5.8
사용자 아바타
Hi, I have read your requirement and would like to help you with this project. I have experience in Visual Basic and Microsoft access and can develop you the database, as well as design a front end application using Visual Basic to retrieve the customer information based on the key fields you had indicated. And yes before starting this I will merge both the excel customer information across both the sheets and will remove the duplicates. I can complete this work in 7 days for a total of $750 USD. Please message me to discuss further.
$750 USD 7일에
4.9 (22 건의 리뷰)
6.0
6.0
사용자 아바타
Hi, there I hope all's well with you. I can code that within Ms Excel or if you'd like via Ms Access/with Excel automation. I'll detail in private chat. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects. Please visit :https://www.freelancer.com/u/zu02?w=f Thank you for your consideration. Best Regards, Zurab
$750 USD 7일에
4.6 (58 건의 리뷰)
6.2
6.2

고객에 대한 정보

국기 (UNITED STATES)
Houston, United States
0.0
0
10월 8, 2019부터 회원입니다

고객 확인

이 거래선이 등록한 다른 일자리

Create a functional Customer Database in Excel -- 2
$250-750 USD
감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.