WEBVTT 1 00:00:01.319 --> 00:00:09.330 Hello. Welcome back. In this video, you'll learn more about four months in particular will be entering some birthdays with that information will be computing 2 00:00:09.750 --> 00:00:20.310 And age long with whether or not the employees a RP eligible this American Association of Retired people number to remember the show the cinema soon. So it's a 15 3 00:00:21.000 --> 00:00:30.780 Minute. We're going to go ahead and compute the age of the average employee youngest and play the play number of plays less than 40 and how many are a RP multiple 4 00:00:31.260 --> 00:00:42.120 Okay, now we want to do want to create. Let's go ahead and get started. This point should come right over your open up Microsoft Excel and create a blank sheet here. 5 00:00:43.110 --> 00:00:53.100 On this thing just a little bit of time here. I've already got one partially filled in here. So I've entered a little information first name, last name birthday, he said. 6 00:00:54.000 --> 00:01:04.200 Why don't you go ahead and at least maybe at least put your birthday in here, but maybe you could put your own first name or last name, just so you can watch your age being computed here. 7 00:01:04.830 --> 00:01:14.430 Okay, so before I enter the birthday. That was all just plain text. I'm going to highlight these excels repressing this little icon right here you can see it's a date. 8 00:01:15.510 --> 00:01:25.470 I can switch up here from date to general etc there Romney is pressing this little icon right here. This is going to allow me to specify exactly the type of date. 9 00:01:26.070 --> 00:01:44.130 I want to choose date going to come on down here and I'm gonna go with a march 14 2012 and hit okay. So I've got month day comma here at this point of order some birthdays. And again, go ahead and make sure you enter least your own birth in one of these 10 00:01:47.070 --> 00:01:47.490 And 11 00:01:48.780 --> 00:01:49.920 Six. 12 00:02:22.560 --> 00:02:25.950 Okay, so hopefully maybe first name, last name, or 13 00:02:27.660 --> 00:02:31.680 At least, make sure you get your birthday here so you can see your HP and computed here. 14 00:02:32.100 --> 00:02:49.230 I'm going to break this up into several steps, someone have to actually keep format in the cell. If you did this all in one step, you won't have to okay if I want to compute a person's age. First thing I'm gonna do it well I'll formal start with an equal sign. I'm simply type today. 15 00:02:51.150 --> 00:03:13.500 Minus, it's gonna be today's date minus c to sort of take today's date minus c to let me hit Enter. Okay, well, this person would be 7536 years old or typically when we're going to face. We're going to run that to the year. So what I'm gonna do is first of all, I'm going to take this information. 16 00:03:15.900 --> 00:03:28.950 And divided by 365.25 that's because of the leap. Here they are here, this point this person will be a 20.63. Well, a lot of times you just simply 17 00:03:29.670 --> 00:03:40.230 Give the year and not a fraction. So the type im T parentheses and apprentices at the end. So I got it. That's going to turn the energy portion 18 00:03:40.770 --> 00:03:51.000 Going to take today's date minus this late divided by three and 6.25 will appear and then that's going to slam the person's age. Okay. Let me go ahead and 19 00:03:51.750 --> 00:04:01.170 I can repeat that process right Microsoft Excel generate this one was warming. So I'm just going to position my cursor on the film handoff and drag that on down to get those ages. 20 00:04:01.830 --> 00:04:19.230 Okay, I'm, again, I'm gonna assume a RP is 15 years older than a member of the society and we will at least get one person against that that 54 here. So I'm going to go ahead and come right up here on the type equals yeah let's take 21 00:04:20.460 --> 00:04:27.990 A look at this age is greater than 50 just fine. Yeah, so that's ID to. It's a great event break 22 00:04:29.370 --> 00:04:42.930 If I look right below there. I can see the Microsoft Excel. Give me a little information. So what to do. It's true. Well, in this boy. Yes, they want to do it so bones on this way. No. 23 00:04:44.250 --> 00:04:57.090 Okay, at this point on position my cursor on the one hand on the cross here today gone down and we can see all these oldest person that's 54 again. I'm assuming AARP is 50 24 00:04:59.220 --> 00:05:19.290 Tell you what, but again of what we're going to always want to do is illustrate the power of this I accidentally. Oh no, that person is really was born in say 49 well another 69 and yes they are a possible can. We have a few more formulas to work on down here age average 25 00:05:20.400 --> 00:05:21.150 Employee 26 00:05:24.300 --> 00:05:24.600 Page. 27 00:05:42.360 --> 00:05:43.620 Please less than 40 28 00:05:48.780 --> 00:05:49.500 Years old. 29 00:05:50.940 --> 00:05:51.900 Yeah, number of 30 00:05:54.000 --> 00:05:55.140 Employees 31 00:05:57.660 --> 00:05:57.870 Are 32 00:06:01.200 --> 00:06:14.880 Eligible okay we're gonna do is take this one line at a time. I'm gonna take these three sounds gonna go ahead and merge and center or repeat that process. I like a sauce rich and center. 33 00:06:16.650 --> 00:06:18.540 Take that information rich and center. 34 00:06:20.340 --> 00:06:29.580 Merchant Center and merged and center. If you want, you can actually maybe right click on Select all those in right align those 35 00:06:30.330 --> 00:06:43.590 OK, so the age of the average employee. I just need to average this out. So we take our niche to take d to colon. The southern specify range protector. 36 00:06:44.100 --> 00:06:54.090 So the average and plays 38 years old, they understand play what you only got six names. It's really easy to kind of chop up here in quickly that etc to stand out. 37 00:06:54.600 --> 00:07:06.060 But she's got like 100 or more employees. It's not quite so easy because the employee. It's going to be the men, and I could specify without a range. I could go, day two. 38 00:07:07.470 --> 00:07:08.430 Day three 39 00:07:09.510 --> 00:07:26.460 Day four day five to six. And this, I think you'll find that range actually works a little bit easier, you'll simply that's been simple be the max now simply go back with arranged the to call on the seven 40 00:07:27.780 --> 00:07:47.040 Ok now for the personal, it might be a little tricky here number employees that are less than 40 somebody have 1234 again I want to use the formula. So it should work regardless if I accidentally change one of those birthdays. So I'm used to count it function. 41 00:07:48.870 --> 00:08:08.700 And the first one is summer specify range and specify this exact same rate of interest fun de tu con these seven. So that's the range. If I look right below there from type and I can see the next one is the criteria and there it is. It's gonna be simply less than 44 my criteria. 42 00:08:09.810 --> 00:08:14.760 So I've got again 1234 please less than 43 00:08:15.780 --> 00:08:23.100 14. Okay. How many are a RP eligible, I can see it's to move. I want to write a formula to do that. Some of the account. Yeah. 44 00:08:24.390 --> 00:08:32.040 Let me go specify this range to call me seven an ottoman to do and some 45 00:08:33.480 --> 00:08:42.270 Yes. And I'm going to go, I want to make sure I think this might be case sensitive. So I've got a lower capital why restaurant or case here, let me hit 46 00:08:43.350 --> 00:08:45.240 Enter their own, you know, goodness. 47 00:08:46.350 --> 00:08:58.500 OK. So again, if I have come along and change this to 79 I'm going to say it's going to compute the person's birthday, whether AARP eligible no longer 48 00:08:59.160 --> 00:09:09.930 And it's going to compute all this information is going to have changed. Hopefully this video he learned a little bit about formulas and, in particular, working with age. Okay, so next video. Thanks.