Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:01
welcome to Model eight, in which I'm going to talk about people's tables and people charts.
00:08
And the first thing I'm going to talk about is what are actually those people tables?
00:14
Well, by definition,
00:16
no,
00:18
or my loose interpretation of a definition of people Table
00:22
Babel Table in Excel
00:24
because we're talking of a pure table in excel is the extract off the significant information data from larger table.
00:32
So we have large table. And then we summarize this table in a way that suits our needs in order to express information in a desired way.
00:45
And the that information is contained in the original data. And we can use that using sums or averages or counting or other statistics.
00:56
So you have The definition is I wrote it on the screen and I'm trying to explain this'd in a little bit less sterile maenner
01:07
and let's go and just take a sneak peek on how
01:14
your table looks. So this is our original daytime. We're going to be using it throughout this module
01:19
for a ll the demos. And so this is this is one brother big
01:26
table.
01:27
It has some 200 plus entries which represent ah reports about activities off some people in Ah, it's a support center of Cole Center
01:42
and they were solving some issues that the customers had.
01:47
So what we have is we had months separately in a day with India Mentor date Ah ah, in a separate
01:56
ah
01:57
comb. Then we have the ticket number, which is not really important because they're all different. They're just the
02:05
serially determined ticket numbers. Then we have Who did the
02:13
the cook who took the call, the name of the technician. We have a customer name and then we have issued category which
02:20
there are 10 of them. So it can be softer issue, hardware issue whatever. They're classified in 10 categories,
02:28
then have ah, resolution can is it successor failed. So did they manage to resolve the case? The customer
02:37
for customer open the ticket and then we have a failure category. So it's fairly category zero. That means is it successfully resolved? And then we have 123 and four
02:49
and ah, this, uh, this represents the
02:53
so four is the most severe failure type in terms of they didn't solve the case. It all on DDE can be just that they didn't properly address it to the customer. So they did solve the question. But,
03:09
for example, didn't send him the mail or didn't get the confirmation from the customer. Whatever
03:15
s o, the ticket wasn't close. Although the
03:20
issue resolved so and then we have time to resolution in minutes.
03:24
And here is an example off people table I created
03:30
before,
03:30
and we have just
03:34
name off our
03:38
technicians
03:38
and their average time to result.
03:42
So we collected all their
03:46
times, and then we calculated the average for each one of them.
03:52
And we're not going to go into details now about how it's done, because I'm going to explain that in next lesson
03:58
on. And of course, this papal table could have contained much more information than just average time to resolution.
04:02
But the whole point is that using very simple tool that exists in Excel,
04:11
you could create this without any need for typing, any formulas, any conditions and the additional columns. Anything you
04:19
excel does it for you just have to configure it properly.
04:24
So, uh, this is all about,
04:29
uh what did, uh,
04:30
what people tables are.
04:32
And the next lesson you will be able to see how to create your own people table from the
04:40
original data table.

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor