### Intro to Excel

Course
Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

### Video Transcription

00:00
Okay, We are now at the labs off module eight.
00:04
And, um
00:06
uh, in this lab's your
00:08
task would be to create some people tables out off road dated you were given in file model eight labs that ex Ellis X.
00:18
So let's go and see that road data.
00:22
And these are results from quality
00:27
testing in, ah, company that makes
00:30
gearboxes for cars.
00:33
So we had random testing off finished products.
00:40
Ah, total some five different
00:44
parts.
00:46
And we have eight different part makers, people who work in machines.
00:51
And we have three different test types. And for each of these test types, we have the expected value, and what we have is a measurement. And then, according to the measurement we declare, the tester declares, the part passed the test or fail.
01:11
So these are
01:11
random tests, not all the parts it tested,
01:15
also the type of the test and,
01:19
um is also suspected by random. So, um,
01:23
so here they are. There is quite a lot of them. And what we need to see
01:30
is, um,
01:32
the amount off failed and passed tests per
01:37
ah,
01:38
parts maker,
01:40
then for type a per per part name, sorry
01:45
and protest type. So we want to see if the testing, because with the test type, it should be pretty much equal.
01:53
Um, part maker.
01:57
There should be quite a lot of differences because it's it's testing the ability off the person
02:04
and for part name. It's also relevant to see, So
02:08
we just think you're let's say, sell it through.
02:12
We go to insert, we goto fill a table
02:15
and we just take okay because we want it on the new worksheet and, ah, the XL has automatically selected for us the
02:25
table arrange, which
02:27
is
02:28
this entire data set which goes all the way to road 300 months.
02:35
So you just click, Okay, we get the new sheet, we get the
02:38
people table feels that we can
02:42
put wherever we want. So we go first with part maker. So it goes into Rose
02:47
and then we have test results that goes into will use.
02:52
And we also want test results to go into cones.
02:57
And we got our first
03:00
they were table.
03:01
So we see here how many fails Each of these,
03:07
um,
03:07
people have
03:09
how many passes
03:12
and the grand total of testing per person, so This is random Sue seat, where ease from 33 to 41 test Because we picked our parts finished parts. It's random. We subject into testing and some of the people get there.
03:28
Parts tested a little bit more, but statistically so we have 300 tests, so it's ah,
03:32
it's a reasonable belief, statistically accurate testing. And we see that Bjorn is having the highest number off fails. And the Louisiana and Diego they have the this most number fails.
03:49
So this is the first,
03:53
uh, people table that we wanted to create. The 2nd 1
03:57
we again go back somewhere inside this and we go to insert and people table and we wanted to create the new worksheet again.
04:06
So we've got to now work, shoot three,
04:10
and now we're going to do pretty much the same thing.
04:15
So now we want the part name in the Rose
04:18
and we're going to do exactly the same thing. So we're going to put test result here,
04:25
and we want, uh,
04:28
just result in combs as well.
04:31
And what we get
04:34
is that Ah,
04:36
we have the biggest number of fails
04:41
in counter shaft
04:43
and but it's not so big difference that it would generate any,
04:50
you know,
04:51
notion that something is wrong with it. So the manufacturing process, this is the way we, for example, see if the manufacturing process has any particular
05:03
is prone to generating the fails. So the wrongly manufactured parts
05:12
and we see that this is all pretty much
05:15
on average. So So
05:16
this is this is okay.
05:19
And the 3rd 1 we go back
05:23
three clicks and we're here. We again go insert
05:26
the table.
05:27
Um, and then we click, okay?
05:30
And then what we want to do is to see if the test types generate the equal amount off fails.
05:38
So we go wrote to be test types,
05:42
and we won't test results here,
05:45
and we want test results here,
05:47
and we see that we have identical number of fails
05:51
and the total number of tests are
05:56
around 100. So these this whole depth is a little bit
06:00
more there. So we have 110 cases of randomly generated
06:05
items that we picked from the whole bunch of new
06:10
the manufactured parts.
06:13
But it's all around 100 so very close to 1/3. And we have that we see that we have
06:18
identical number of failed. So we can conclude from this
06:23
that this testing methodology is rather good and that the
06:29
the conditions we set for fail or pass
06:32
are actually really well done.
06:35
So
06:38
06:40
Ah,
06:42
this lab's
06:43
And if you have done it by yourself, it's good if you have ah seen this test as well. This is this example and did
06:54
step by step like I did. It's also okay. I would have appreciated that you have done it by yourself from the beginning. But it's up to you,
07:03
so thank you and bye.

### 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

Milan Cetic
IT Security Consultant
Instructor