Find Jobs
Hire Freelancers

Create a functional Customer Database in Excel

$750-1500 USD

Closed
Posted over 4 years ago

$750-1500 USD

Paid on delivery
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.
Project ID: 21666279

About the project

61 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
61 freelancers are bidding on average $958 USD for this job
User Avatar
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 in 5 days
5.0 (735 reviews)
8.8
8.8
User Avatar
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 in 5 days
4.9 (615 reviews)
8.6
8.6
User Avatar
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 in 7 days
5.0 (517 reviews)
8.1
8.1
User Avatar
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 in 7 days
4.9 (203 reviews)
8.3
8.3
User Avatar
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 in 8 days
4.9 (178 reviews)
7.9
7.9
User Avatar
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 in 7 days
5.0 (303 reviews)
7.9
7.9
User Avatar
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 in 7 days
4.9 (437 reviews)
7.6
7.6
User Avatar
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 in 20 days
5.0 (198 reviews)
7.4
7.4
User Avatar
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 in 5 days
5.0 (341 reviews)
7.5
7.5
User Avatar
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 in 7 days
4.9 (97 reviews)
7.5
7.5
User Avatar
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 in 7 days
5.0 (194 reviews)
7.1
7.1
User Avatar
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 in 25 days
5.0 (8 reviews)
6.9
6.9
User Avatar
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 in 10 days
4.9 (75 reviews)
7.0
7.0
User Avatar
*** 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 in 9 days
4.7 (93 reviews)
7.4
7.4
User Avatar
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 in 5 days
4.9 (72 reviews)
6.9
6.9
User Avatar
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks .
$1,500 USD in 3 days
5.0 (13 reviews)
6.3
6.3
User Avatar
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 in 15 days
4.8 (44 reviews)
6.7
6.7
User Avatar
INTRODUCTION I am an experienced Professional with Database Programming and Administration skills across MySQL, MS SQL and Business Intelligence Development. I have 4+ years’ experience with Database Programming and Administration. I am also skilled in BI administration, building reports and customized dashboards and the ability to turn ideas into functional solutions. I possess ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008.
$1,000 USD in 7 days
4.9 (31 reviews)
6.6
6.6
User Avatar
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 in 3 days
4.9 (128 reviews)
6.3
6.3
User Avatar
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 in 7 days
5.0 (19 reviews)
6.1
6.1

About the client

Flag of UNITED STATES
Houston, United States
0.0
0
Member since Oct 8, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.