filmov
tv
How to create an Excel Customer Service Dashboard - Free Dashboard Template
Показать описание
How to create an Excel Customer Service Dashboard - Free Dashboard Template
In this video, I'll show you how to create an Excel Customer Service Dashboard using Key Performance Indicators.
Chapters:
0:00 - Intro
0:19 - Customer Service Dashboard: How to analyze call records
0:40 - Dashboard structure
1:06 - How to use the dashboard?
1:20 - Setup KPIs
1:55 - Linked pictures method
We have a large call records database on the data sheet that uses more than 8000 records. Our goal is to analyze the database and create a dashboard that uses KPIs, like the percentage of resolved calls and customer satisfaction. We need powerful comparison options between two categories. Therefore, we will measure the overall performance using different variables like locations, products, agents, and customers.
#msexcel #excel #exceltips #exceltutorial #exceldashboard
In this video, I'll show you how to create an Excel Customer Service Dashboard using Key Performance Indicators.
Chapters:
0:00 - Intro
0:19 - Customer Service Dashboard: How to analyze call records
0:40 - Dashboard structure
1:06 - How to use the dashboard?
1:20 - Setup KPIs
1:55 - Linked pictures method
We have a large call records database on the data sheet that uses more than 8000 records. Our goal is to analyze the database and create a dashboard that uses KPIs, like the percentage of resolved calls and customer satisfaction. We need powerful comparison options between two categories. Therefore, we will measure the overall performance using different variables like locations, products, agents, and customers.
#msexcel #excel #exceltips #exceltutorial #exceldashboard
0:11:54
0:03:42
0:16:17
0:03:16
0:15:54
0:00:56
0:01:38
0:01:01
0:14:52
0:18:18
0:09:52
0:02:15
0:01:37
0:01:34
0:00:51
0:05:28
0:03:22
0:06:44
0:00:44
0:02:35
0:00:34
0:01:09
0:02:47
0:04:12