6 hours 3 minutes
okay, you have in previous lesson. You have been able to learn what the people table is,
and now we're going to talk about how to create one.
And it's relatively simple procedure if you know what your drink. And, uh,
we're just going to jump to excel,
and we'll go to our original data table with information about Ah, actually, a report about the support service is provided by some technicians in the Cole Center.
We have this date. I'm not going to explain it again. You have heard it in previous lesson.
We're going to just go directly into creating people table and we go to insert,
and the 1st 1
you see on the far left is pure table. And it's not by accident because people table there used all the time and quite a lot in especially in some business reports.
So we take on inter pivot table
and we get, uh,
the what, Excellencies is the data in which you have
ah, your original table.
And what also is important is that you must have this heather row in your table. Otherwise, Excel won't know how to name all these categories that you're going to use.
You can use an external data source or
there you can you can use Ah,
connection. But, uh,
we're not going to go there, So we're just going to use this data.
And this paper table of yours can be created the new worksheet. Or you can use the exact existent worksheet in which you have to place your location outside the original data
location on on your existing worksheet.
But we're going to go with new worksheet and just take okay.
And now we got sheet five, and it says original datum, a storage shed fighting it and contains people table, which is not formatted. So nothing is there.
And then you have
basically the combs,
and you want them somehow
placed in there
in order to
get the information from it.
So you have filters, you have columns, you have rose, and you have some well use.
So first thing, what we want to see with this paper table. So let's ah, we want to see how many,
off each class off error of issue resolutions. Each technician had.
So how many of those past and how many of them had
failure? Category of 123 or four.
So we're going to use failure. Categorias our main
source of information this con and we put it in Rose.
And then we have failure category 0123 and four.
And then what we're going to put in our columns are two questions.
And now we have Charlie, Jane, Pablo, Richard, Simone, Tamara and we have grand total.
And now we want to see how many off each of them
And in this case, we're going to move again. The technician cone. But now in some values.
And now we get what we want it.
So we have
we have count of technician because we had
How many times did they resolve
with zero with one? So this is not the sum. This is count.
And now we get Charlie had total 25 tickets.
Out of those, 25 18 were calculated. 18 were resolved
a cz past. So everything was okay. We had to with failure category 1212 and three with
And this is our table. Which tells us
One other thing that we can do is, for example, look at the average time to resolution. So we're going toe really find our table
and completely. And now we're going to remold these just like this
and we're going to now put our technicians in rows so we have them here,
and then we're going to have some values
time to resolution
But we don't want to look at the total time spent. We want the average time. So we're going to select these cells here
and click here.
you see this This is what you get when you look at properties of you when you right click on cells in
a favor table, not regular cell in the table.
And you get this summarized values by average,
and I will get a rich
we can also show well, yours as percent of grand total of con total wrote Toto.
We're going to
just show them as they are. But we're going to form of this cells because this is not looking good. And we wanted to be number
Sorry, not currency number, and we want to decimal places and no 1000 separator.
And we also do that here as well.
And now we get
Charlie's average time Jane's everytime Pablo's average time and so on and so on.
And now we want to sort these
so we can sort So we want the smallest first, because the shortest time to resolution is better.
And now we get that the Pablo is number one with just 309 minutes and 60 seconds 600.6 minutes. Sorry.
So, um, this is how you create your people table. So regarding on what you want to see and how you
put your daytime to these for
areas over your filters, combs and so on and so on
you get the different information. So let's ah,
see what the filters air there for.
Let's just drag month, two filters. And now we have all
and we want to see it separately for,
uh, just November.
And now it's like this.
So it's a different timing in November,
and we've if you go here
and we unsolicited number 11 and get 12 so we get it now for December
so we can Ah,
we can see that in December, Charlie was the best, because
the time is to 68.2
and this is how you can
with your pivot table
in order to get what you actually want to see.
this is about making your own people table. And in next lesson, I will be talking about how to create the chart that goes with this people table.