WEBVTT

1
00:00:01.620 --> 00:00:07.290
William Rosener: Most African roesner welcome back in this short video i'll be walking through the requirements for the final exam.

2
00:00:07.710 --> 00:00:19.080
William Rosener: In the same area as you found a link to this video, you should also find a spreadsheet contaminants and data, in particular, dealing with safety and injuries and there's actually if we were to scroll down it goes.

3
00:00:19.710 --> 00:00:32.370
William Rosener: i've got 51 entries in the safety and entry data database So the first thing you're going to do is I create a V lookup, and this is going to be a two way, so I could enter and Davis.

4
00:00:32.910 --> 00:00:43.320
William Rosener: And if I take a look here injury occurred in the California plant, I came along and typed in to the person appear I typed in well I do Williams.

5
00:00:46.080 --> 00:00:55.920
William Rosener: I take a look at Williams, the injury occurred in a Georgia plan because that's one way, but I can also come up here and go whoa what was the injury tight.

6
00:00:56.520 --> 00:01:08.520
William Rosener: and take a look at Williams, that was a cut or I could take a look at the fact that the injury type injury location, gender, age group days last except for them, so I could take a look at them.

7
00:01:10.350 --> 00:01:16.140
William Rosener: Gender about employment, I do one more here, let me just come down here i'm seeing Wilson and let's get the plant.

8
00:01:18.150 --> 00:01:19.710
William Rosener: Some of the type in Wilson.

9
00:01:22.290 --> 00:01:24.990
William Rosener: And i'm going to come over here and choose the plant.

10
00:01:26.220 --> 00:01:32.580
William Rosener: And Sure enough, I take a look at Wilson, the plan is taxes next i'm gonna have you do is I create a pivot table.

11
00:01:33.000 --> 00:01:43.230
William Rosener: And here we're going to be taking a look at the some of the days last so you can have the various types of injuries long with the summation and the total days lost them.

12
00:01:44.070 --> 00:01:48.090
William Rosener: Okay that's the first two things finally well it's actually going to be a couple more things here.

13
00:01:48.510 --> 00:01:55.470
William Rosener: Then i'm going to give you some data and autumn do is have you see if you can create this chart here, trying to make it look almost identical to this.

14
00:01:56.190 --> 00:02:03.870
William Rosener: This is going to be a clustered column chart see if you can get a gradient felt maybe from why it doesn't have to be paying but to some other color there.

15
00:02:05.130 --> 00:02:10.290
William Rosener: also go ahead and let's see if we can get the access and increments of 30 even on.

16
00:02:10.890 --> 00:02:18.510
William Rosener: The points here let's have different colors for all the points and then also even go ahead and put some data labels above those points.

17
00:02:19.290 --> 00:02:27.360
William Rosener: Well, for you in this video here you quickly understand the requirements for the final exam so again it's going to be creating a view look up to the table.

18
00:02:28.650 --> 00:02:37.200
William Rosener: And then creating a chart given some data provided and there's probably at least one other requirement here as well, anyway i'm i'll catch you later thanks a lot bye.