 In this presentation, we're going to enter the data from the payroll register to the earnings records. We're going to do this for the second month of operations for our problem that being the month of September. We can see the payroll register on this side, the earnings records, we're going to have to scroll over to the right. We tried to put them on the same worksheet, which hopefully will be easier than having two different tabs, but we still have to scroll around a bit. Note the earnings record is in order by the name of the employee and then the pay period. If we scroll back to the payroll register, it's in order by the pay period and then the employees. So we're reversing the ordering in order to get the detail by employee rather than by pay period. Now, we need to be very careful to make sure that we're picking up the data from September and not another time period as we go over and pull this information. So to do that, we could try to do something like highlight possibly change the color of the pay period we're on. So I'm going to highlight our pay period here and just right click and go to make it green or something and say, hey, this is where we're pulling the data from. And we could do that even for the whole thing. We might just want to go through the whole thing here. Just highlight the entire process and say, right click, make it some different color like green. So now we're going to say, yeah, that's the one that's where we want to pull the data from. Make sure that we're getting the data from the right period. It's very common to to mix that up. Okay. And then the next thing I'm going to do, I'm going to scroll up a bit. And I want to keep the header rows here, whether I'm on the payroll register or the earnings record. So to do that, let's freeze the pains. So you want to be all the way to the top and then you want to put your cursor on. We're going to put our cursor on a four and then we'll go to the view tab up top. We'll go to the windows group and then we'll go to freeze pains. And then within freeze pains, we will freeze the pains and there we have no more pains or the pains are frozen. And so we're going to scroll down and there we have it. So now we're on this record and we can see that the headers will will follow with that. Now, if we go back to our earnings records, the pain is frozen too, because it was on the same cell. We're still going to have to scroll up and down here a bit and we're going to get used to this. The pains, you know, scrolling up and down with us. Okay, so then we're going to go to the filing status for Anthony. So we're an Anthony's earnings record for the second month, the month of September. And it's the same data. So all we got to do is use formulas to pull this information over. So within cell AB five, we're just going to say this equals and I'm going to scroll to the left. Scroll down to the green data and we're going to pull in that M in cell B 12 and enter. So if we scroll up just a bit, we pulled over in cell AB five. We pulled over the information from B 12. Now we can just copy that information over. Now I don't want to auto fill it over. It'll pull all the data that we want because it'll that'll change the formatting. So we're going to right click and copy. We're going to select every other cell and then let go right click and paste formulas only just the formulas. We don't want the formatting just the formulas and boom, it'll take it over and it pulls over the next cell each time, which is exactly what we want. It should be formatted perfectly to pull that over. And now what we're going to get here is we're able to tell our employee on the earnings record, not just what they earned that pay period, but what they earned year to date. So that's the point. Now we got the summary by employee rather than a summary by pay period. Now we'll do the same thing for a Cindy. So we're down here in Cindy and we're going to say for the month of September, we're in AB 12. We're going to say equals and scroll to the left. We're looking for the green data for Cindy. There it is. M right there for married and enter. So there we have it. So there's the M. It's pulling from B 13. Now we'll just right click on that and copy it. And we're going to highlight the rest of the area. Let go right click and paste formulas only. So there we have that. Once again, we got all the data in terms of total earnings and total earnings to date. Total earnings for the pay period, total earnings to date, total earnings for the pay total, total OASDI, Social Security for the pay period and to date, total Medicare for the pay period and to date, net pay for the pay period and to date. Okay, so now we're going to go down to the next employee and do the same thing. It's going to be great. So now we're on Jill Jackson. We're on AB 19. We're going to say equals scroll to the left. Scroll up to the green data. There's Jill Jackson. We want to pull that S over. So we'll say equals. And there's, there's the S that we want going to scroll down just a bit. Now we're just going to copy that right click and copy. Select the data to the right of it. And then right click and paste the formulas. So there's going to be that data. And once again, we have the totals here for the net pay and we've got the year to date total for everything. So we'll do this, I believe one more time. So we're now on Judy Jones in AB 26. We're going to say equals. I'm going to scroll to the left. I'm going to scroll up to the green data. And there's Judy Jones. So we're going to say enter. And now we're just going to pull that over. So the M in there is coming from B 15. So B 15. So now we can right click on it and copy it. Select the area to the right and then let go right click and paste just the formulas only. And that'll sum everything up for us and make these a little bit larger. So there we have that. So there's going to be our information. We could check this now with our totals down here. Remember we could total everything up. So our total numbers. And these are summing up each total for each individual. So in this case, we have total earnings of 96, 973. If we were to do that over here now, we'd have to total up our totals for all the payroll registers. Now we'll sum up the totals in the payroll register. So we're going to go all the way to the bottom here. We're going to put in a total for the year for the payroll register. Now to do this, what we're going to do is unfreeze the panes first. So I'm going to go up to the view tab. Windows group freeze pains and select that. And we're going to unfreeze the pains. That'll make it a little bit more screen that we can see. Then we're going to scroll down and we're going to put our cursor in F 41 and say equals. And then scroll back up. I'm just going to have to use a fairly long formula. We're just going to just to put every it's a simple formula however. So we're going to say here's the total for the first pay period, August plus. Here's the total for the second pay period. So F 9 plus F 16 plus. Here's the formula up top. And then we're going to go down. Here's the formula for October. Here's the formula up top. So F 23 plus. Here's November at F 30 plus December at F 37 and enter. So if we see that data, here's the actual formula equals F 9 plus F 16 plus F 23 plus F 30 plus F 37. And that gives us our total. Now I'm just going to copy that and it's the same relative formula for the rest of the of our totals here. So we can just put this to the rest of our totals. Just going to select our totals column or row down here. Let go, right click and paste. And I can just paste the first one because it should the format should be the same. And so there's our total. So it brings down the totals. If we double click on it, I'm going to make this a little bit larger here so we can see it. If we double click on anything, it should just bring down the totals. Looks like it's doing what we want it to do. So now we can see that our total for what is this gross total earnings is 96 9 30 73 for our register. If we pull that over to our total earnings record 96 642 and that's regular earnings. And then and then we have total earnings is this 96 973 so 96 973 here. And if we scroll back over, we've got the 96 973. The other one to check just to check one of these numbers. The best one to check would probably be the net pay. So net pay is this 55 971 34. And so we probably should check all of them. But this net pay is, you know, the sum 55 971 34. So that looks pretty good. Looks looks like we're tying out here and we just reformatted this data in order by employee rather than by pay period. Last thing we'll do is just ungreen this September area. So I'm back up here on B 12. So I'm kind of scrolling around bits of B 12. I'm going to highlight this information and make it blue again. So I'm going to select it and then right click on it. Select this little paint area. Now I have blue selected. If you don't have it there, this color blue, it's not on the wheel. It's not here. If you go to the more colors at the bottom and if you go to the standard colors, you'll get this little wheel thing. And I'm picking up this one right there. So that's the one we're using and enter other than that, of course, you could also go down here and format paint. If that was easier to do, you can format paintbrush this up here. Just make sure you don't format paintbrush the other format. I mean, in other words, if you were to do it that way, make sure you pick up the whole data set like this and then format paintbrush. And then pick up the full data set here so that you're not formatting one cells formats because that'll format more than just the color, in other words. So there we have that. And then I'm going to remove the color here. So this one's just white. So that one or clear. So it's not actually white. So be careful here. It should be no fill, no fill down here. All right. So that's it.