يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
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.
