Excel Project "Customer Documentation Database"
Budget $30-250 USD
Job Description:
Database (via Excel) of the documentation related to our customers (Enquiry, maintenance, monitoring, generating reports, ...) here are some additional details and considerations but not all :
1- Main Sheet which gathering all data together This sheet should serve as the central hub for all of your customer documentation include all relevant details for each document, such as the customer name and number, document code, name, description, date, amount, and expiry date, status of the document (e.g., accepted, pending, rejected), the name of the employee who processed the document, and any notes or comments that are relevant.
2- Customer Sheet: This sheet should contain all of the details related to our customers, including their name, address, customer number, relationship manager, and segment in addition to their contact information, industry, and any relevant notes or comments.
3- Standard Documentation Sheet: This sheet should list all of the standard documentation that customers are required to provide, along with a default description for each document. This will serve as a reference for our employees when they are processing customer documentation
4- Customer Enquiry Sheet: This sheet should allow us to quickly look up which documents a particular customer has submitted or is still missing. It should be designed in a way that makes it easy to search by customer name or number.
5- Entry Form: The entry form should provide an easy-to-use interface for adding new documents, amending existing ones, updating details, or deleting cancelled ones. It should be designed with data validation to ensure that all required fields are filled out correctly, and that data is entered consistently.
6- Incomplete Documents Report: This report should help track down any missing documents that are still outstanding for each customer. It should be designed to highlight any missing documents and provide clear instructions for how to follow up with customers to obtain them.
7- Expired Documents Report: This report should help keep track of any documents that have expired, along with the customer, segment, or relationship manager associated with each expired document. This will allow us to follow up with customers and remind them to renew their documentation as needed.
8- Dashboard: The dashboard should provide a visual overview of key metrics related to customer documentation database, such as the number of documents processed per day, the number of incomplete or expired documents, and the percentage of customers who have submitted all required documentation. This will allow us to quickly identify any areas that require attention and track your progress over time.
There are more information to be discussed in detail in later stage...
18 freelances font une offre moyenne de 150 $ pour ce travail
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Plus
"""""""""""""""ADVANCE EXCEL EXPERT""""""""""""""""""" "Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Plus
Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I would love to work together on your project and meet all the professional requirements and deliver quality work. Plus
Hi I've carefully read your proposal and I understood all. Although you need to solve it via ms Excel, my advise will be to solve it via MS Access. If you consider this, I'll detail all. Though , I can code it via ms E Plus
Hi there, I can create the database in excel or access 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 Plus
Hello, I am an Excel and VBA/Macro expert. I have thoroughly read the project details and offer my services to work on "Customer Documentation Database" (the database of the documentation related to customers) includin Plus
Hello, I hope this message finds you well, Thanks for posting such an interesting project. I'm the exact type of contractor you are searching for. Having worked on similar projects for the past 10 years, I can handle Plus
Hi - I went through your project description and my advice would be to have this work done in Microsoft Access. What you describe is a database type application, which would be very difficult to maintain in Excel. I Plus
Hi, I have read the description and I would like to create documentation management excel file which will allow you to add, modify, delete and search files. App should be able to read documents and modify them I am da Plus
***** Data processing expert ***** Hello As a creative and passionate developer, I am interested in your project and I hope to have the opportunity to help you. And also I have advanced proficients in data processing Plus
Ambitious professional with superior analytical and problem-solving skills. Offers familiarity with researching, capturing, analyzing, and aligning fundamental data with the view of ensuring stability and growth for th Plus
Hola, examiné la descripción de su proyecto y confirmo que puedo manejar esas tareas perfectamente, ya que soy un experto en Visual Basic, procesamiento de datos, entrada de datos, Excel, Microsoft Office. Estoy prepar Plus
This task can be accomplished in multiple ways with 1. Python interface with with excel as database with the seprate Dashboard Interface 2. Is with the Power Query in Excel but with the status of documentation will Plus
