Completed

Create A Customer Wait Time Dashboard in Excel

Seeking someone who is experienced in Excel Dashboard Creation. More description can be provided through private chat upon request.

Project Description

I have attached a data sheet in excel which is rough sketch of what we are currently working on.

[url removed, login to view]

Basically, we are trying to capture total customer wait time for our service. I would like to calculate the waiting times (in days) of various customers, depending on certain changes in flow of the customer through our service process map.

As the service cycle time changes the total CWT customer wait time changes. As we enter the data into the cycle excel should automatically make the calculation that where I need someone to write the formulas and make the dashboard look good. A fancy dashboard is not need just something that makes sense the viewer

Any suggestions to make this better would or alternative ways I would love to hear them.

Ideal candidate:

Good in excel formula calculations- basically good in excel

Meet Deadlines

Have some creatively using dashboards in excel a plus but not necessary

VBA experience a plus but not necessary

Prompt in returning communique

Can you file sharing software such as Dropbox,

Adhere to confidentiality with consultations

Ability to use audio conference software such as Skype

Use Team-viewer for screen sharing

Can use Slack for IM

MUST have good broadband connection

Please note: This is NOT AN EXCEL DATA ENTRY entry job but rather technical job.

NOTE: Will consider bids above the max bid ceiling for those who have a proven track record..

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic

Näytä lisää: we need to create a bill format in MS Excel for the patrol pump, how to create a data entry form in excel, create a calendar in microsoft excel, excel dashboard tutorial, customer service dashboard template, customer service dashboard metrics, customer service dashboard examples, customer service excel template, excel dashboard templates, free excel call center dashboard templates, service desk dashboard + excel template, excel, how do i create a data entry form in excel, a customer signs up for the 3-at-a-time program, please create a dashboard mockup and icon of an app to be developed named homework suite homework suite tracks student assignmen, create a leader board to record weekly high scores for my word game, create a excel, create social media dashboard excel, create php dashboard excel data, create dashboard excel google analytics

Tietoa työnantajasta:
( 3 arvostelua ) dallas, United States

Projektin tunnus: #15681863

Myönnetty käyttäjälle:

insidenetsoft

Hello, I am aware of the importance of your project and I would like to participate with my ideas gathered in my past years working with dashboards in excel. Relevant Skills and Experience - data processing and Lisää

$47 USD 2 päivässä
(27 Arvostelua)
4.3

29 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

shoguna2m

Hello, my name is Andrés. First of all, thank you for considering my bid. I am an industrial engineer with more than four years of experience in the simulation, process improvement and data analysis fields. Within this Lisää

$100 USD 5 päivässä
(66 arvostelua)
6.4
SShtv

I have a large and successful practical experience in data visualization and building Dashboards. Your task is clear to me and I am ready to execute the project for 75 USD for 2 days. Relevant Skills and Experience A Lisää

$75 USD 2 päivässä
(51 arvostelua)
5.4
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid. Relevant Skills and Experience Lisää

$10 USD 1 päivässä
(64 arvostelua)
5.2
nurnga1218

Hi, Waiting time basically is by calculating end time and start time. I have a question about those 2 items. Would be calculated manually or automatically or triggered by something or how? Relevant Skills and Experie Lisää

$30 USD 2 päivässä
(37 arvostelua)
4.4
$70 USD 1 päivässä
(17 arvostelua)
4.2
nelumindralal

Hi, I went through the description. This job is quite similar to my previous project. This can be done in 5-7 days. Price can be negotiated. 24*7 online availability. negotiations, after service I am looking forw Lisää

$100 USD 7 päivässä
(14 arvostelua)
3.9
chintuag

Dear Hiring Manager, I am an expert in excel ad would like to offer my expertise for your project. I have worked on several projects in excel. My expertise in excel includes, but not limited to: Macros, Complex Formu Lisää

$83 USD 4 päivässä
(9 arvostelua)
4.0
mikhailkozalski

I am a great excel expert. Relevant Skills and Experience Excel,Excel VBA Proposed Milestones $100 USD - all

$100 USD 1 päivässä
(6 arvostelua)
3.5
haleem0786

I have good command over MS Excel especially povit table, charts, advance formulas etc. do let me know more detail in PM. thanks

$60 USD 2 päivässä
(7 arvostelua)
2.8
nickret16

Hi there, you will need my expertise on making dashboards. I can deliver the job fast and accurate. Thank you. Relevant Skills and Experience Excel Dashboard Proposed Milestones $75 USD - Fast delivery of job.

$75 USD 5 päivässä
(6 arvostelua)
2.1
Dre24

Very experienced with MS Excel, Visual Basic and data management & analysis. I have 3+ years on the job experience utilizing these skills and would be happy to complete this task for you. Relevant Skills and Experien Lisää

$80 USD 5 päivässä
(1 arvostelu)
1.4
$55 USD 2 päivässä
(1 arvostelu)
1.2
vilas4all

m already working on similar projects.

$55 USD 5 päivässä
(0 arvostelua)
0.0
voblacksmith

Hello, I will be glad to take your project, because I’m working with VBA and high-level formulas, and this task one of those which I accomplish in day-to-day activities. Sincerely yours, Viktor Kuznetsov.

$55 USD 3 päivässä
(0 arvostelua)
0.0
SHhadun

Hello, I'm working as CRM analyst MS Access and Excel files are my daily work. So I'm very familiar with process and design of a successful project like this. Creating dashboards is what I do + vba Relevant Skills and Lisää

$50 USD 3 päivässä
(0 arvostelua)
0.0
Ashu1980

Will be working on this Dashboard to make it iterative and will cover all the aspects users wants, will accommodate the changes as suggested by user Relevant Skills and Experience In total 11 years of professional MIS Lisää

$100 USD 5 päivässä
(0 arvostelua)
0.0
awinqian

A proposal has not yet been provided

$83 USD 3 päivässä
(0 arvostelua)
0.0
sheiksuzanbabu

$50 in 6 days Stay tuned, I'm still working on this proposal.

$55 USD 6 päivässä
(0 arvostelua)
0.0
senthilm2506

I am very much interested to do u r job

$50 USD 3 päivässä
(0 arvostelua)
0.0
$47 USD 10 päivässä
(0 arvostelua)
0.0