Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:01
in previous lesson, you have seen how to create people table
00:07
and this lesson. I'm going to explain to you how to use the table toe, create accompanying chart or to create something that is commonly known as paper chart.
00:18
So let's go directly to our
00:21
Excel sheet worksheet.
00:24
And here we have the original daytime. Let's create one,
00:28
ah,
00:29
table that will be useful for our explanation here. So let's go and create the people table. You'll use the same original source, and basically, I'm going to create here the same
00:47
shape off people table like I used when I started showing you the examples. So with a little difference, or we're going to add a month, the filters.
00:58
So we have all of this. And now we have all these numbers that represent how many successful resolutions of the case each of the
01:08
ah
01:10
technicians head on and how many total resolutions, bridge class and so on. And so So this is it.
01:18
And now
01:19
I'm staying in this, uh,
01:23
people table. It's important that you're somewhere within inside of it, so that self selected is within this
01:30
people table and you just go to people. Chart
01:34
and Did you choose the type off?
01:38
Ah,
01:40
charge you want.
01:42
So it can be history. Grant Majority can't be hist a gram or some other things because they're not therefore pill tables. But you can use, for example, cluster cone,
01:51
which is a very reasonable
01:55
idea for this kind of
01:57
representation. So parents is going to choose this one,
02:00
and we get this. So we get ah, failure category here
02:07
and it zero
02:08
and we can we can now filter it so we can just say Okay, we don't want thes we just to see
02:16
what happens with
02:22
the successful region, the resolutions of the cases and you can see
02:28
how it looks
02:30
or and it automatically the
02:32
the things from the table as well are hidden. So this is some kind of dynamic track that you can use
02:38
to look at Dayton graphical way
02:43
and analyze them or you can go back. It takes a little time for excel toe Reedus plate.
02:49
And you could say, OK, I just want
02:52
Pablo and Tamara,
02:53
and I want to see how they compare
02:57
and who is better. So we have just those two and their total number of cases
03:02
and, uh
03:05
we can do it separately for
03:07
just remember
03:12
and just December
03:17
Sorry, it takes time,
03:20
or we can go back to the cumulative
03:23
calculation for both months for which we have data.
03:29
So this is how you create the pivot chart,
03:32
and it's relatively simple
03:36
process, and depending on type of data, you might want to change the
03:43
type of chart you have so we can train, chart type,
03:46
say, Okay, let's go with lines
03:49
and sometimes lines. They're not the best thing to
03:52
show this,
03:53
but if you want to have all of them,
04:01
Yeah.
04:01
So this is, uh, this is not really showing this well, but I wanted to show you this because
04:09
the type of chartreuse is a very, very important for ah, what they were.
04:16
Ah,
04:16
are you trying to show because in this stable, be actually, don't see
04:21
a lot, you have to stretch it in order to see something useful out of it, and even then,
04:29
it's not that clear.
04:32
But you can see the trends that there is quite a lot off successful attempts
04:39
on, and then it's dropping down. And actually those those that they're not resolved it all that the most difficult ones
04:48
are
04:49
relatively high compared to, for example, those in which it was almost sold but given to the higher level of support to something like that.
05:00
So, uh, we have this chart. Let's change it back to the more reasonable
05:05
charts type, which is
05:08
colon chart.
05:09
For example, if you choose pie chart, it makes absolutely no sense because you get it just for one.
05:15
Because by chart cannot show these complex things, bar chart may make sense.
05:23
So Clustered bar.
05:25
It also makes sense because then you see here
05:29
as well. If you wanted to be positioned vertically
05:32
so you can play with this, you can find whatever you
05:38
I want to do with it. But most important thing is to have meaningful data that can be
05:44
used in people table. There are some kind of data that
05:47
it's really difficult to use them in a pivot table.
05:53
So this is all about people charts,
05:56
and I'm going to give you one more complex example in labs for this module in which you would go with the same kind of sales report data, and it's going to give you much more opportunity to tinker with in terms off.
06:15
What do you want?
06:15
To be displayed off course. First, you should,
06:19
uh, fulfilled the task given in their laps.

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