00:00In the previous video, we learned how to calculate the debit, credit, and total for the entire account.
00:07We also decided to make copies of the January edition, so we have another copy for Capi or another copy for February.
00:14We start the rest of the months of the year in the same way until we finish December.
00:20After that, we will start to do something with the ledger.
00:23The ledger is where I start collecting all the numbers or all the amounts that were in the seventh sheet.
00:31I will start by saying how do I do this? I will also make a copy of any of them.
00:36Click on it, it's free
00:38I will do it in the end, I will say Creta Kabi
00:42He calls it the ledger.
00:45good
00:49I came to it instead of here. This part is called history.
00:53I will start by calling it months
00:57And he writes for him the months of the year starting from January
01:01I will drag him to complete the rest of the months until he reaches December
01:11These are the months of the year, but of course I want them to be regular. I don't want them to be like this.
01:16I'll start by telling him that her angle is from Control One.
01:20May Allah make her angle zero so that it will be fine with me
01:26This way and my biggest space
01:30Okay, nice, or do you do this every month?
01:32I want here in the total to start so that he brings me the total for the city for the month of January
01:38It starts if I stand in the cell and it says equals
01:41I will go to January, January's tuition or January's worksheet
01:47And the city's total, I click on it so that it brings me what is in this cell and I press Enter
01:53Here, I hear from the person who was in the city cell in January.
01:59If I stood on it, I would find that the devil of January is present
02:03After that, the exclamation mark, which is the name of the month of January, after that, F20
02:08I will start by pulling to apply this to the whole cell.
02:13Which cell starts if he hears its total for the month of January?
02:17If I want to return to my original format, I will start by selecting it and formatting the painter. I will start by returning the format to the first row.
02:28I will start here as well. I am the debtor for the month of February. I will press equals.
02:34I would like to see the total for the city for the month of February.
02:39Click on it in the total below and click on it
02:43So she will start listening to me and I will start pulling so that he can bring me the rest of my fields or the rest of the boxes
02:51And in order for you to get the same format, I will also start by making a copy of the format using Painter format.
02:57And I moved it and did the same with the rest of the months. I found that under the insomnia she started to listen to me.
03:06In this way, I have finished the teacher’s notebook and I was able to do everything in it. Come on, try it.
03:16Translated by Nancy Qanqar
Comments