Excel File Tracker to track customer home loan applications though the different stages - repost
$30-250 AUD
Completed
Posted about 11 years ago
$30-250 AUD
Paid on delivery
Track customer home loan applications though the different stages
The goal is to have a easy to use and display file that give you updated information at a glance without heaps of information which is hard to read, and make tracking customers loans easy for us and customer.
Customer details data will be entered manually by hand.
Different types of loans have different approximate completition times. (we will provide the amount of weeks needed)
e.g. when I update the type of loan of the application on the excel sheet
It should on the main sheet display automatically:
an approx completion date for the loan in the customer details
It should also list the required documents required for the customer to provide (this info will be give to u) in the customer details or provide the correct link to a pdf file depending on the loan type.
Example Customer details:
Should have:
Full Name, App #, comments field, progress updatable field, radio buttons to select different products sold to the customer, type of loan, appointment time for sign up etc...full details will be provided for all fields required for successfull bidder
The excel file needs to have an easy to use display (not standard excel) GUI which makes updating status, detail, commenting easy, to allow to see on main sheet everything in a easy to read format per customer.
Should also have a prinable page with a snap shot of all customers general info sheet.
The sheet needs to have the abilty to store and track large amounts of customer applications.
If you are an expert in excel and have examples of your work and the ability to realistically create what im looking for with the display I require please BID.
Hi, I am sure I can make the application works as you could imagine.
I am a "all the time" 5 stars awarded freelancer and have never failed even for a single project.
Feel free to check my profile page.
$150 AUD in 3 days
5.0 (184 reviews)
6.5
6.5
15 freelancers are bidding on average $180 AUD for this job
Hi
I am an avid excel user and macro programmer. If you check my profile, you will find that I have 100% delivery and 5.0 feedback record which is because of my steadfast resolution to only deliver best solutions and nothing else.
Important : Pls see PMB.
Ready to initiate the project straight away. I shall provide accuracy and quality of work. I have done similar type of project recently for a hotel. if you want i can provide you demo.
I have high level experience with this kind of projects, and I'm sure that at the end you will be pleased about my work. You can also check my profile.