Build me an excel dashboard for exchange mailbox reporting various aspects of emails.

Κλειστό Αναρτήθηκε Πριν 6 χρόνια Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

I need to start tracking average response times (I mean the time between when an email is received to when it is replied to), numbers of emails unanswered at the end of a day, email received per day (per inbox), etc from the customer service emails into our shared Outlook mailbox

Need this to track the SLA of incoming emails for the service desk with Microsoft outlook client 2016

Must haves :

1. Detailed Data for average response time for an email coming to mailbox

2. how many emails coming/going from desk on hourly/day/week/months...

3. calculate the response time from when at e-mail is received to when it has been responded to

4. SLA for the hour/day/week/months

5. Data should be in details so that customized reports and charts can be created through excel

6. everything should be embedded, including extraction of data from outlook or exchange in Microsoft Excel which means no manual stuff to load the data

will help you with more details if needed.

Εισαγωγή Δεδομένων Επεξεργασία Δεδομένων Excel Microsoft Access Microsoft Outlook

Ταυτότητα Εργασίας: #16526590

Σχετικά με την εργασία

4 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 6 χρόνια

4 freelancers κάνουν προσφορές κατά μέσο όρο ₹7845 για αυτή τη δουλειά

abhinovpankaj

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Περισσότερα

₹15555 INR σε 6 μέρες
(43 Αξιολογήσεις)
5.4
Rahul906342

A proposal has not yet been provided

₹1250 INR σε 2 μέρες
(0 Αξιολογήσεις)
0.0
alembaptista

In my profile, my skills are clearly described, I am a person who learns quickly and I like the transcription and writing part a lot. I have a degree in Administration, accounting and finance, I also did computer cours Περισσότερα

₹1240 INR σε 3 μέρες
(0 Αξιολογήσεις)
0.0