Excel Project "Customer Documentation Database"

Stängt Publicerat 1 år sedan Betalades vid leverans
Stängt Betalades vid leverans

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...

Microsoft Access Visual Basic Databasprogrammering Databehandling

Projekt-id: #36266635

About the project

16 offerter Distansprojekt Aktivt 11 månader sedan

16 frilansare har lagt bud på i genomsnitt $151 för det här jobbet

schoudhary1553

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 Mer

$220 USD inom 4 dagar
(428 omdömen)
8.3
AccountantArman

"""""""""""""""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 Mer

$166 USD inom 1 dag
(160 omdömen)
6.6
Giovanni704

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. Mer

$30 USD inom 1 dag
(38 omdömen)
6.5
zu02

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 Mer

$250 USD inom 7 dagar
(83 omdömen)
6.6
ravinderkumar248

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 Mer

$75 USD inom 2 dagar
(136 omdömen)
5.9
hamidr2020

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 Mer

$250 USD inom 5 dagar
(72 omdömen)
6.0
SandelaSolutions

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 Mer

$250 USD inom 10 dagar
(12 omdömen)
4.6
braincenter

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 Mer

$100 USD inom 4 dagar
(3 omdömen)
4.3
andrwojsz

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 Mer

$250 USD inom 8 dagar
(2 omdömen)
2.7
rainbow

I can work on Excel Project "Customer Documentation Database" Please share details of work

$140 USD inom 7 dagar
(3 omdömen)
3.1
Ezebuiroh82

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 Mer

$140 USD inom 7 dagar
(0 omdömen)
0.0
SeeProg

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 Mer

$140 USD inom 7 dagar
(0 omdömen)
0.0