 in this presentation we will fill out the earnings record for the month of november from our payroll register to the earnings record the month of november being down here note that we have frozen the pains so if we should if you haven't had the pains frozen you can freeze the pains by going to a four view tab windows group freeze pains so we're going to scroll down to the data that we want to implement and that's going to be down here in november we're going to highlight this information so that we make sure to pick up the correct month so i'm going to highlight this whole thing and down to here and we're going to right click on it and let's make it green i'm going to make it this light green this time i'm liking the light green so we want the green ones and then we're going to go to the right and we're just going to enter this data remember what we're doing here this is the payroll register which is an order by pay period and then by employee within the pay period and we want to go to the earnings records and kind of flip that around the earnings records being in order first by the employee here and then having the pay periods so we're going to scroll up top our first employee is going to be anthony and we're going to say the filing information while here filing status first now note all the information will be the same why are we doing this because we need to tell our employees amongst other reports for our own purposes that what their total earnings were for the pay period as well as year to date so this gives us the summary of what's going on for an individual employee year to date okay so let's do that we're going to be here in a b7 i'm just going to say equals we're going to i'm just going to hold down the left arrow till i get to the end and then i'm going to scroll down looking for the green data we need the green data which should be november data there it is november data we're looking for anthony more want to pick up that m it's in b26 and enter there we have it so i'm going to scroll up just a bit there's the information b26 now we're just going to copy that across we're not going to autofill because that'll change the formatting we're just going to right click and copy and then highlight and then select the cells next to it and then we're just going to right click and paste the formulas only just the formulae and there's a problem with the clipboard but it seems to have done what we asked so i think we're good so now we have the net pay here and we have the gross pay and all the withholdings for both the pay period as well as the totals we'll do the same thing now for cindy lewis so we'll be down here in a b14 within a b14 we're going to say equals we're going to hold down the left arrow till we hit the wall and then we're going to go down to the green data green data we're looking for cindy lewis so there's cindy lewis we're going to say pick up the marital status and enter there we have it now we're just going to copy and paste that across the rest of the data so i'm going to put my cursor on a b14 right click and copy i'm going to select the data to the right or the place where we want to put the data i should say and right click and paste just the formulae so there we have that all right and now we're just going to continue this process for jill jackson so we're down here in a b21 we're going to say equals i'm going to scroll to the left to find our green data looking for the green data scrolling down there's green data there's jill jackson there's the single status that we're looking for we will say equals i'm going to scroll up just a bit and we're going to copy that right click and copy select the blank cells where we want to put the data to the left and right click and paste the formulas only all right we get to do this one more time then we have to stop because that's all the employees we have we're currently on jill jones jill jones we're in november we're going to say equals scroll left to that green data that we're looking for green data green data and here we have the green data m for jill jones and enter so there we have it now we're going to copy that formulae and paste it to the right so right click and copy select the cells to the right where we want to paste the relative formulas let go right click and paste one two three then we can double check our totals down here we're going to have to make i'm going to make this a little bit larger so we can see our data it's nice to see the data i'm going to highlight these two and make that a bit larger to see the data there we have it and then if we scroll down our green zeros our nice little green zeros we did last time will tell us that our total earnings here match what we have on the earnings records to the payroll register but let's just double check the two best ones check we can say total earnings are 193 12850 and 112 101 so this is probably the best number to check so i'm going to go back over here and scroll down our totals down here also need some widening of the columns let's do that and then here's the 112 101 so same data formatted a different way off the payroll you