Customer Management excel spreadsheet with form and reports

Closed

Customer Management excel spreadsheet with form and reports by category:

1st page is a form

Capture Customer Details

Fields:

Name (textbox)

Phone Number (textbox)

Email (textbox)

How did you hear about us (textbox)

Unit Size : drop down list - entered on another page (page 6)

Location - (textbox)

Date of Occupation - Date Picker

Require Transport - From Where (textbox)- To Where (textbox)

Tick Box - invoice or quote

Date to follow up - calendar date picker

Customer Search Box

by name or invoice number

__________________________

Page 2 is customer list

tick box next to customer name

field (Paid or unpaid)

if paid - then enter date of payment

if paid then enter date of occupation

if quote then option to convert quote to invoice

option - customer is not taking unit (tickbox) - if ticked then -> enter Reason - keep customer in database but remove from outstanding quotes and invoices list

Page 3 display outstanding quotes and invoices list with dates and customer names and quote or invoice number

Page 4 - follow up Calendar

Add Customers in their follow up date on calendar

Page 5 - Reports page -

total outstanding invoices and quotes list -

areas by popularity

unit sizes by popularity

graphs to show a selected months amount of bookings and area

Skills: Excel

See more: customer management spreadsheet, customer management excel, customer management excel spreadsheet, spreadsheet customer management, customer follow spreadsheet, excel customer management, excel spreadsheet customer management, excel customer management spreadsheet, customer payment spreadsheet, customer follow excel spreadsheet, customer details excel, excel follow spreadsheet, customer details form excel, quote follow spreadsheet, customers follow excel spreadsheet, customer management form excel, customers follow excel, payment details customer spreadsheet, follow excel spreadsheet, customer follow excel, customer excel, customer management excel form, search graphs, about graphs, follow customers spreadsheet

Project ID: #753114

Awarded to:

florinserban

Hi. Please check PM for details. Thanks!

$50 USD in 2 days
(2 Reviews)
3.2

13 freelancers are bidding on average $89 for this job

nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$100 USD in 5 days
(39 Reviews)
5.4
nsurani

We have both passion & expertise to do the job well within specified time & budget.

$300 USD in 0 days
(4 Reviews)
3.1
wemas

:-) Kindly check pm

$35 USD in 1 day
(0 Reviews)
0.0
briscoedarling

I am proficient with Excel. I am very accurate with my entry and thorough with my proofreading to insure accuracy.

$74.99 USD in 7 days
(0 Reviews)
0.0
jkumarshiva1

Please read my PM

$36 USD in 0 days
(0 Reviews)
0.0
mariamass

I am very good at excel and other data entry programs, experience about 27 yrs.

$31 USD in 2 days
(0 Reviews)
0.0
faisalakram7997

I am ready to worn on this project.

$70 USD in 7 days
(0 Reviews)
0.0
Kudzo

Please kindly check pm.Thank you

$30 USD in 2 days
(0 Reviews)
0.0
rembranti2010

I am ready to work

$50 USD in 5 days
(0 Reviews)
0.0
FizaZahir

Hi, I am a software quality engineer by profession. I will deliver a quality work with the given time period.

$150 USD in 2 days
(0 Reviews)
0.0
Nicerfreelancer

I am ready to start working on this project

$30 USD in 5 days
(0 Reviews)
0.0
dovesol

Plz check PMB for details.

$200 USD in 10 days
(0 Reviews)
0.0